Revision: 31872
Initial Code
Initial URL
Initial Description
Initial Title
Initial Tags
Initial Language
at September 15, 2010 01:04 by paschim
Initial Code
<?php
//mysql connect
//connect to db and insert
mysql_connect(localhost,$username,$password);
mysql_select_db($database) or die( "Unable to select database");
$query = "INSERT INTO contacts VALUES ('','John','Smith','01234 567890','00112 334455','01234 567891','[email protected]','http://www.gowansnet.com')";
mysql_query($query);
echo "Record added";
mysql_close();
//mysql select query
$result = mysql_query("SELECT id,name FROM table");
if(!$result) {
echo mysql_error();
}
while($row = mysql_fetch_assoc($result)) {
echo "Row data: " . $row['id'] . " - " . $row['name'];
}
//alternative select query
mysql_connect(localhost,$username,$password);
mysql_select_db($database) or die( "Unable to select database");
$query="SELECT * FROM contacts";
$result=mysql_query($query);
echo "Data displayed";
mysql_close();
//mysql update
mysql_connect(localhost,$username,$password);
mysql_select_db($database) or die( "Unable to select database");
$query = "UPDATE contacts SET
first = '$ud_first',
last = '$ud_last',
phone = '$ud_phone',
mobile = '$ud_mobile',
fax = '$ud_fax',
email = '$ud_email',
web = '$ud_web'
WHERE id = '$ud_id'";
mysql_query($query);
echo "Record Updated";
mysql_close();
//delete contact
mysql_connect(localhost,$username,$password);
mysql_select_db($database) or die( "Unable to select database");
$query = "DELETE FROM contacts WHERE id='$id'";
mysql_query($query);
echo "Record Deleted";
mysql_close();
?>
Initial URL
Initial Description
Initial Title
full php mysql connection script
Initial Tags
mysql, php
Initial Language
PHP