duanboshi1472 2014-11-03 11:15
浏览 121
已采纳

解析错误:语法错误,意外T_ELSE,期望第54行/home/petit/public_html/system/database/mysqli.php中的T_FUNCTION

I have made an opencart transfer from a server to another and i am getting the following error Parse error: syntax error, unexpected T_ELSE, expecting T_FUNCTION in /home/petit/public_html/system/database/mysqli.php on line 54

when i try to access my site or my administrator page. Any idea why this is happening? I have followed the procedure step by step.

This is mysqli.php

 <?php
final class MySQLi {
    private $mysqli;

    public function __construct($hostname, $username, $password, $database) {
        $this->mysqli = new mysqli($hostname, $username, $password, $database);

        if ($this->mysqli->connect_error) {
            trigger_error('Error: Could not make a database link (' . $this->mysqli->connect_errno . ') ' . $this->mysqli->connect_error);
        }

        $this->mysqli->query("SET NAMES 'utf8'");
        $this->mysqli->query("SET CHARACTER SET utf8");
        $this->mysqli->query("SET CHARACTER_SET_CONNECTION=utf8");
        $this->mysqli->query("SET SQL_MODE = ''");
    }

    public function query($sql) {
        $result = $this->mysqli->query($sql);



        if ($this->mysqli->errno) {
        //$mysqli->errno
        }

            if (is_resource($resource)) {
                $i = 0;

                $data = array();

                while ($row = $result->fetch_object()) {
                    $data[$i] = $row;

                    $i++;
                }

                $result->close();

                $query = new stdClass();
                $query->row = isset($data[0]) ? $data[0] : array();
                $query->rows = $data;
                $query->num_rows = $result->num_rows;

                unset($data);




                return $query;  
            } else {
                return true;
            }
        } else {
            trigger_error('Error: ' . mysql_error($this->link) . '<br />Error No: ' . mysql_errno($this->link) . '<br />' . $sql);
            exit();
        }
    }

    public function escape($value) {
        return $this->mysqli->real_escape_string($value);
    }

    public function countAffected() {
        return $this->mysqli->affected_rows;
    }

    public function getLastId() {
        return $this->mysqli->insert_id;
    }   

    public function __destruct() {
        $this->mysqli->close();
    }
}
?>

Thank you in advance

  • 写回答

1条回答 默认 最新

  • drf65218 2014-11-03 11:18
    关注

    there is else without if. the if block is closed. do it like -

    if ($this->mysqli->errno) {
    //$mysqli->errno
    
        if (is_resource($resource)) {
            $i = 0;
    
            $data = array();
    
            while ($row = $result->fetch_object()) {
                $data[$i] = $row;
    
                $i++;
            }
    
            $result->close();
    
            $query = new stdClass();
            $query->row = isset($data[0]) ? $data[0] : array();
            $query->rows = $data;
            $query->num_rows = $result->num_rows;
    
            unset($data);
    
    
    
    
            return $query;  
        } else {
            return true;
        }
    } else {
        trigger_error('Error: ' . mysql_error($this->link) . '<br />Error No: ' . mysql_errno($this->link) . '<br />' . $sql);
        exit();
    }
    
    本回答被题主选为最佳回答 , 对您是否有帮助呢?
    评论

报告相同问题?

悬赏问题

  • ¥15 前后端分离的学习疑问?
  • ¥15 stata实证代码答疑
  • ¥15 MATLAB数据处理插值
  • ¥50 husky+jaco2实现在gazebo与rviz中联合仿真
  • ¥15 dpabi预处理报错:Error using y_ExtractROISignal (line 251)
  • ¥15 在虚拟机中配置flume,无法将slave1节点的文件采集到master节点中
  • ¥15 husky+kinova jaco2 仿真
  • ¥15 zigbee终端设备入网失败
  • ¥15 金融监管系统怎么对7+4机构进行监管的
  • ¥15 硬件IIC从模式的数据发送,中断数据的接收,不能用HAL库(按照时序图)