PHP MySql Tutorial -> Update and Delete data

PHP MySQL Update The UPDATE statement is used to modify data in a table The MySQL UPDATE Statement In this chapter we will show you how to change data in a table. In PHP this is done the same way as a table or database is created. The MySQL syntax is sent to the server with the mysql_query() function. Updating Data In a Database Earlier in the tutorial we created a table named "Person", with three columns. We will use the same table in this example. FirstName LastName Age Peter Griffin 35 Glenn Quagmire 33 MySQL Syntax UPDATE...

Read More

PHP MySql Tutorial -> Select Data

PHP MySQL Select The MySQL SELECT Statement In this chapter we will show you how to get data from a database using PHP In PHP this is done the same way a table is created or data inserted. The MySQL syntax is sent to the server with the mysql_query() function. The SELECT statement is used to select data from a table. MySQL Syntax SELECT column_name(s) FROM table_name Note: MySQL statements are not case sensitive. SELECT is the same as select. PHP MySQL SELECT Example This code gets the data stored in the "Person" table. We use...

Read More

PHP MySql Tutorial -> Create and Insert

PHP MySQL Create MySQL CREATE In this chapter we will show you how to create a database and a table. This is done by using the mysql_query() function. This function is used to send a query or command to a MySQL connection. Creating a Database Create a database in MySQL with PHP. MySQL Syntax CREATE DATABASE database_name Now we use this together with the mysql_query() function. All we have to do is to add the MySQL syntax to the mysql_query() function. Example Here we create a database called "my_db": <?php $con = mysql_connect("localhost","peter","abc123"); if...

Read More