php直接调用数据库,php 调用数据库

mysql

CREATE TABLE users (fname VARCHAR(30), lname VARCHAR(30), info BLOB);

INSERT INTO users VALUES ( "Jim", "Jones", "In his spare time Jim enjoys biking, eating pizza, and classical music" ), ( "Peggy", "Smith", "Peggy is a water sports enthusiast who also enjoys making soap and selling cheese" ),( "Maggie", "Martin", "Maggie loves to cook itallian food including spagetti and pizza" ),( "Tex", "Moncom", "Tex is the owner and operator of The Pizza Palace, a local hang out joint" )

搜索

Seach for: in

First Name

Last Name

Profile

//This is only displayed if they have submitted the form

if ($searching =="yes")

{

echo "

Results

";

//If they did not enter a search term we give them an error

if ($find == "")

{

echo "

You forgot to enter a search term";

exit;

}

// Otherwise we connect to our Database

mysql_connect("mysql.yourhost.com", "user_name", "password") or die(mysql_error());

mysql_select_db("database_name") or die(mysql_error());

// We preform a bit of filtering

$find = strtoupper($find);

$find = strip_tags($find);

$find = trim ($find);

//Now we search for our search term, in the field the user specified

$data = mysql_query("SELECT * FROM users WHERE upper($field) LIKE'%$find%'");

//And we display the results

while($result = mysql_fetch_array( $data ))

{

echo $result['fname'];

echo " ";

echo $result['lname'];

echo "
";

echo $result['info'];

echo "
";

echo "
";

}

//This counts the number or results - and if there wasn't any it gives them a little message explaining that

$anymatches=mysql_num_rows($data);

if ($anymatches == 0)

{

echo "Sorry, but we can not find an entry to match your query
";

}

//And we remind them what they searched for

echo "Searched For: " .$find;

}

?>