且构网

分享程序员开发的那些事...
且构网 - 分享程序员编程开发的那些事

麻烦将mysql表名传递给php函数并使用它!

更新时间:2023-02-26 09:50:08

result = mysql_query(" select * from


tableInfo");

for(


i = 0;

Trouble passing mysql table name in php. If I use an existing table
name already defined everything works fine as the following script
illustrates.

<?php
function fms_get_info()
{
$result = mysql_query("select * from $tableInfo") ;
for ($i = 0; $i < mysql_num_rows($result); $i++)
{
/* do something */
}

}
/* Main */
fms_get_info();

But it won''t work if I pass a variable table name to the function.
<?php
function fms_get_info($tableName)
{
$result = mysql_query("select * from $tableName") ;
for ($i = 0; $i < mysql_num_rows($result); $i++)
{
/* do something */
}

}
/* Main */
fms_get_info($tableInfo);

I need to use the same function to gather information from multiple
tables at will without creating a different function for each
possible
mysql database table by name. I thought this would be easy, but I
have failed at several tries.

result = mysql_query("select * from


tableInfo") ;
for (


i = 0;