1,php Connection Database
$dbhost = ' localhost ';
$dbuser = ' root '; Your MySQL user name
$dbpass = ' 123456 '; Your MySQL password
$dbname = ' data '; Your MySQL library name
Connecting to a local database
$GLOBALS ["conn"] = mysql_connect ($dbhost, $dbuser, $dbpass);
Open Database
mysql_select_db ($dbname, $GLOBALS ["Conn"]);
?>
2.php read a field value in a database
Reading a column of data
$sql = "SELECT * from Ec_admin";
$result = mysql_query ($sql, $GLOBALS ["Conn"]);
printf ("User name:%s
\ n ", Mysql_result ($result, 3," UserName "));
printf ("Password:%s
\ n ", Mysql_result ($result, 3," Userpass "));
?>
3,php inserting a piece of data
$sql = "INSERT into Ec_admin (Username,userpass) VALUES (' liugongxun2 ', ' Jakemary2 ')";
$result =mysql_query ($sql, $GLOBALS ["conn"]) or Die (Mysql_error ());
?>
4,php while loop
$sql = "SELECT * from Ec_admin";
$result = mysql_query ($sql, $GLOBALS ["Conn"]);
while ($myrow = Mysql_fetch_row ($result))
{
printf ("User name%s%s password
", $myrow [1], $myrow [2]);
}
?>
5,php do and loop
$sql = "SELECT * from Ec_admin";
$result = mysql_query ($sql, $GLOBALS ["Conn"]);
if ($myrow = mysql_fetch_array ($result))
{
Do
{
printf ("User name%s%s password
", $myrow [" UserName "], $myrow [" Userpass "]);
}while ($myrow = mysql_fetch_array ($result));
}
?>
6,php to determine whether the form is submitted
if ($submit)
{}
?>
http://www.bkjia.com/PHPjc/319209.html www.bkjia.com true http://www.bkjia.com/PHPjc/319209.html techarticle 1,php connection database? php $dbhost = ' localhost '; $dbuser = ' root ';//your MySQL user name $dbpass = ' 123456 ';//your mysql password $dbname = ' data ';// Your MySQL library name//connect to the local database ...