index.php

[MedMax]

Finalmente ho attivato il dbase mysql.
Adesso però mi dà un serie di errori quando accedo al mio sito:

Warning: mysql_fetch_row(): supplied argument is not a valid MySQL result resource in /membri/medmax/includes/sql_layer.php on line 301

Warning: Failed opening 'language/lang-.php' for inclusion (include_path='.:/usr/local/lib/php') in /membri/medmax/mainfile.php on line 75

Warning: mysql_fetch_row(): supplied argument is not a valid MySQL result resource in /membri/medmax/includes/sql_layer.php on line 301

Warning: mysql_fetch_row(): supplied argument is not a valid MySQL result resource in /membri/medmax/includes/sql_layer.php on line 301

Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /membri/medmax/includes/sql_layer.php on line 357

Warning: Failed opening 'themes//theme.php' for inclusion (include_path='.:/usr/local/lib/php') in /membri/medmax/header.php on line 31

Fatal error: Call to undefined function: themeheader() in /membri/medmax/header.php on line 47

Chi mi aiuta?

Se puoi postare il codice gli do un'occhiata, xché solo con l'errore è un po' dura!
il primo avvertimento è come se hai fatto una query che non ha risultati

[MedMax]

eccolo:


<?php


if (eregi("sql_layer.php",$PHP_SELF)) {
Header("Location: ../index.php");
die();
}

/* $dbtype = "MySQL"; */
/* $dbtype = "mSQL"; */
/* $dbtype = "PostgreSQL"; */
/* $dbtype = "PostgreSQL_local";
/* $dbtype = "ODBC"; */
/* $dbtype = "ODBC_Adabas"; */
/* $dbtype = "Interbase"; */
/* $dbtype = "Sybase"; */

/*
* sql_connect($host, $user, $password, $db)
* returns the connection ID
*/


class ResultSet {
var $result;
var $total_rows;
var $fetched_rows;

function set_result( $res ) {
$this->result = $res;
}

function get_result() {
return $this->result;
}

function set_total_rows( $rows ) {
$this->total_rows = $rows;
}

function get_total_rows() {
return $this->total_rows;
}

function set_fetched_rows( $rows ) {
$this->fetched_rows = $rows;
}

function get_fetched_rows() {
return $this->fetched_rows;
}

function increment_fetched_rows() {
$this->fetched_rows = $this->fetched_rows + 1;
}
}



function sql_connect($host, $user, $password, $db)
{
global $dbtype;
switch ($dbtype) {

case "MySQL":
$dbi=@mysql_connect($host, $user, $password);
if (!mysql_select_db($db)) {
mysql_query("CREATE DATABASE $db");
mysql_select_db($db);
include("includes/install.php");
die();
}
return $dbi;
break;;

case "mSQL":
$dbi=msql_connect($host);
if (!msql_select_db($db)) {
msql_query("CREATE DATABASE $db");
msql_select_db($db);
include("includes/install.php");
die();
}
return $dbi;
break;;


case "PostgreSQL":
$dbi=@pg_connect("host=$host user=$user password=$password port=5432 dbname=$db");
return $dbi;
break;;

case "PostgreSQL_local":
$dbi=@pg_connect("user=$user password=$password dbname=$db");
return $dbi;
break;;

case "ODBC":
$dbi=@odbc_connect($db,$user,$password);
return $dbi;
break;;

case "ODBC_Adabas":
$dbi=@odbc_connect($host.":".$db,$user,$password);
return $dbi;
break;;

case "Interbase":
$dbi=@ibase_connect($host.":".$db,$user,$password) ;
return $dbi;
break;;

case "Sybase":
$dbi=@sybase_connect($host, $user, $password);
if (!sybase_select_db($db,$dbi)) {
sybase_query("CREATE DATABASE $db",$dbi);
sybase_select_db($db,$dbi);
include("includes/install.php");
die();
}
return $dbi;
break;;

default:
break;;
}

}

