Question

PHP 高手请进~求一个添加 删除 查询程序 PHP 连接 MYSQL的

我的表是
name grade
张三 87
王五 89

Answer 1

//连接数据库
$link = mysql_connect($db_host, $db_username, $db_password);
//查询。tablename为表名
$sql = "SELECT * FROM tablename";
$res = mysql_query($sql,$link);
while($a = mysql_fetch_array($res))
{
echo 'Name:'.$a['name'].',Grade:'.$a['grade'].'<br>';
}
//添加
$sql = "INSERT INTO tablename (name,grade) VALUES ('李四','88')";
mysql_query($sql,$link);
//删除
$sql = "DELETE FROM tablename WHERE name='张三'";
mysql_query($sql,$link);
//修改
$sql = "UPDATE tablename SET grade=90 WHERE name='张三'";
mysql_query($sql,$link);