Jump to content

Connection problem with phprunner


hookit

Recommended Posts

I have created with Phprunner a website that is working find in te local server, but when i tried to upload to the remote server, connects with it a loads the remote mysql database but after a short while the program crahses. I have tried to tweak the php code with the remote database, host, user and password, but i do not where and how to do it, i enclose here the code of dbconnect.php

<?php

function db_connect() 
{
    global $host,$user,$pwd,$errstr,$sys_dbname,$port,$bSubqueriesSupported;
$strhost=$host;
if($port && $port!=3306)
	$strhost=$strhost.":".$port;
$conn = mysql_connect($strhost,$user,$pwd);
if (!$conn || !mysql_select_db($sys_dbname,$conn)) 
{
  trigger_error(mysql_error(), E_USER_ERROR);
}
$mysqlversion = "4";
$res = @mysql_query("SHOW VARIABLES LIKE 'version'",$conn);
if($row=@mysql_fetch_array($res,MYSQL_ASSOC))
	$mysqlversion = $row["Value"];
if(substr($mysqlversion,0,1)<="4")
	$bSubqueriesSupported=false;
return $conn;
}

function db_close($conn)
{
  return mysql_close($conn);
}

function db_query($qstring,$conn) 
{
global $strLastSQL;
$strLastSQL=$qstring;
if(!($ret=mysql_query($qstring,$conn)))
{
  trigger_error(mysql_error(), E_USER_ERROR);
}
return $ret;

}

function db_exec($qstring,$conn)
{
return db_query($qstring,$conn);
}

function db_pageseek($qhandle,$pagesize,$page)
{
db_dataseek($qhandle,($page-1)*$pagesize);
}

function db_dataseek($qhandle,$row)
{
   mysql_data_seek($qhandle,$row);
}

function db_numrows($qhandle) {
// return only if qhandle exists, otherwise 0
if ($qhandle) {
	return @mysql_numrows($qhandle);
} else {
	return 0;
}
}

function db_result($qhandle,$row,$field) {
return @mysql_result($qhandle,$row,$field);
}


function db_affected_rows($qhandle) {
return @mysql_affected_rows();
}

function db_fetch_array($qhandle) {
return @mysql_fetch_array($qhandle,MYSQL_ASSOC);
}

function db_fetch_numarray($qhandle) {
return @mysql_fetch_array($qhandle,MYSQL_NUM);
}

function db_insertid($qhandle) {
return @mysql_insert_id($qhandle);
}

function db_error() {
return @mysql_error();
}





function parsevalues($enum)
{
$values=array();
$i=0; $j=0;
$inquot=false;
while($i<strlen($enum))
{
	if($enum[$i]=="'")
		$nquot=!$inquot;
	else if(!$inquot && $enum[$i]==',')
	{
		$val=substr($enum,$j+1,$i-$j-2);
		$values[]=str_replace("''","'",$val);
		$j=$i+1;
	}
	$i++;
}
if($i-$j-2>0)
{
	$val=substr($enum,$j+1,$i-$j-2);
	$values[]=str_replace("''","'",$val);
}
return $values;
}



function db_addslashes($str)
{
return mysql_escape_string($str);
}

function db_stripslashes($str)
{
return stripslashes($str);
}

function db_addslashesbinary($str)
{
return "'".mysql_escape_string($str)."'";
}

function db_stripslashesbinary($str)
{
return $str;
}

/*
function IsAutoIncrementField($field)
{
global $strTableName;
if(strpos($_SESSION[$strTableName."_fieldinfo"][$field]["extra"],"auto_increment")===FALSE)
	return false;
return true;
}
*/



// adds wrappers to field name if required
function AddFieldWrappers($strName)
{
global $strLeftWrapper,$strRightWrapper;
if(substr($strName,0,1)==$strLeftWrapper)
	return $strName;
return $strLeftWrapper.$strName.$strRightWrapper;
}

function AddTableWrappers($strName)
{
return AddFieldWrappers($strName);
}

// removes wrappers from field name if required
function RemoveFieldWrappers($strName)
{
global $strLeftWrapper,$strRightWrapper;
if(substr($strName,0,1)==$strLeftWrapper)
	return substr($strName,1,strlen($strName)-2);
return $strName;
}

function RemoveTableWrappers($strName)
{
return RemoveFieldWrappers($strName);
}

function db_upper($dbval)
{
return "upper(".$dbval.")";
}

function db_datequotes($val)
{
return "'".$val."'";
}


function db_numfields($lhandle) {
return @mysql_numfields($lhandle);
}