function sql_logout($id)
{
global $dbtype;
switch ($dbtype) {

case "MySQL":
$dbi=@mysql_close($id);
return $dbi;
break;;

case "mSQL":
$dbi=@msql_close($id);
return $dbi;
break;;

case "PostgreSQL":
case "PostgreSQL_local":
$dbi=@pg_close($id);
return $dbi;
break;;

case "ODBC":
case "ODBC_Adabas":
$dbi=@odbc_close($id);
return $dbi;
break;;

case "Interbase":
$dbi=@ibase_close($id);
return $dbi;
break;;

case "Sybase":
$dbi=@sybase_close($id);
return $dbi;
break;;

default:
break;;
}
}


/*
* sql_query($query, $id)
* executes an SQL statement, returns a result identifier
*/

function sql_query($query, $id)
{

global $dbtype;
global $sql_debug;
$sql_debug = 0;
if($sql_debug) echo "SQL query: ".str_replace(",",", ",$query)."<BR>";
switch ($dbtype) {

case "MySQL":
$res=@mysql_query($query, $id);
return $res;
break;;

case "mSQL":
$res=@msql_query($query, $id);
return $res;
break;;

case "PostgreSQL":
case "PostgreSQL_local":
$res=pg_exec($id,$query);
$result_set = new ResultSet;
$result_set->set_result( $res );
$result_set->set_total_rows( sql_num_rows( $result_set ) );
$result_set->set_fetched_rows( 0 );
return $result_set;
break;;

case "ODBC":
case "ODBC_Adabas":
$res=@odbc_exec($id,$query);
return $res;
break;;

case "Interbase":
$res=@ibase_query($id,$query);
return $res;
break;;

case "Sybase":
$res=@sybase_query($query, $id);
return $res;
break;;

default:
break;;

}
}

/*
* sql_num_rows($res)
* given a result identifier, returns the number of affected rows
*/

function sql_num_rows($res)
{
global $dbtype;
switch ($dbtype) {

case "MySQL":
$rows=mysql_num_rows($res);
return $rows;
break;;

case "mSQL":
$rows=msql_num_rows($res);
return $rows;
break;;

case "PostgreSQL":
case "PostgreSQL_local":
$rows=pg_numrows( $res->get_result() );
return $rows;
break;;

case "ODBC":
case "ODBC_Adabas":
$rows=odbc_num_rows($res);
return $rows;
break;;

case "Interbase":
echo "<BR>Error! PHP dosen't support ibase_numrows!<BR>";
return $rows;
break;;

case "Sybase":
$rows=sybase_num_rows($res);
return $rows;
break;;

default:
break;;
}
}

/*
* sql_fetch_row(&$res,$row)
* given a result identifier, returns an array with the resulting row
* Needs also a row number for compatibility with PostgreSQL
*/

function sql_fetch_row(&$res, $nr=0)
{
global $dbtype;
switch ($dbtype) {

case "MySQL":
$row = mysql_fetch_row($res);
return $row;
break;;

case "mSQL":
$row = msql_fetch_row($res);
return $row;
break;;

case "PostgreSQL":
case "PostgreSQL_local":
if ( $res->get_total_rows() > $res->get_fetched_rows() ) {
$row = pg_fetch_row($res->get_result(), $res->get_fetched_rows() );
$res->increment_fetched_rows();
return $row;
} else {
return false;
}
break;;

case "ODBC":
case "ODBC_Adabas":
$row = array();
$cols = odbc_fetch_into($res, $nr, $row);
return $row;
break;;

case "Interbase":
$row = ibase_fetch_row($res);
return $row;
break;;

case "Sybase":
$row = sybase_fetch_row($res);
return $row;
break;;

default:
break;;
}
}

/*
* sql_fetch_array($res,$row)
* given a result identifier, returns an associative array
* with the resulting row using field names as keys.
* Needs also a row number for compatibility with PostgreSQL.
*/

