php.ini文件重置后php代码不工作


php code not working after php.ini file reset

我的服务提供商在我身上重置了我的php.ini文件。我的php代码没有更改,但现在我的函数都不工作了?

我正在运行php.ini 5.2,我需要打开或关闭什么才能使以下代码再次工作?

提前感谢您对的帮助

function characterListPost() {
global $wpdbNew;
$q = "SELECT id, ch_position, ch_name, ch_image, ch_description, ch_age, ch_like, ch_dislike FROM characters ORDER BY ch_position";
$rows = $wpdbNew->get_results($q,ARRAY_A);
// start with nonsense value to force a heading
$previous_season = 0;
$outputTwo='';
$i = 1;
foreach ($rows as $row) {
$outputTwo.= "<div class='"characterbox'" id='"div{$i}'">";
$i++;
$outputTwo.= "<div class='"ch_name'">{$row["ch_name"]}</div>";
$outputTwo.= "<div><image class='"ch_image'" id='"ch_image{$row["id"]}'" alt='"character image TBA'" src='"{$row["ch_image"]}'" /></div>";
$outputTwo.= "<div class='"ch_description'"><p>{$row["ch_description"]}</p></div>";
$outputTwo.= "<div class='"ch_age'"><b>Age:</b> {$row["ch_age"]}</div>";
$outputTwo.= "<div class='"ch_like'"><b>Like:</b> {$row["ch_like"]}</div>";
$outputTwo.= "<div class='"ch_dislike'"><b>Dislike:</b> {$row["ch_dislike"]}</div>";
$outputTwo.= "<div class='"Down10px clear'"></div>";
$outputTwo.= "</div>";
}
// echo test successful but $outputTwo will not display?
echo 'Connected successfully'; 
return $outputTwo;
}
?>

我测试了数据库代码,它可以工作,所以通过消除过程,问题必须在我的php.ini文件和上面的函数代码之间

<?php
$wpdbNew = new wpdb('myacc.myhost.com', 'myusername', 'mypassword', 'mydbname');
if (!$wpdbNew) { 
    die('Could not connect: ' . mysql_error()); 
} 

以下内容已在php.ini 中打开

allow_url_fopen = On
allow_url_include = On
register_long_arrays = On
register_globals = On

