您的位置: 旅游网 > 时尚

PHP5对Mysql5的任意数据库表的管理代码示例(二)_a

发布时间:2020-01-16 23:56:25

续:点击添加一个条目就会跳转到add.php  //add.php

Add an entry

$database = "sunsite";

$tablename = $_GET["tablename"];

mysql_connect("localhost","root","") or die ("Problem connecting to DataBase");

$query = "show columns from $tablename";

$result = mysql_db_query($database,$query);

$column = 0;

if ($result)

{

while ($r = mysql_fetch_array($result))

{

$colname[$column] = $r[0];

$column = $column + 1;

}

mysql_free_result($result);

}

$id = 0;

do

{

$id++;

$query = "select * from $tablename where $colname[0]="$id"";

$result = mysql_db_query($database,$query);

}

while(mysql_fetch_array($result))

?>

:

for ($col=1;$col<$column;$col++)

echo "$colname[$col]:

";

?>

" value="">

">

">Finish

其中id是自动寻找并生成的,而且保证在数据库中id是唯一的。点击add之后会将内容写入数据库,然后会继续让你添加内容,直至添加完毕点击finish回到上一层,显示出添加条目後的数据库内容。

下面是添加过程中对数据库进行操作的addsoftware.php

//addsoftware.php

$database = "sunsite";

$tablename = $_POST["tablename"];

mysql_connect("localhost","root","") or die ("Problem connecting to DataBase");

$query = "show columns from $tablename";

$result = mysql_db_query($database,$query);

$column = 0;

if ($result)

{

while ($r = mysql_fetch_array($result))

{

$colname[$column] = $r[0];

$column = $column + 1;

}

mysql_free_result($result);

}

for($col=0;$col<$column;$col++)

$para[$col] = $_POST[$colname[$col]];

if ($_POST["name"])

{

mysql_connect("localhost","root","") or die ("Problem connecting to DataBase");

$query = "insert into $tablename values ("$para[0]" ";

for($col=1;$col<$column;$col++)

$query = $query . ","" . $para[$col] . """;

$query = $query . ");";

$result = mysql_db_query($database, $query);

Header("Location: add.php?tablename=$tablename");

}

else

{

echo "No name Entered. Please go back and reenter name";

}

?>

待续。

小儿流行性感冒服什么药好
最简单的瘦身操
动脉硬化吃通心络会好吗
滑囊炎能吃藤黄健骨丸吗
猜你会喜欢的
猜你会喜欢的