function sql_fetch_array(&$res, $nr=0)
{
global $dbtype;
switch ($dbtype)
{
case "MySQL":
$row = array();
$row = mysql_fetch_array($res);
return $row;
break;;

case "mSQL":
$row = array();
$row = msql_fetch_array($res);
return $row;
break;;

case "PostgreSQL":
case "PostgreSQL_local":
if( $res->get_total_rows() > $res->get_fetched_rows() ) {
$row = array();
$row = pg_fetch_array($res->get_result(), $res->get_fetched_rows() );
$res->increment_fetched_rows();
return $row;
} else {
return false;
}
break;;

/*
* ODBC doesn't have a native _fetch_array(), so we have to
* use a trick. Beware: this might cause HUGE loads!
*/

case "ODBC":
$row = array();
$result = array();
$result = odbc_fetch_row($res, $nr);
$nf = odbc_num_fields($res); /* Field numbering starts at 1 */
for($count=1; $count < $nf+1; $count++)
{
$field_name = odbc_field_name($res, $count);
$field_value = odbc_result($res, $field_name);
$row[$field_name] = $field_value;
}
return $row;
break;;

case "ODBC_Adabas":
$row = array();
$result = array();
$result = odbc_fetch_row($res, $nr);

$nf = count($result)+2; /* Field numbering starts at 1 */
for($count=1; $count < $nf; $count++) {
$field_name = odbc_field_name($res, $count);
$field_value = odbc_result($res, $field_name);
$row[$field_name] = $field_value;
}
return $row;
break;;

case "Interbase":
$orow=ibase_fetch_object($res);
$row=get_object_vars($orow);
return $row;
break;;

case "Sybase":
$row = sybase_fetch_array($res);
return $row;
break;;

}
}

function sql_fetch_object(&$res, $nr=0)
{
global $dbtype;
switch ($dbtype)
{
case "MySQL":
$row = mysql_fetch_object($res);
if($row) return $row;
else return false;
break;;

case "mSQL":
$row = msql_fetch_object($res);
if($row) return $row;
else return false;
break;;

case "PostgreSQL":
case "PostgreSQL_local":
if( $res->get_total_rows() > $res->get_fetched_rows() ) {
$row = pg_fetch_object( $res->get_result(), $res->get_fetched_rows() );
$res->increment_fetched_rows();
if($row) return $row;
else return false;
} else {
return false;
}
break;;

case "ODBC":
$result = odbc_fetch_row($res, $nr);
if(!$result) return false;
$nf = odbc_num_fields($res); /* Field numbering starts at 1 */
for($count=1; $count < $nf+1; $count++)
{
$field_name = odbc_field_name($res, $count);
$field_value = odbc_result($res, $field_name);
$row->$field_name = $field_value;
}
return $row;
break;;

case "ODBC_Adabas":
$result = odbc_fetch_row($res, $nr);
if(!$result) return false;

$nf = count($result)+2; /* Field numbering starts at 1 */
for($count=1; $count < $nf; $count++) {
$field_name = odbc_field_name($res, $count);
$field_value = odbc_result($res, $field_name);
$row->$field_name = $field_value;
}
return $row;
break;;

case "Interbase":
$orow = ibase_fetch_object($res);
if($orow)
{
$arow=get_object_vars($orow);
while(list($name,$key)=each($arow))
{
$name=strtolower($name);
$row->$name=$key;
}
return $row;
}else return false;
break;;

case "Sybase":
$row = sybase_fetch_object($res);
return $row;
break;;

}
}

/*** Function Free Result for function free the memory ***/
function sql_free_result($res) {
global $dbtype;
switch ($dbtype) {

case "MySQL":
$row = mysql_free_result($res);
return $row;
break;;

case "mSQL":
$row = msql_free_result($res);
return $row;
break;;


case "PostgreSQL":
case "PostgreSQL_local":
$rows=pg_FreeResult( $res->get_result() );
return $rows;
break;;

case "ODBC":
case "ODBC_Adabas":
$rows=odbc_free_result($res);
return $rows;
break;;

case "Interbase":
echo "<BR>Error! PHP dosen't support ibase_numrows!<BR>";
return $rows;
break;;

case "Sybase":
$rows=sybase_free_result($res);
return $rows;
break;;
}
}

?>

