Help needed with php website Programming Web Development by Classica Blue Need webmaster fluent in php/mysql to make ongoing updates to my fairly simple e-commerce website. Please advise hourly rate and availability. A lua script for enhancing grep Hardware and Software Linux and Unix by Lihui Zhang … need to search for, each on a new line, and save them in a text file: find -iname *.v > /tmp… Fine-tuning OpenAI GPT-4o for Multi-label Text Classification Programming Computer Science by usmanmalik57 …;.join(json_lines) ``` The following script saves the JSON file. ```Python # Save the JSON records to 'train.json' training_file_path = r"D… Re: A lua script for enhancing grep Hardware and Software Linux and Unix by Salem You can do this with `xargs` find . -name "*.c" | xargs -d'\n' grep -w "main" Or if you know you want to search the same set of files many times. find . -name "*.c" > tmp.txt xargs --arg-file=tmp.txt grep -w "main" xargs --arg-file=tmp.txt grep -w "void" Re: A lua script for enhancing grep Hardware and Software Linux and Unix by Lihui Zhang Thank you, Salem. The script has been modified and the efficiency has been increased by more than 50%. #!/bin/sh # # search text pattern in current directory. # usage: f pattern [file] # params="-E -n --color=auto" if [ "${2}" == "" ]; then find -iname … Re: Python - MySQL - Too many connections? Programming Databases by Dani …modifying the database. GET Requests: * Open a persistent MySQL connection at the beginning of the PHP script * Execute…PHP script POST Requests: * Open a non-persistent MySQL connection at the beginning of the PHP script * Start… PHP script * End the transaction * Close the MySQL connection On average, a rough guess is that each… Re: Python - MySQL - Too many connections? Programming Databases by cored0mp **Are you connecting to MySQL with persistent connections? ** Most coders close connections (remember…a loop. I haven’t a notion if python mysql connect API is thread-safe. High db connection … a single script opening and closing a connection to MySQL? Hmmm…** `grep -r 'mysql.connect' ../daniwebisthebest | wc 41 220 3928` … Python - MySQL - Too many connections? Programming Databases by cored0mp … choked when I fed it 1,000 records. It gave: mysql.connector.errors.OperationalError: 1040 (08004): Too many connections So I… Re: Python - MySQL - Too many connections? Programming Databases by Dani Are you connecting to MySQL with persistent connections? What happens if you don't use persistent connections? Also, I'm confused what you mean about it complaining about too many connections simply by you changing how many records a single connection works with? Re: Python - MySQL - Too many connections? Programming Databases by Dani > So I went ahead and made sure to connect.close() everywhere that I opened a connection How many times do you have a single script opening and closing a connection to MySQL? Is this a web script? Re: Python - MySQL - Too many connections? Programming Databases by Reverend Jim Generally it is hard to offer SQL suggestions without seeing the code. Are you closing the connection manually, or are you using a context manager? Re: Python - MySQL - Too many connections? Programming Databases by jkon Its hard in a Python script to "create too many connections" to a DB. You don't have many concurrent clients , you don't have web requests , is this a server of some kind ? . From your line " Specifically it was choking on a scanning algorithm." I thought that it might create a new connection for each query (or for a group). … Re: I'd like to create a js for a dynamic location Programming Web Development by toneewa … || document.write('<script src="https://cdn.jsdelivr.net/npm/jquery@3.5.1/dist/jquery.min.js"…jsonp", jsonpCallback: "unBounce" }); } else { // jQuery failed to load, use fetch as a backup fetch('https://api.snoopi.io… Re: How to optimize portfolio website Digital Media Digital Marketing Search Engine Strategies by Anam_5 …, use descriptive file names, alt text, and compression to keep load times fast. Make sure the site is mobile-friendly and… xseries interval in chart Programming Software Development by PM312 I have chart showing daily closing price of share for last 20 days. There is no closing price for Saturday and Sunday . However chart is showing blank space for these days i.e. total 29 days interval i do not want blank spaces but only 20 columns. Not getting how to do it. > Chart1.Series(0).Points.Clear() 'Getting … Re: xseries interval in chart Programming Software Development by rproffitt Think about line 9. Alter your SQL to omit weekends or only have M-F weekdays. Or where DAYCLOSE is above zero. Re: xseries interval in chart Programming Software Development by PM312 There is no data space for saturday & sunday in database . record count from datebase is 20. Re: How Can I Increase More Traffic of My Website? Programming Web Development by Amelia99 Start creating backlinks for you site so that you can get traffic and improve your SEO. Re: How Can I Increase More Traffic of My Website? Programming Web Development by m2host Use social media to promote your blogs. Convert Vb.net to C++ Programming Software Development by Mr.M Greetings, I'm having an issue, I want to set my form to display at the very top right hand side corner of a screen, I've achieved this in vb.net using this code `Location = New Point(Screen.PrimaryScreen.WorkingArea.Width - Width, 0)` Does anyone know how I can do this in VC++? Re: Convert Vb.net to C++ Programming Software Development by Reverend Jim Your statement does not set a form location. It just creates a point structure. To set a form position in C++ you can do SetWindowPos(hwnd, NULL, x, y, 0, 0, SWP_NOSIZE | SWP_NOZORDER); Re: Convert Vb.net to C++ Programming Software Development by Mr.M Thanks but it gives me an error `hwnd` undeclared identifier Re: Convert Vb.net to C++ Programming Software Development by Reverend Jim hwnd is the window handle returned when you created the window with CreateWindow or CreateWindow Ex. Or you can get the handle from an existing window via the title with hWnd = FindWindow(NULL, "Window Title"); Re: Convert Vb.net to C++ Programming Software Development by Mr.M Still this doesn't solve the error Re: Convert Vb.net to C++ Programming Software Development by Mr.M Now getting error `C2065 'width' undeclared identifier` And `'x' undeclared identifier` as well as y Re: Convert Vb.net to C++ Programming Software Development by Reverend Jim The solution should be obvious. If the error message says something is undeclared then declare it. How to Automate NAVIS Programming Software Development by Mr.M …now I'm trying to access it using vb.net web browser.It does load but the issue is that I can't…a button on my form. Heres how I load the page on form load Private Sub frmMenu_Load(ByVal sender As Object, …ByVal e As System.EventArgs) Handles Me.Load WebBrowser1.Navigate("http://41.162.72.195:9080/apex… Python Undefined Variable - Mysql Connector Programming Web Development by cored0mp …grateful once again for the advice to use MySQL over Postgres. It's been a pretty smooth…and have been getting an undefined variable error. Mysql is Running. I used the package manager to…to replicate it: import base64 import mysql.connector as mysql try: connection=mysql.connect( host="localhost", database… Re: Python Undefined Variable - Mysql Connector Programming Web Development by Salem I would suggest you do `pip list` in your working and non-working environments. It seems that `wrap_socket` is deprecated (and insecure) https://github.com/eventlet/eventlet/issues/795 I would have thought your `mysql` would have depended on the right version to begin with. Re: Python Undefined Variable - Mysql Connector Programming Web Development by cored0mp …2.0.1 more-itertools 8.10.0 mysql-connector-python 8.0.15 netifaces 0.11…MarkupSafe 2.1.5 mdurl 0.1.2 mysql-connector-python 8.0.15 netaddr 0.8…Debian really should have had this straightened out. Mysql-Connector is scarcely a niche library. It would…