SELECT在JavaScript内的PHP中无法正常工作 [英] SELECT not working properly within PHP inside JavaScript
问题描述
您好：
我无法让下面的代码正常工作。它在第一个循环中工作正常，但接下来的时间是$ querySQL =''SELECT * FROM host_index''"返回错误的值。
有人可以帮帮我吗？
[php]
<？php
require_once（''connections / radiolightstream.php''）;
mysql_select_db（$ database_radiolightstream，$ radiolightstream）;
？>
<！DOCTYPE html PUBLIC" - // W3C // DTD XHTML 1.0 Transitional // EN" http：//www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
< html xmlns =" http：//www.w3.org / 1999 / xhtml">
< head>
< meta http-equiv =" Content-Type"含量=" text / html的;字符集= ISO-8859-1" />
< title> Untitled Document< / title>
< SCRIPT LANGUAGE =" JavaScript">
< SCRIPT LANGUAGE =" JavaScript">
// *****在此修改消息***** //
var Message = new Array（3）;
Message [0] =
"<？php
$ querySQL ='' SELECT * FROM host_index''; //获取下一个主机索引
$ result = mysql_query（$ querySQL，$ radiolightstream）或die（mysql_error（））;
$ result = mysql_query（$ querySQL，$ radiolightstream）或die（mysql_error（））;
$ row_result = mysql_fetch_array（$ result）;
echo $ row_result [''next_host'']。''< p为H. '';
$ host_id = $ row_result [''next_host''] + 1; //实际主机ID
？>" ;;
消息[1] =
"<？php
$ querySQL =''SELECT * FROM hosts WHERE approved = 1 AND paid = 1'';
$ result = mysql_query（$ querySQL，$ radiolightstream）或die（mysql_error（）） ;
$ num_hosts = mysql_numrows（$ result）;
mysql_data_seek（$ result，$ row_result [''next_host'']）或死（mysql_error（））;
$ row_host_result = mysql_fetch_array（$ result）;
echo $ row_host_result [show_title]。''< p>'';
？>" ;;
消息[2] =
''<？php
$ next_host = $ host_id％$ num_hosts; //更新指针
$ querySQL =" UPDATE host_index SET next_host = $ next_host" ;;
$ result = mysql_query（$ querySQL，$ radiolightstream）or die（mysql_error（ ））;
echo $ querySQL。"< p>" ;;
？>'';
var nCount = 0;
函数rotateSpan1（）
{
Span1.innerHTML =消息[nCount];
nCount ++;
if（nCount> Message.length-1）nCount = 0;
setTimeout（" rotateSpan1（）"，5000）;
}
函数showSpan1（obj）
{
Span1.innerHTML = obj
}
< / SCRIPT>
< ; / head>
< body>
< div id = Span1>< / div>
< SCRIPT LANGUAGE =" JavaScript"
rotateSpan1（）;
< / SCRIPT>
< / body>
< / html> [/ php]
Genia
Hi there:
I cannot get the code below to work properly. It works fine on the first loop but the next times around "$querySQL = ''SELECT * FROM host_index''" returns the wrong value.
Can somebody help me out?
[php]
<?php
require_once(''connections/radiolightstream.php'');
mysql_select_db($database_radiolightstream, $radiolightstream);
?>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1" />
<title>Untitled Document</title>
<SCRIPT LANGUAGE="JavaScript">
<SCRIPT LANGUAGE="JavaScript">
// ***** Modify the messages here ***** //
var Message = new Array(3);
Message[0]=
"<?php
$querySQL = ''SELECT * FROM host_index''; // get next host index
$result = mysql_query($querySQL, $radiolightstream) or die(mysql_error());
$result = mysql_query($querySQL, $radiolightstream) or die(mysql_error());
$row_result = mysql_fetch_array ($result);
echo $row_result[''next_host''].''<p>'';
$host_id = $row_result[''next_host''] + 1; // actual host id
?>";
Message[1]=
"<?php
$querySQL = ''SELECT * FROM hosts WHERE approved=1 AND paid=1'';
$result = mysql_query($querySQL, $radiolightstream) or die(mysql_error());
$num_hosts = mysql_numrows($result);
mysql_data_seek($result, $row_result[''next_host'']) or die(mysql_error());
$row_host_result = mysql_fetch_array ($result);
echo $row_host_result[show_title].''<p>'';
?>";
Message[2]=
''<?php
$next_host = $host_id % $num_hosts; // update pointer
$querySQL = "UPDATE host_index SET next_host=$next_host";
$result = mysql_query($querySQL, $radiolightstream) or die(mysql_error());
echo $querySQL."<p>";
?>'';
var nCount = 0;
function rotateSpan1()
{
Span1.innerHTML=Message[nCount];
nCount++;
if(nCount>Message.length-1) nCount=0;
setTimeout("rotateSpan1()",5000);
}
function showSpan1(obj)
{
Span1.innerHTML=obj
}
</SCRIPT>
</head>
<body>
<div id=Span1></div>
<SCRIPT LANGUAGE="JavaScript">
rotateSpan1();
</SCRIPT>
</body>
</html>[/php]
Genia
推荐答案
querySQL =''SELECT * FROM host_index''"返回错误的值。
有人可以帮帮我吗？
[php]
<？php
require_once（''connections / radiolightstream.php''）;
mysql_select_db（
querySQL = ''SELECT * FROM host_index''" returns the wrong value.
Can somebody help me out?
[php]
<?php
require_once(''connections/radiolightstream.php'');
mysql_select_db(
database_radiolightstream，
database_radiolightstream,
radiolightstream）;
？>
<！DOCTYPE html PUBLIC" - // W3C // DTD XHTML 1.0 Transitional / / EN" http：//www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
< html xmlns =" http：//www.w3.org / 1999 / xhtml">
< head>
< meta http-equiv =" Content-Type"含量=" text / html的;字符集= ISO-8859-1" />
< title> Untitled Document< / title>
< SCRIPT LANGUAGE =" JavaScript">
< SCRIPT LANGUAGE =" JavaScript">
// *****在此修改消息***** //
var Message = new Array（3）;
Message [0] =
"<？php
radiolightstream);
?>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1" />
<title>Untitled Document</title>
<SCRIPT LANGUAGE="JavaScript">
<SCRIPT LANGUAGE="JavaScript">
// ***** Modify the messages here ***** //
var Message = new Array(3);
Message[0]=
"<?php
这篇关于SELECT在JavaScript内的PHP中无法正常工作的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！
