×
Namespaces

Variants
Actions

Database use with PHP and mySQL

From Nokia Developer Wiki
Jump to: navigation, search
Article Metadata
Article
Created: sellis (29 May 2007)
Last edited: hamishwillee (27 Jul 2012)

PHP can be used for many purpose, one of those are connections to the database. Using the PHP the hole database structure can be created and edited. Variables can be used, so HTML forms can be used to add information to the database. PHP is also fast way to create several similar database structures. Only few local variables need to edit on the configuration file.

Here is example to create the table to the database:

<?php
include 'config.php';
include 'opendb.php';
$query = 'CREATE TABLE hoppy (car VARCHAR(20), model VARCHAR(20),
year VARCHAR(4), horsepower VARCHAR(4), torx VARCHAR(4))'
;
$result = mysql_query($query);
include 'closedb.php';
echo "You created a new table hoppy.<br />";
?>

Code has included three (3) configuration files (config.php, opendb.php, closedb.php), which information are needed to connect or close the connection to the database. Files information can be also added directly to the code, but this way makes it more clear and simple to use. Also information on one file is more simple to change than huge amount of files.

Config.php

<?php
// example of config.php
$dbhost = 'localhost';
$dbuser = 'username';
$dbpass = 'password';
$dbname = 'phptest';
?>

Opendb.php

<?php
// This is an example opendb.php
$conn = mysql_connect($dbhost, $dbuser, $dbpass) or die ('Error connecting to mysql');
mysql_select_db($dbname);
?>


Closedb.php

<?php
// an example of closedb.php
mysql_close($conn);
?>


When are created the table, it would be nice to put something inside it Here are used very simple HTML form to do it.

Example HTML form

<html>
<head>
<title>Form output by PHP</title>
</head>
<body>
<form method="POST" action="inputform.php">
<p>
Car <input type="text" name="car" size="20">
Model <input type="text" name="model" size="20">
Year <input type="text" name="year" size="20">
Horsepower <input type="text" name="horsepower" size="4">
Torx <input type="text" name="torx" size="3">
 
<input type="submit" value="Submit">
</p>
</form>
</body>
</html>

HTML form is calling the inputform.php, which insert the data the database

Inputform.php

<html><body>
<?php
include 'config.php';
include 'opendb.php';
 
$car = $_POST['car'];
$model = $_POST['model'];
$year = $_POST['year'];
$horsepower = $_POST['horsepower'];
$torx = $_POST['torx'];
 
$query = "INSERT INTO hobby (car, model, year, horsepower, torx)
VALUES ('$car', '$model', '$year', '$horsepower', '$torx')"
;
mysql_query($query) or die('Error, insert query failed');
 
include 'closedb.php';
 
echo "You insert ". $car . " " . $item . ".<br />";
echo "Thank you for inserting information to my database";
?>
</body></html>

It would also be nice to see that does that code really added something to the database. We can use PHP to check the content of the database.

This PHP code select all the table information on the alphabetical order by "car" and print out information on the table format

Select_all.php

<?php
include 'config.php';
include 'opendb.php';
 
$query = "select * from hobby order by car";
$result = mysql_query($query);
 
?>
<table cellspacing=0 cellpadding=4 border=1>
<tr>
<th>Car</th>
<th>Model</th>
<th>Year</th>
<th>Horsepower</th>
<th>Torx</th>
 
</tr>
<?php
for($counter = 0; $counter < mysql_num_rows($result); $counter++) {
?>
<tr>
<td><?php echo mysql_result($result,$counter,"car")?></td>
<td><?php echo mysql_result($result,$counter,"model")?></td>
<td><?php echo mysql_result($result,$counter,"year")?> </td>
<td><?php echo mysql_result($result,$counter,"horsepower")?> </td>
<td><?php echo mysql_result($result,$counter,"torx")?> </td>
</tr>
<?php
}
?>
</table>
<?php
include 'closedb.php';
?>

If you have MySQL, PHP and example Apache installed, you can test these code examples very simple. Only the variable data of the config.php has to checked suitable for your system.

This page was last modified on 27 July 2012, at 08:26.
57 page views in the last 30 days.

Was this page helpful?

Your feedback about this content is important. Let us know what you think.

 

Thank you!

We appreciate your feedback.

×