function db_fieldname($lhandle,$fnumber) {
           return @mysql_fieldname($lhandle,$fnumber);
}

function db_fieldtype($lhandle,$fname) {
for($i=0;$i<db_numfields($lhandle);$i++)
	if(db_fieldname($lhandle,$i)==$fname)
		return db_fieldtypen($lhandle,$i);
return "";
}



function db_fieldtypen($lhandle,$fnumber) {
$type=mysql_fieldtype($lhandle,$fnumber);
if($type=="blob")
{
	$flags=mysql_fieldflags($lhandle,$fnumber);
	if(strpos($flags,"binary")===false)
		$type="text";
}
return $type;
}


function FieldNeedQuotes($rs,$field)
{
$type=db_fieldtype($rs,$field);
$t=strtoupper($type);
if($t=="TINYINT" || $t=="SMALLINT" || $t=="MEDIUMINT" || $t=="INT" || $t=="BIGINT"
     || $t=="YEAR" || $t=="FLOAT" || $t=="DOUBLE" || $t=="DECIMAL" || $t=="NUMERIC"
 || $t=="REAL" )
	return false;
return true;
}


/*



function db_fieldnull($rs,$i)
{
$flags=mysql_field_flags($rs,$i);
if(strpos($flags,"not_null")===false)
	return true;
return false;
}

function db_fieldlen($rs,$i)
{
return mysql_field_len($rs,$i);
}
*/

/*



function IsBinaryType($t)
{
$type=strtoupper($t);
if($type=="TINYBLOB" || $type=="BLOB" || $type=="MEDIUMBLOB" || $type=="LONGBLOB")
	return true;
return false;
}

function IsDateFieldType($stype)
{
$type=strtoupper($stype);
if($type=="DATE" || $type=="DATETIME" || $type=="TIME" || $type=="TIMESTAMP")
	return true;
return false;
}


function IsCharType($stype)
{
$type=strtoupper($stype);
if($type=="STRING" || $type=="CHAR" || $type=="VARCHAR" || $type=="TEXT" || $type=="ENUM" || $type=="SET")
	return true;
return false;
}

function IsTextType($type)
{
if(strtoupper($type)=="TEXT")
	return true;
return false;
}

function GetTableInfo()
{
global $strTableName,$conn;
$strSQL = "SHOW Columns from ".AddTableWrappers($strTableName);
$rs = db_query($strSQL,$conn);
$_SESSION[$strTableName."_fieldinfo"]=array();
while($data=db_fetch_array($rs))
{
	$_SESSION[$strTableName."_fieldinfo"][$data["Field"]] = array();
	$f = & $_SESSION[$strTableName."_fieldinfo"][$data["Field"]];
	$type=$data["Type"];
//	remove type modifiers
	if(substr($type,0,4)=="tiny")	$type=substr($type,4);
	else if(substr($type,0,5)=="small")	$type=substr($type,5);
	else if(substr($type,0,6)=="medium")	$type=substr($type,6);
	else if(substr($type,0,3)=="big")	$type=substr($type,3);
	else if(substr($type,0,4)=="long")	$type=substr($type,4);
	if(substr($type,0,4)=="enum")
	{
		$f["values"]=parsevalues(substr($type,5,strlen($type)-6));
		$f["type"]="enum";
	}
	else if(substr($type,0,3)=="set")
	{
		$f["values"]=parsevalues(substr($type,4,strlen($type)-5));
		$f["type"]="set";
	}
	else
	{
		if($pos=strpos($type," "))
			$type=substr($type,0,$pos);
//	parse field sizes
		if($pos=strpos($type,"("))
		{
			if($pos1=strpos($type,",",$pos))
			{
				$f["size"]=(integer)substr($type,$pos+1,$pos1-$pos-1);
				$f["scale"]=(integer)substr($type,$pos1+1,strlen($type)-$pos1-2);
			}
			else
			{
				$f["size"]=(integer)substr($type,$pos+1,strlen($type)-$pos-2);
				$f["scale"]=0;
			}
			$type=substr($type,0,$pos);
		}
		$f["type"]=$type;
	}
	$f["extra"]=@$data["Extra"];
	$f["key"]=@$data["Key"];
	$f["default"]=@$data["Default"];
	$f["null"]=@$data["Null"];
}
}

*/
?>

 

any help?

Link to comment
Share on other sites

This thread is more than a year old. Please don't revive it unless you have something important to add.

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Reply to this topic...

×   Pasted as rich text.   Restore formatting

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.