第二部分,基于下面提供的答案,使以下代码发挥作用EDIT通过删除foreach ($rows as $row) {使其工作一切就绪,一切正常!

<?php
episodeListPost();

function episodeListPost() {
    $host = 'mydomain.com';
    $user = 'myusername';
    $pass = 'mypassword';
    $data = 'dbname';
    $cn = mysql_connect($host, $user, $pass) or die(mysql_error());
    mysql_select_db($data, $cn) or die(mysql_error());
    $sql = "SELECT id, season_num, temp_eps_num, eps_num, title, inspired, descrip FROM season ORDER BY season_num, temp_eps_num";
    $result = mysql_query($sql, $cn) or die(mysql_error());
    if($result) {
        $previous_season = 0;
        $outputOne='';
        $i = 1;
        while($row = mysql_fetch_assoc($result)) {
            foreach ($rows as $row) {
        $season = $row["season_num"];
        if ($season != $previous_season){
        $outputOne.= "<div class='"seasonTitle'">Season $season</div>";
        $previous_season = $season;
        }
        $outputOne.= "<div class='"clear'">Episode: {$row["eps_num"]}</div>";
        $outputOne.= "<div class='"epsTitle'">Title: <span class='"epsTitleOutput'">{$row["title"]}</span></div><div class='"epsInsp'"> {$row["inspired"]}</div>";
        $outputOne.= "<div class='"epsDiscrip'">{$row["descrip"]}</div>";
        $outputOne.= "<div class='"Down10px'"></div>";
        }
    if($i == 1) { }
        echo $outputOne;
        mysql_free_result($result);
    } else {
        echo 'No results';
    }
    mysql_close($cn);
}
?>

下面的函数。很可能,您的查询没有返回任何结果,或者函数$wpdbNew->get_results()没有返回任何记录。

function characterListPost() {
    global $wpdbNew;
    $q = "SELECT id, ch_position, ch_name, ch_image, ch_description, ch_age, ch_like, ch_dislike FROM characters ORDER BY ch_position";
    $rows = $wpdbNew->get_results($q,ARRAY_A);
    // start with nonsense value to force a heading
    $previous_season = 0;
    $outputTwo='';
    $i = 1;
    foreach ($rows as $row) {
        $outputTwo.= "<div class='"characterbox'" id='"div{$i}'">";
        $i++;
        $outputTwo.= "<div class='"ch_name'">{$row["ch_name"]}</div>";
        $outputTwo.= "<div><image class='"ch_image'" id='"ch_image{$row["id"]}'" alt='"character image TBA'" src='"{$row["ch_image"]}'" /></div>";
        $outputTwo.= "<div class='"ch_description'"><p>{$row["ch_description"]}</p></div>";
        $outputTwo.= "<div class='"ch_age'"><b>Age:</b> {$row["ch_age"]}</div>";
        $outputTwo.= "<div class='"ch_like'"><b>Like:</b> {$row["ch_like"]}</div>";
        $outputTwo.= "<div class='"ch_dislike'"><b>Dislike:</b> {$row["ch_dislike"]}</div>";
        $outputTwo.= "<div class='"Down10px clear'"></div>";
        $outputTwo.= "</div>";
    }
    // echo test successful but $outputTwo will not display?
    echo 'Connected successfully.';
    if($i == 1) { echo '<br />' . 'No Rows Found'; } else { echo '<br />' . $i . ' Rows Found'; }
    return $outputTwo;
}

第二次试验

<?php
characterListPost();

function characterListPost() {
    $host = '127.0.0.1';
    $user = 'root';
    $pass = '';
    $data = 'test';
    $cn = mysql_connect($host, $user, $pass) or die(mysql_error());
    mysql_select_db($data, $cn) or die(mysql_error());
    $sql = "SELECT id, ch_position, ch_name, ch_image, ch_description, ch_age, ch_like, ch_dislike FROM characters ORDER BY ch_position";
    $result = mysql_query($sql, $cn) or die(mysql_error());
    if($result) {
        $previous_season = 0;
        $outputTwo='';
        $i = 1;
        while($row = mysql_fetch_assoc($result)) {
            $outputTwo.= "'n'n" . '<!--- ROW #' . $i . ' -->' . "'n";
            $outputTwo.= '<div class="characterbox" id="div' . $i . '">' . "'n";
            $i++;
            $outputTwo.= '<div class="ch_name">' . $row["ch_name"] . '</div>' . "'n";
            $outputTwo.= '<div><image class="ch_image" id="ch_image' . $row["id"] . '" alt="character image TBA" src="' . $row["ch_image"] . '" /></div>' . "'n";
            $outputTwo.= '<div class="ch_description"><p>' . $row["ch_description"] . '</p></div>' . "'n";
            $outputTwo.= '<div class="ch_age"><b>Age:</b> ' . $row["ch_age"] . '</div>' . "'n";
            $outputTwo.= '<div class="ch_like"><b>Like:</b> ' .$row["ch_like"] . '</div>' . "'n";
            $outputTwo.= '<div class="ch_dislike"><b>Dislike:</b> ' . $row["ch_dislike"] . '</div>' . "'n";
            $outputTwo.= '<div class="Down10px clear"></div>' . "'n";
            $outputTwo.= '</div>' . "'n";
        }
    if($i == 1) { echo '<br />' . 'No Rows Found'; } else { echo '<br />' . $i . ' Rows Found'; }
        echo '<textarea>' . $outputTwo . '</textarea>';
        mysql_free_result($result);
    } else {
        echo 'No results';
    }
    mysql_close($cn);
}
?>

四处攻击

用它替换函数应该可以。不要忘记在应该输出的任何地方调用"characterListPost()"。

function characterListPost() {
    $host = '127.0.0.1';
    $user = 'root';
    $pass = '';
    $data = 'test';
    $cn = mysql_connect($host, $user, $pass) or die(mysql_error());
    mysql_select_db($data, $cn) or die(mysql_error());
    $sql = "SELECT id, ch_position, ch_name, ch_image, ch_description, ch_age, ch_like, ch_dislike FROM characters ORDER BY ch_position";
    $result = mysql_query($sql, $cn) or die(mysql_error());
    $return = "";
    if($result) {
        $previous_season = 0;
        $outputTwo='';
        $i = 1;
        while($row = mysql_fetch_assoc($result)) {
            $outputTwo.= "<div class='"characterbox'" id='"div{$i}'">";
            $i++;
            $outputTwo.= "<div class='"ch_name'">{$row["ch_name"]}</div>";
            $outputTwo.= "<div><image class='"ch_image'" id='"ch_image{$row["id"]}'" alt='"character image TBA'" src='"{$row["ch_image"]}'" /></div>";
            $outputTwo.= "<div class='"ch_description'"><p>{$row["ch_description"]}</p></div>";
            $outputTwo.= "<div class='"ch_age'"><b>Age:</b> {$row["ch_age"]}</div>";
            $outputTwo.= "<div class='"ch_like'"><b>Like:</b> {$row["ch_like"]}</div>";
            $outputTwo.= "<div class='"ch_dislike'"><b>Dislike:</b> {$row["ch_dislike"]}</div>";
            $outputTwo.= "<div class='"Down10px clear'"></div>";
            $outputTwo.= "</div>";
        }
//    if($i == 1) { echo '<br />' . 'No Rows Found'; } else { echo '<br />' . $i . ' Rows Found'; }
        $return = $outputTwo;
        mysql_free_result($result);
//    } else {
//        echo 'No results';
    }
    mysql_close($cn);
    return $return;
}