不知这是不是你需要的,楼主是研究哪一块的?
mysql_connect("localhost", "mysql_user", "mysql_password") or
die("Could not connect: " . mysql_error());
mysql_select_db("mydb"); $result = mysql_query("SELECT id, name FROM yourtable"); while ($row = mysql_fetch_array($result, MYSQL_BOTH)) {
printf ("ID: %s Name: %s", $row[0], $row["name"]);
} mysql_free_result($result);
mysql_connect("localhost", "mysql_user", "mysql_password") or
die("Could not connect: " . mysql_error());
mysql_select_db("mydb"); $result = mysql_query("SELECT id, name FROM yourtable"); while ($row = mysql_fetch_array($result, MYSQL_BOTH)) {
printf ("ID: %s Name: %s", $row[0], $row["name"]);
} mysql_free_result($result);
你这查出来的是所有的啊我的意思是在文本框中输入进行查询再帮帮忙吧。
要搜索的内容:<input name="searchcon1" type="text" id="searchcon1">
</form>
<?php
mysql_connect("localhost", "mysql_user", "mysql_password") or
die("Could not connect: " . mysql_error());
mysql_select_db("mydb");
$s1=$_POST["searchcon1"];
$result = mysql_query("SELECT `name` FROM yourtable WHERE `name` LIKE '%$s1%'");while ($row = mysql_fetch_array($result, MYSQL_BOTH)) {
print_r ("Name: %s",$row["name"]);
}mysql_free_result($result);
mysql_close();
?>