|
<html>
<head>
<title>Adding a row to a table</title>
</head>
<body>
<?php
$user = "navioo";
$pass = "password";
$db = "navioo";
$link = mysql_connect( "mysql153.secureserver.net", $user, $pass );
if ( ! $link )
die( "Couldn't connect to MySQL" );
mysql_select_db( $db, $link ) or die ( "Couldn't open $db: ".mysql_error() );
$query = "INSERT INTO Employee ( ID, FirstName, LastName )values( '2', 'Joe', 'Sharp' )";
mysql_query( $query, $link ) or die ( "Couldn't add data to "domains" table: " . mysql_error() );
$result = mysql_query( "SELECT * FROM Employee" );
$num_rows = mysql_num_rows( $result );
print "There are currently $num_rows rows in the table<P>";
mysql_close( $link );
?>
</body>
</html>
|
