-
Quem Está Navegando 0 membros estão online
- Nenhum usuário registrado visualizando esta página.
-
Conteúdo Similar
-
- 1 resposta
- 1102 visualizações
-
- 0 respostas
- 2066 visualizações
-
- 0 respostas
- 1130 visualizações
-
- 0 respostas
- 819 visualizações
-
- 1 resposta
- 1392 visualizações
-
Pergunta
lunhao 0
Olá, atualmente, estou tentando colocar um site on através do xampp, os arquivos já vieram prontos e não manjo nada de script/php e quando tento entrar no localhost, aparece o seguinte erro: Parse error: syntax error, unexpected $end in C:\xampp\htdocs\inc\db.class.php on line 397
vou postar o script inteiro, gostaria muito de ajuda, muito obrigado!!
<?php
// constants used by class
define('MYSQL_TYPES_NUMERIC', 'int real ');
define('MYSQL_TYPES_DATE', 'datetime timestamp year date time ');
define('MYSQL_TYPES_STRING', 'string blob ');
require 'configs.php'; if (!defined('_VALID_'))header("Location: index");
class db_class {
var $last_error; // holds the last error. Usually mysql_error()
var $last_query; // holds the last query executed.
var $row_count; // holds the last number of rows from a select
private $server = ''; //database server
private $pw = ''; //database login password
private $database = ''; //database name
private $pre = ''; //table prefix
private $err_email = ADMIN_EMAIL;
/*
// private váriaveis
private $USER_TABLE = '';
private $NEWS_TABLE ='';
private $ADMIN_TABLE='';
private $CONFIG_TABLE='';
*/
private $errlog = true; // true or false
private $error = '';
private $errno = 0;
var $link_id; // current/last database link identifier
var $auto_slashes; // the class will add/strip slashes when it can
public function db_class() {
$this->server=DB_HOST;
$this->user=DB_USER;
$this->pw=DB_PASS;
$this->database=DB_NAME;
$this->pre=DB_TABLE;
/*
// private váriaveis
$this->USER_TABLE=TABLE_USER;
$this->NEWS_TABLE=TABLE_NEWS;
$this->ADMIN_TABLE=TABLE_ADMIN;
$this->CONFIG_TABLE=CONFIG_TABLE;
*/
$this->auto_slashes = true;
}
public function connect($new_link=false, $persistant=false) {
if ($persistant)
$this->link_id =@mysql_connect($this->server,$this->user,$this->pw,$new_link);
else
$this->link_id =@mysql_connect($this->server,$this->user,$this->pw,$new_link);
if (!$this->link_id) {
$this->last_error = mysql_error();
$this->print_last_error("Connection close failed.");
return false;
}
if(!@mysql_select_db($this->database, $this->link_id)) {//no database
$this->last_error = mysql_error();
}
if (!$this->select_db($this->database, $this->link_id)) return false;
return $this->link_id; // success
}
public function close() {
if(!mysql_close($this->link_id)){
$this->last_error = "Connection close failed.";
}
}
private function escape($string) {
if(get_magic_quotes_gpc()) $string = stripslashes($string);
return mysql_real_escape_string($string);
}
function select_db($db='') {
if (!empty($db)) $this->db = $db;
if (!mysql_select_db($this->db)) {
$this->last_error = mysql_error();
return false;
}
return true;
}
function select($sql) {
$this->last_query = $sql;
$r = mysql_query($sql);
if (!$r) {
$this->last_error = mysql_error();
return false;
}
$this->row_count = mysql_num_rows($r);
return $r;
}
function select_array($sql) {
$this->last_query = $sql;
$r = mysql_query($sql);
if (!$r) {
$this->last_error = mysql_error();
return false;
}
$this->row_count = mysql_fetch_array($r);
return $r;
}
public function query($query) {
$r = mysql_query($sql);
if (!$r) {
$r->result = mysql_query($query);
} else {
$r->result = null;
}
}
function select_one($sql) {
$this->last_query = $sql;
$r = mysql_query($sql);
if (!$r) {
$this->last_error = mysql_error();
return false;
}
if (mysql_num_rows($r) > 1) {
$this->last_error = "Your query in function select_one() returned more that one result.";
return false;
}
if (mysql_num_rows($r) < 1) {
$this->last_error = "Your query in function select_one() returned no results.";
return false;
}
$ret = mysql_result($r, 0);
mysql_free_result($r);
if ($this->auto_slashes) return stripslashes($ret);
else return $ret;
}
function get_row($result, $type='MYSQL_BOTH') {
if (!$result) {
$this->last_error = "Invalid resource identifier passed to get_row() function.";
return false;
}
if ($type == 'MYSQL_ASSOC') $row = mysql_fetch_array($result, MYSQL_ASSOC);
if ($type == 'MYSQL_NUM') $row = mysql_fetch_array($result, MYSQL_NUM);
if ($type == 'MYSQL_BOTH') $row = mysql_fetch_array($result, MYSQL_BOTH);
if (!$row) return false;
if ($this->auto_slashes) {
foreach ($row as $key => $value) {
$row[$key] = stripslashes($value);
}
}
return $row;
}
function dump_query($data,$data2,$data3) {
$r = $this->select("SELECT * FROM $data WHERE $data2=$data3");
if (!$r) return false;
echo "<table cellpadding=\"3\" cellspacing=\"1\" border=\"0\" width=\"100%\">\n";
$i = 0;
while ($row = mysql_fetch_assoc($r)) {
if ($i == 0) {
foreach ($row as $col => $value) {
echo "<td bgcolor=\"#E6E5FF\"><span style=\"font-face: sans-serif; font-size: 9pt; font-weight: bold;\">$col</span></td>\n";
}
echo "</tr>\n";
}
$i++;
if ($i % 2 == 0) $bg = '#E3E3E3';
else $bg = '#F3F3F3';
echo "<tr>\n";
foreach ($row as $value) {
echo "<td bgcolor=\"$bg\"><span style=\"font-face: sans-serif; font-size: 9pt;\">$value</span></td>\n";
}
echo "</tr>\n";
}
echo "</table></div>\n";
}
function insert_sql($sql) {
$this->last_query = $sql;
$r = mysql_query($sql);
if (!$r) {
$this->last_error = mysql_error();
return false;
}
$id = mysql_insert_id();
if ($id == 0) return true;
else return $id;
}
function update_sql($sql) {
$this->last_query = $sql;
$r = mysql_query($sql);
if (!$r) {
$this->last_error = mysql_error();
return false;
}
$rows = mysql_affected_rows();
if ($rows == 0) return true;
else return $rows;
}
function insert_array($table, $data) {
if (empty($data)) {
$this->last_error = "You must pass an array to the insert_array() function.";
return false;
}
$cols = '(';
$values = '(';
foreach ($data as $key=>$value) {
$cols .= "$key,";
$col_type = $this->get_column_type($table, $key);
if (!$col_type) return false;
if (is_null($value)) {
$values .= "NULL,";
}
elseif (substr_count(MYSQL_TYPES_NUMERIC, "$col_type ")) {
$values .= "$value,";
}
elseif (substr_count(MYSQL_TYPES_DATE, "$col_type ")) {
$value = $this->sql_date_format($value, $col_type);
$values .= "'$value',";
}
elseif (substr_count(MYSQL_TYPES_STRING, "$col_type ")) {
if ($this->auto_slashes) $value = addslashes($value);
$values .= "'$value',";
}
}
$cols = rtrim($cols, ',').')';
$values = rtrim($values, ',').')';
$sql = "INSERT INTO $table $cols VALUES $values";
return $this->insert_sql($sql);
}
function update_array($table, $data, $condition) {
if (empty($data)) {
$this->last_error = "You must pass an array to the update_array() function.";
return false;
}
$sql = "UPDATE $table SET";
foreach ($data as $key=>$value) {
$sql .= " $key=";
$col_type = $this->get_column_type($table, $key);
if (!$col_type) return false;
if (is_null($value)) {
$sql .= "NULL,";
}
elseif (substr_count(MYSQL_TYPES_NUMERIC, "$col_type ")) {
$sql .= "$value,";
}
elseif (substr_count(MYSQL_TYPES_DATE, "$col_type ")) {
$value = $this->sql_date_format($value, $col_type);
$sql .= "'$value',";
}
elseif (substr_count(MYSQL_TYPES_STRING, "$col_type ")) {
if ($this->auto_slashes) $value = addslashes($value);
$sql .= "'$value',";
}
}
$sql = rtrim($sql, ',');
if (!empty($condition)) $sql .= " WHERE $condition";
return $this->update_sql($sql);
}
function execute_file ($file) {
if (!file_exists($file)) {
$this->last_error = "The file $file does not exist.";
return false;
}
$str = file_get_contents($file);
if (!$str) {
$this->last_error = "Unable to read the contents of $file.";
return false;
}
$this->last_query = $str;
$sql = explode(';', $str);
foreach ($sql as $query) {
if (!empty($query)) {
$r = mysql_query($query);
if (!$r) {
$this->last_error = mysql_error();
return false;
}
}
}
return true;
}
function get_column_type($table, $column) {
$r = mysql_query("SELECT $column FROM $table");
if (!$r) {
$this->last_error = mysql_error();
return false;
}
$ret = mysql_field_type($r, 0);
if (!$ret) {
$this->last_error = "Unable to get column information on $table.$column.";
mysql_free_result($r);
return false;
}
mysql_free_result($r);
return $ret;
}
function sql_date_format($value) {
if (gettype($value) == 'string') $value = strtotime($value);
return date('Y-m-d H:i:s', $value);
}
function print_last_error($show_query=true) {
?>
<div style="border: 1px solid red; font-size: 9pt; font-family: monospace; color: red; padding: .5em; margin: 8px; background-color: #FFE2E2">
<span style="font-weight: bold">db.class.php Error:</span><br><?= $this->last_error ?>
</div>
<?
if ($show_query && (!empty($this->last_query))) {
$this->print_last_query();
}
}
public function get_link_id() {
return $this->link_id;
}
function print_last_query() {
?>
<div style="border: 1px solid blue; font-size: 9pt; font-family: monospace; color: blue; padding: .5em; margin: 8px; background-color: #E6E5FF">
<span style="font-weight: bold">Last SQL Query:</span><br><?= str_replace("\n", '<br>', $this->last_query) ?>
</div>
<?
}
function filter($data) {
$this->connect();
$data = trim(htmlentities(strip_tags($data)));
if (get_magic_quotes_gpc())
$data = stripslashes($data);
$data = mysql_real_escape_string($data);
return $data;
}
function page () {
ob_start();
session_start('WebATS');
include ("inc/htmltags.php");
include ("inc/class.content.php");
$Content = new Content();
$Content->ShowContent(PAGE);
echo '<title>'.$title.' - '.utf8_decode(PAGENAME).'</title>';
include ("inc/footer.php");
}
function account ($data) {
if($data == 'createaccount'){
define('_PAGETYPEREGISTER_','active');
} elseif ($data == 'login'){
define('_PAGETYPELOGIN_','active');
}elseif($data == ''){
define('_PAGETYPEREGISTER_','active');
}elseif($data == 'forgot_password'){
define('_PAGETYPEFORGOT_','active');
}elseif($data == 'active'){
define('_PAGETYPEACTIVE_','active');
}
}
}
?>
obs: a linha 397 é a ultima linha, que contem ?>
up
Link para o comentário
Compartilhar em outros sites
1 resposta a esta questão
Posts Recomendados