Il primo warning fa riferimento alla riga 301.
In questa riga stai utilizzano istruzioni per PostgreSQL che non c'entra niente con mysql.
Hai decommentato le righe giuste? Vedo che sul tipo del db è ancora tutto come commento!

(Non sono perennemente online x cui passa un po' di tempo tra una risposta e l'altra!)

[MedMax]

ho sistemato un paio di cose, ma ricevo sempre degli errori:

Parse error: parse error in /membri/medmax/includes/sql_layer.php on line 37

Fatal error: Call to undefined function: sql_connect() in /membri/medmax/mainfile.php on line 49

Questo è il codice attuale:

<?php

/************************************************** **********************/
/* PHP-NUKE: Web Portal System */
/* =========================== */
/* */
/* Copyright (c) 2002 by Francisco Burzi */
/* http://phpnuke.org */
/* */
/* PostgreSQL fix by Rubén Campos - Oscar Silla */
/* */
/* This program is free software. You can redistribute it and/or modify */
/* it under the terms of the GNU General Public License as published by */
/* the Free Software Foundation; either version 2 of the License. */
/************************************************** **********************/

if (eregi("sql_layer.php",$PHP_SELF)) {
Header("Location: ../index.php");
die();
}

$dbtype = "MySQL";
/* $dbtype = "mSQL"; */
/* $dbtype = "PostgreSQL"; */
/* $dbtype = "PostgreSQL_local";// When postmaster start without "-i" option. */
/* $dbtype = "ODBC"; */
/* $dbtype = "ODBC_Adabas"; */
/* $dbtype = "Interbase"; */
/* $dbtype = "Sybase"; */


sql_connect($host, $user, $password, $db)
/* returns the connection ID
*/


class ResultSet {
var $result;
var $total_rows;
var $fetched_rows;

function set_result( $res ) {
$this->result = $res;
}

function get_result() {
return $this->result;
}

function set_total_rows( $rows ) {
$this->total_rows = $rows;
}

function get_total_rows() {
return $this->total_rows;
}

function set_fetched_rows( $rows ) {
$this->fetched_rows = $rows;
}

function get_fetched_rows() {
return $this->fetched_rows;
}

function increment_fetched_rows() {
$this->fetched_rows = $this->fetched_rows + 1;
}
}



function sql_connect($host, $user, $password, $db)
{
global $dbtype;
switch ($dbtype) {

case "MySQL":
$dbi=@mysql_connect($host, $user, $password);
if (!mysql_select_db($db)) {
mysql_query("CREATE DATABASE $db");
mysql_select_db($db);
include("includes/install.php");
die();
}
return $dbi;
break;;

case "mSQL":
$dbi=msql_connect($host);
if (!msql_select_db($db)) {
msql_query("CREATE DATABASE $db");
msql_select_db($db);
include("includes/install.php");
die();
}
return $dbi;
break;;


case "PostgreSQL":
$dbi=@pg_connect("host=$host user=$user password=$password port=5432 dbname=$db");
return $dbi;
break;;

case "PostgreSQL_local":
$dbi=@pg_connect("user=$user password=$password dbname=$db");
return $dbi;
break;;

case "ODBC":
$dbi=@odbc_connect($db,$user,$password);
return $dbi;
break;;

case "ODBC_Adabas":
$dbi=@odbc_connect($host.":".$db,$user,$password);
return $dbi;
break;;

case "Interbase":
$dbi=@ibase_connect($host.":".$db,$user,$password) ;
return $dbi;
break;;

case "Sybase":
$dbi=@sybase_connect($host, $user, $password);
if (!sybase_select_db($db,$dbi)) {
sybase_query("CREATE DATABASE $db",$dbi);
sybase_select_db($db,$dbi);
include("includes/install.php");
die();
}
return $dbi;
break;;

default:
break;;
}

}

