Home  >  Article  >  Backend Development  >  PHP5 management code example for any Mysql5 database table (2)_PHP tutorial

PHP5 management code example for any Mysql5 database table (2)_PHP tutorial

WBOY
WBOYOriginal
2016-07-13 17:31:50942browse

续:点击添加一个条目就会跳转到add.php(做为现在的主流开发语言)
    //add.php(做为现在的主流开发语言)
   
Add an entry to the database



Add an entry


(做为现在的主流开发语言)
$database = "sunsite";
$tablename = $_GET[tablename];
MySQL(和PHP搭配之最佳组合)_connect("localhost","root","") or die ("Problem connecting to DataBase");
$query = "show columns from $tablename";
$result = MySQL(和PHP搭配之最佳组合)_db_query($database,$query);
$column = 0;
if ($result)
{
while ($r = MySQL(和PHP搭配之最佳组合)_fetch_array($result))
{
$colname[$column] = $r[0];
$column = $column + 1;
}
MySQL(和PHP搭配之最佳组合)_free_result($result);
}
$id = 0;
do
{
$id++;
$query = "select * from $tablename where $colname[0]=$id";
$result = MySQL(和PHP搭配之最佳组合)_db_query($database,$query);
}
while(MySQL(和PHP搭配之最佳组合)_fetch_array($result))
?>



for ($col=1;$col<$column;$col++)
echo "";
?>
" value="(做为现在的主流开发语言) echo "$id"; ?>">
">

(做为现在的主流开发语言) echo "$colname[0]";?>:(做为现在的主流开发语言) echo "$id"; ?>
$colname[$col]:


">Finish

其中id是自动寻找并生成的,而且保证在数据库中id是唯一的。点击add之后会将内容写入数据库,然后会继续让你添加内容,直至添加完毕点击finish回到上一层,显示出添加条目後的数据库内容。
下面是添加过程中对数据库进行操作的addsoftware.php(做为现在的主流开发语言)
    //addsoftware.php(做为现在的主流开发语言)
    (做为现在的主流开发语言)
$database = "sunsite";
$tablename = $_POST[tablename];
MySQL(和PHP搭配之最佳组合)_connect("localhost","root","") or die ("Problem connecting to DataBase");
$query = "show columns from $tablename";
$result = MySQL(和PHP搭配之最佳组合)_db_query($database,$query);
$column = 0;
if ($result)
{
while ($r = MySQL(和PHP搭配之最佳组合)_fetch_array($result))
{
$colname[$column] = $r[0];
$column = $column + 1;
}
MySQL(和PHP搭配之最佳组合)_free_result($result);
}

for($col=0;$col<$column;$col++)
$para[$col] = $_POST[$colname[$col]];

if ($_POST[name])
{
MySQL(The best combination with PHP)_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(and PHP The best combination)_db_query($database, $query);
Header("Location: add.php(as the current mainstream development language)?tablename=$tablename" );
}
else
{
echo "No name Entered. Please go back and reenter name";
}
?>

To be continued.

www.bkjia.comtruehttp: //www.bkjia.com/PHPjc/508895.htmlTechArticleContinued: Click to add an entry and it will jump to add.php (as the current mainstream development language) / /add.php (as the current mainstream development language) html headtitleAdd an entry to the database/ti...
Statement:
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn