Updating mysql with php
You can change the communication package size by using the method, we close the connection.
Next we are going to create the query that will insert a new row in the database. If it is successful we will print the info that was added to the database. When you submit the form you should see your results displayed.The phpinfo() function will print these values clear as day.I highly suggest against this method of storing My SQL authentication information.As you can see we are inserting in the table called Test Table and were are inserting the fields ID, FName, LName, and PHON. The ID fields is left NULL because it is auto generated by the database. Now if you run the php file from part one of this tutorial you should see you updated info in displayed along with everything else that was in the database.So that is a very basic way of writing to a My SQL database using PHP.As long as your don't have multiple, possibly untrusted, users on your machine then that's OK.
But when you are running a large multi-user service with thousands of users its always possible that one of them will look at your files and take a note of the passwords you have in them.
You can read more about the problem at:(Link too long and had to be broken up)
Since mysql is on localhost, I can just enable named-pipes (which is how you should have mysql setup if you don't need networking) to get around the problem instead of the workaround listed on that page.
They could even copy them into their own scripts and modify your databases!
Even if local users are trusted, there is always the possibility of a rogue script (PHP or some nastier language) being installed by an ignorant user.
It is insecure and will leave your server vulnerable to SQL Injection attacks.