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

WBOY
Release: 2016-07-13 17:31:52
Original
917 people have browsed it

php(做为现在的主流开发语言)5+MySQL(和PHP搭配之最佳组合)5+apache(Unix平台最流行的WEB服务器平台)2已经是目前最流行的建站模式了。在对MySQL(和PHP搭配之最佳组合)的表操作的时候如果仅仅使用sql语言对MySQL(和PHP搭配之最佳组合)去操作未免太繁琐了一点。于是笔者参考互联网上的代码通过修改写了一套对各种表进行添加、删除、修改记录的php(做为现在的主流开发语言)代码。仅供大家参考娱乐。

以下贴出的代码在php(做为现在的主流开发语言)5+MySQL(和PHP搭配之最佳组合)5+apache(Unix平台最流行的WEB服务器平台)2 for WinXp上调试通过。

首先说明一下代码适用范围,按照大多数表的特点,每个表都有id,所以这些代码适用于第一列为id的表。至于名称起什么无关紧要,重要的是代码都是默认按照第一列为Prima(最完善的虚拟主机管理系统)ry key来进行操作。其他并无任何限制,本代码可以对任意列的表进行操作。缺点:未进行输入审查。所以输入记录时不要空行也不要输不匹配的类型,这个需要与MySQL(和PHP搭配之最佳组合)的建表相配合。

注意:提醒!以上代码在copy的时候一定注意在编辑器里面把每一行代码前面的tab去掉,不然php(做为现在的主流开发语言)5编译不过。
而且在每个文件中$database目前为sunsite,$table为software,这个可以根据需要修改。

首先是index.php(做为现在的主流开发语言),主要实现功能为让用户输入表名,然后点击查看按钮就可以看到表的内容。也是默认的首页。

//index.php(做为现在的主流开发语言)



admin

Please input the table name




table name:




然后是tables.php(做为现在的主流开发语言),功能为显示出表的内容。并附有添加删除和修改的入口。
//tables.php(做为现在的主流开发语言)


current table


$database = "sunsite"
$tablename = $_REQUEST[tablename];
echo "

Data from $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)
{
echo "Found these entries in the database:

"
echo ""
while ($r = MySQL(和PHP搭配之最佳组合)_fetch_array($result))
{
echo ""
$column = $column + 1;
}
echo ""
MySQL(和PHP搭配之最佳组合)_free_result($result);

$query = "select * from $tablename"
$result = MySQL(The best combination with PHP)_db_query($database, $query);
if ($ result)
while ($r = MySQL(The best combination with PHP)_fetch_array($result))
{
echo "

"
for ($col=0;$col<$column;$col++) echo ""
echo ""
}
echo "
$r[0]
$r[$col]
"
}
else echo "No data."
MySQL(The best combination with PHP)_free_result($result);
if ($column != 0)//($tablename == "software" || $tablename == "techtalk")
echo "


"
?>

To be continued.

www.bkjia.comtruehttp: //www.bkjia.com/PHPjc/508894.htmlTechArticlephp (as the current mainstream development language) 5+MySQL (the best combination with PHP) 5+ Apache (the most popular WEB server platform on the Unix platform) 2 is already the most popular website building model. On...
source:php.cn
Statement of this Website
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
Popular Tutorials
More>
Latest Downloads
More>
Web Effects
Website Source Code
Website Materials
Front End Template
About us Disclaimer Sitemap
php.cn:Public welfare online PHP training,Help PHP learners grow quickly!