LoadModule php4_module c:/php/sapi/php4apache2.dll

<pre>
<h3>Press RELOAD to add a record to the MySQL database:</h3>
<?
//establish user connection
mysql_connect("localhost");
//open up database
mysql_create_db("testdatabase");
mysql_select_db("testdatabase");
//create table
mysql_query("CREATE TABLE newone(firstName VARCHAR(25), lastName VARCHAR(25))");
mysql_query ("INSERT INTO newone (firstName, lastName) VALUES ('John', 'Tester')");
//display the information
$result = mysql_query ("SELECT * FROM newone");
while($row = mysql_fetch_array($result))
{
print ("Added record: " . $row["firstName"]." ".$row["lastName"]."<br>\n");
}
//close user connection
mysql_close();
?>
</pre>

mysql_connect("localhost");

mysql_connect("localhost", "ajsmen", "password");

mysql_create_db("testdatabase");

mysql_select_db("testdatabase");

mysql_query("CREATE TABLE newone(firstName VARCHAR(25), lastName VARCHAR(25))");

mysql_query ("INSERT INTO newone (firstName, lastName) VALUES ('John', 'Tester')");

$result = mysql_query ("SELECT * FROM newone");

<?php
$conn = mysql_connect("localhost","root","sifra") or die("Konekcija nije uspjela!<br>".mysql_error());
mysql_select_db("imebaze",$conn);

mysql_query("CREATE TABLE newone(firstName VARCHAR(25), lastName VARCHAR(25))",$conn) or die("Neuspjeno izvrsavanje upita!<br>".mysql_error());

mysql_query ("INSERT INTO newone (firstName, lastName) VALUES ('John', 'Tester')",$conn) or die("Neuspjeno izvrsavanje upita!<br>".mysql_error());

$result = mysql_query ("SELECT * FROM newone",$conn);
while($row = mysql_fetch_array($result))
{
  echo ("Added record: " . $row["firstName"]." ".$row["lastName"]."<br>\n");
}
mysql_close($conn);

?>