function sql_logout($id)
{
global $dbtype;
switch ($dbtype) {

case "MySQL":
$dbi=@mysql_close($id);
return $dbi;
break;;

case "mSQL":
$dbi=@msql_close($id);
return $dbi;
break;;

case "PostgreSQL":
case "PostgreSQL_local":
$dbi=@pg_close($id);
return $dbi;
break;;

case "ODBC":
case "ODBC_Adabas":
$dbi=@odbc_close($id);
return $dbi;
break;;

case "Interbase":
$dbi=@ibase_close($id);
return $dbi;
break;;

case "Sybase":
$dbi=@sybase_close($id);
return $dbi;
break;;

default:
break;;
}
}


/*
* sql_query($query, $id)
* executes an SQL statement, returns a result identifier
*/

function sql_query($query, $id)
{

global $dbtype;
global $sql_debug;
$sql_debug = 0;
if($sql_debug) echo "SQL query: ".str_replace(",",", ",$query)."<BR>";
switch ($dbtype) {

case "MySQL":
$res=@mysql_query($query, $id);
return $res;
break;;

case "mSQL":
$res=@msql_query($query, $id);
return $res;
break;;

case "PostgreSQL":
case "PostgreSQL_local":
$res=pg_exec($id,$query);
$result_set = new ResultSet;
$result_set->set_result( $res );
$result_set->set_total_rows( sql_num_rows( $result_set ) );
$result_set->set_fetched_rows( 0 );
return $result_set;
break;;

case "ODBC":
case "ODBC_Adabas":
$res=@odbc_exec($id,$query);
return $res;
break;;

case "Interbase":
$res=@ibase_query($id,$query);
return $res;
break;;

case "Sybase":
$res=@sybase_query($query, $id);
return $res;
break;;

default:
break;;

}
}

/*
* sql_num_rows($res)
* given a result identifier, returns the number of affected rows
*/

function sql_num_rows($res)
{
global $dbtype;
switch ($dbtype) {

case "MySQL":
$rows=mysql_num_rows($res);
return $rows;
break;;

case "mSQL":
$rows=msql_num_rows($res);
return $rows;
break;;

case "PostgreSQL":
case "PostgreSQL_local":
$rows=pg_numrows( $res->get_result() );
return $rows;
break;;

case "ODBC":
case "ODBC_Adabas":
$rows=odbc_num_rows($res);
return $rows;
break;;

case "Interbase":
echo "<BR>Error! PHP dosen't support ibase_numrows!<BR>";
return $rows;
break;;

case "Sybase":
$rows=sybase_num_rows($res);
return $rows;
break;;

default:
break;;
}
}

/*
* sql_fetch_row(&$res,$row)
* given a result identifier, returns an array with the resulting row
* Needs also a row number for compatibility with PostgreSQL
*/

function sql_fetch_row(&$res, $nr=0)
{
global $dbtype;
switch ($dbtype) {

case "MySQL":
$row = mysql_fetch_row($res);
return $row;
break;;

case "mSQL":
$row = msql_fetch_row($res);
return $row;
break;;

case "PostgreSQL":
case "PostgreSQL_local":
if ( $res->get_total_rows() > $res->get_fetched_rows() ) {
$row = pg_fetch_row($res->get_result(), $res->get_fetched_rows() );
$res->increment_fetched_rows();
return $row;
} else {
return false;
}
break;;

case "ODBC":
case "ODBC_Adabas":
$row = array();
$cols = odbc_fetch_into($res, $nr, $row);
return $row;
break;;

case "Interbase":
$row = ibase_fetch_row($res);
return $row;
break;;

case "Sybase":
$row = sybase_fetch_row($res);
return $row;
break;;

default:
break;;
}
}

/*
* sql_fetch_array($res,$row)
* given a result identifier, returns an associative array
* with the resulting row using field names as keys.
* Needs also a row number for compatibility with PostgreSQL.
*/

