mysql_query 变量,在mysql_query字符串中使用PHP变量

好了朋友们.将PHP变量传递到mysql_query字符串中时,我遇到了一个有点复杂的问题.

$_GET [‘date’];通过时将包含类似以下内容的内容：2015_01_07_1

我需要使用$week变量将GET数据传递到表名称中.

$week= $_GET['date'];

$con=mysqli_connect("localhost","root","mypassword","beerhandpoker");

// Check connection

if (mysqli_connect_errno()) {

echo "Failed to connect to MySQL: " . mysqli_connect_error();

}

$result = mysqli_query

($con,

"SELECT games_brixx_gastonia_'$week'.rank, players_brixx_gastonia.name, games_brixx_gastonia_'$week'.points

FROM games_brixx_gastonia_'$week', players_brixx_gastonia

WHERE games_brixx_gastonia_'$week'.email = players.email

ORDER BY games_brixx_gastonia_'$week'.rank

LIMIT 20"

);

echo "

Rank	Name	Points

while($row = mysqli_fetch_array($result)) {

echo "

";

echo "

" . $row['rank'] . "";

echo "

" . $row['name'] . "";

echo "

" . $row['points'] . "";

echo "

";

}

echo "

";

mysqli_close($con);

?>

解决方法:

将字符串文字更改为：

"SELECT games_brixx_gastonia_$week.rank,

players_brixx_gastonia.name,games_brixx_gastonia_$week.points

FROM games_brixx_gastonia_$week, players_brixx_gastonia

WHERE games_brixx_gastonia_$week.email = players_brixx_gastonia.email

ORDER BY games_brixx_gastonia_$week.rank

LIMIT 20"

您必须删除’字符；

它将作为games_brixx_gastonia_’2015_01_07_1′.rank进入数据库

标签：variables,mysql,php

来源： https://codeday.me/bug/20191029/1956999.html