技术标签 TAGS
专业技术精选
- 2020-03-20非常不错的骰子案例
- 2019-05-26vscode git and gitlens中文乱码问题
- 2011-12-14什么是网站制作的web标准
- 2011-12-14上海网站建设之六大不利优化因素
PHP 给相应数据表匹配 查询添加修改删除
<?php
$con = mysql_connect("127.0.0.1","root","123456");
if (!$con)
{
die('Could not connect: ' . mysql_error());
}
mysql_select_db("test", $con);
//$filename ="product_cn";
//$table_product = preg_match（"/^product_/",$filename)
$query=mysql_query("show tables");
$i = 1;
while($row=mysql_fetch_array($query))
{
echo $row[0]."<br>";
$table_productArr[$i] = $row[0];
$i++;
}
foreach($table_productArr as $Pkey=>$Pvalue){
if(strrpos($Pvalue,"product_") ==0 && strrpos($Pvalue,"product_")!==false){
mysql_query("INSERT INTO ".$Pvalue." (name) VALUES ('Peter')");
echo "添加成功".$Pvalue.strrpos($Pvalue,"product_")."<br/>";
}
}
/* foreach($table_productArr as $Pkey=>$Pvalue){
mysql_query("delete form ".$Pvalue." where name='Peter'");
echo "删除成功".$i.$Pvalue."<br/>";
}*/
mysql_close($con);
?>
share
$con = mysql_connect("127.0.0.1","root","123456");
if (!$con)
{
die('Could not connect: ' . mysql_error());
}
mysql_select_db("test", $con);
//$filename ="product_cn";
//$table_product = preg_match（"/^product_/",$filename)
$query=mysql_query("show tables");
$i = 1;
while($row=mysql_fetch_array($query))
{
echo $row[0]."<br>";
$table_productArr[$i] = $row[0];
$i++;
}
foreach($table_productArr as $Pkey=>$Pvalue){
if(strrpos($Pvalue,"product_") ==0 && strrpos($Pvalue,"product_")!==false){
mysql_query("INSERT INTO ".$Pvalue." (name) VALUES ('Peter')");
echo "添加成功".$Pvalue.strrpos($Pvalue,"product_")."<br/>";
}
}
/* foreach($table_productArr as $Pkey=>$Pvalue){
mysql_query("delete form ".$Pvalue." where name='Peter'");
echo "删除成功".$i.$Pvalue."<br/>";
}*/
mysql_close($con);
?>