function sql_fetch_array(&$res, $nr=0)
{
global $dbtype;
switch ($dbtype)
{
case "MySQL":
$row = array();
$row = mysql_fetch_array($res);
return $row;
break;;

case "mSQL":
$row = array();
$row = msql_fetch_array($res);
return $row;
break;;

case "PostgreSQL":
case "PostgreSQL_local":
if( $res->get_total_rows() > $res->get_fetched_rows() ) {
$row = array();
$row = pg_fetch_array($res->get_result(), $res->get_fetched_rows() );
$res->increment_fetched_rows();
return $row;
} else {
return false;
}
break;;

/*
* ODBC doesn't have a native _fetch_array(), so we have to
* use a trick. Beware: this might cause HUGE loads!
*/

case "ODBC":
$row = array();
$result = array();
$result = odbc_fetch_row($res, $nr);
$nf = odbc_num_fields($res); /* Field numbering starts at 1 */
for($count=1; $count < $nf+1; $count++)
{
$field_name = odbc_field_name($res, $count);
$field_value = odbc_result($res, $field_name);
$row[$field_name] = $field_value;
}
return $row;
break;;

case "ODBC_Adabas":
$row = array();
$result = array();
$result = odbc_fetch_row($res, $nr);

$nf = count($result)+2; /* Field numbering starts at 1 */
for($count=1; $count < $nf; $count++) {
$field_name = odbc_field_name($res, $count);
$field_value = odbc_result($res, $field_name);
$row[$field_name] = $field_value;
}
return $row;
break;;

case "Interbase":
$orow=ibase_fetch_object($res);
$row=get_object_vars($orow);
return $row;
break;;

case "Sybase":
$row = sybase_fetch_array($res);
return $row;
break;;

}
}

function sql_fetch_object(&$res, $nr=0)
{
global $dbtype;
switch ($dbtype)
{
case "MySQL":
$row = mysql_fetch_object($res);
if($row) return $row;
else return false;
break;;

case "mSQL":
$row = msql_fetch_object($res);
if($row) return $row;
else return false;
break;;

case "PostgreSQL":
case "PostgreSQL_local":
if( $res->get_total_rows() > $res->get_fetched_rows() ) {
$row = pg_fetch_object( $res->get_result(), $res->get_fetched_rows() );
$res->increment_fetched_rows();
if($row) return $row;
else return false;
} else {
return false;
}
break;;

case "ODBC":
$result = odbc_fetch_row($res, $nr);
if(!$result) return false;
$nf = odbc_num_fields($res); /* Field numbering starts at 1 */
for($count=1; $count < $nf+1; $count++)
{
$field_name = odbc_field_name($res, $count);
$field_value = odbc_result($res, $field_name);
$row->$field_name = $field_value;
}
return $row;
break;;

case "ODBC_Adabas":
$result = odbc_fetch_row($res, $nr);
if(!$result) return false;

$nf = count($result)+2; /* Field numbering starts at 1 */
for($count=1; $count < $nf; $count++) {
$field_name = odbc_field_name($res, $count);
$field_value = odbc_result($res, $field_name);
$row->$field_name = $field_value;
}
return $row;
break;;

case "Interbase":
$orow = ibase_fetch_object($res);
if($orow)
{
$arow=get_object_vars($orow);
while(list($name,$key)=each($arow))
{
$name=strtolower($name);
$row->$name=$key;
}
return $row;
}else return false;
break;;

case "Sybase":
$row = sybase_fetch_object($res);
return $row;
break;;

}
}

/*** Function Free Result for function free the memory ***/
function sql_free_result($res) {
global $dbtype;
switch ($dbtype) {

case "MySQL":
$row = mysql_free_result($res);
return $row;
break;;

case "mSQL":
$row = msql_free_result($res);
return $row;
break;;


case "PostgreSQL":
case "PostgreSQL_local":
$rows=pg_FreeResult( $res->get_result() );
return $rows;
break;;

case "ODBC":
case "ODBC_Adabas":
$rows=odbc_free_result($res);
return $rows;
break;;

case "Interbase":
echo "<BR>Error! PHP dosen't support ibase_numrows!<BR>";
return $rows;
break;;

case "Sybase":
$rows=sybase_free_result($res);
return $rows;
break;;
}
}

?>


Aiuto!!!

[MedMax]

Chi mi aiuta?

[MedMax]

aiutatemi, sono disperato!!!!!!! devo pubblicare il sito, ma ho qusti problemi!!!!!!!!!!!!!!!!!!!!