Inserting Data in PHP/MySQL v3 PHP Script

tutorial is going to be on how to insert data in to a MySQL table through PHP. This is in companionship with my ‘How To Retrieve Data’ tutorial found here .

‘Insert’:
To insert data in to a MySQL table, we have to use the ‘INSERT’ keyword command in our query statement.

Steps:
First we need to create the data we are going to insert in to the table. My previous tutorial used a scoring system (found here: ) the example so we are going to be using that table and insert some new ‘highscores’.

$scores = array();

for ($i=0;$i<3;$i++) {

array_push($scores, rand(1, 99999));

}

As you can see, we now create three new scores held within a ‘scores’ array. Each score is using our random function and so will be different each time.

Next we are going to run through each of our scores and create a query for each one. The query should execute upon creation and so we don’t need to get any returns or results from it.

To insert data through a query, we type ‘INSERT INTO {tableName} VALUES({data})’, like so…

mysqli_query(“INSERT INTO `testtable` VALUES (”, ‘1000’)”);

foreach ($scores as $key => $value) {

mysqli_query($con, "INSERT INTO `test` VALUES ('', '$value')");

}

We could then use our retrieving data techniques to see the new information…