PHP - Website Server Was Upgraded To Php 5.4.30 And Now Doesn't Work

Okay, some code broke.  I was doing this, basically.

inc_db.php
Code: [Select]
<?php
$link_db = mysql_connect('localhost','user','pass') or die('Could not connect: ' . mysql_error());
mysql_select_db('main_db') or die ('Could not select database');
?>

inc_other_db.php
Code: [Select]
<?php
$other_db = mysql_connect('localhost','user','pass') or die('Could not connect: ' . mysql_error());
mysql_select_db('other_db') or die ('Could not select database');
?>

funcs.php
Code: [Select]
<?php
function do_something( $a, $b )
{
     $query  = "SELECT id FROM users WHERE a = '$a' AND b = '$b'";
     $result = mysql_query( $query ) or die ( 'Query result failed: ' . mysql_error() );
     // do something with result
}
?>

Caveat: One script pulls in inc_other_db.php *after* the inc_db.php so it uses that.
New funcs.php

Code: [Select]
<?php
function do_something( $a, $b )
{
     global $linkdb;
     $query  = "SELECT id FROM users WHERE a = '$a' AND b = '$b'";
     $result = mysql_query( $query, $linkdb ) or die ( 'Query result failed: ' . mysql_error() );
     // do something with result
}
?>

Runs, but mysql_query() always fails, and mysql_error() always returns a blank error.
Any ideas?

Something big changed in PHP5 that I'm totally missing?  I'm getting jack in the PHP error logs.
How can I print out some info about $linkdb in my function?  I checked it with if ( !$linkdb) and isset(), and both seemed fine.   
Totally frustrated.  Sleeping now.

Hi All

I have been working on a project in PHP for about three months. I have been happily working away with a WAMP server locally all that time. The problem arose today when I uploaded the project to a web server. I uploaded all the files by FTP and imported a mysql database on the new web server. When I went to view my home page I got the following error:

Parse error: syntax error, unexpected T_STRING in /home/priestbr/public_html/output_fns.php on line 1

My index page references an include to a page which stores my functions:

<?php
 error_reporting(E_ALL ^ E_NOTICE);
 session_start();
include('priest_br_fns.php');

The priest_br_fns.php then includes a further 3 includes as below:

<?php
  include_once('db_fns.php');
  include_once('output_fns.php');
  include_once('general_fns.php');
 ?>


PHP seems to parse the db_fns.php page OK and fails at output_fns.php (as per the parse error msg). But here's the thing....during some investigation I deleted the contents of db_fns.php and pasted in the contents of output_fns.php and then the page got parsed OK!

Anyone have any idea why it's failing? Is it something to do with how I have the includes set up? I really need all the includes working obviously for the site to run.

For info my local server where the site works perfectly is set up as below:

PHP 5.2.6, MySQL 5.0.51a, Apache 2.2.8

The web server is set up like this:

PHP 5.2.1.14, MySQL 5.0.91, Apache 2.2.16.

Thanks in advance,

Craig

Hi All,

This has been driving me crazy for a while now. I was on an older version of PHP and everything was working fine but a few weeks ago my hosting upgraded the PHP to version 5 (I think) and I have started to get problems. I have a form that is completed and also 5 images can be added and then submitted which should save it to the database. But the images are not being saved anymore.

I have attached the code that I am using and it did work before.

On another note I was having a problems with the other fields on the forms where characters such as ! or , etc would cause problems. I got over this by using '.mysql_real_escape_string'. Should I be doing something like this for the images that I want to upload?

I hope I am making sense.

Thanks

$Row[2] doesn't work but if I use $Row["linkcat"] than it works fine.
Is there somewhere to activate in the php.ini file ?


Code: [Select]
// I got 9 fields to in the table tbl_link !  $Row[2] should give me a number.

$Verbinding = mysql_connect($db_host, $db_user, $db_passw);
mysql_select_db($db_name);
$sql = "Select * from tbl_link where userid=1";
$ResultShow = mysql_query($sql);

while ($Row = mysql_fetch_assoc($ResultShow)){
 
    echo $Row[2];

}

I've joined querys because I'm making my own forums. However, when it gets to the echoin out part, it shows the category and only ONE of the sub categorys.

Code: [Select]
<div id="forumContainer">
<?php
$lastboard = '';

$forumQ = mysql_query("SELECT

   f1.cat_name as catName,
   f1.cat_id as catID,
   f2.cat_id as subCatID,
   f2.sub_id as subID,
   f2.sub_name as subName,
   f2.sub_desc as subDesc
   
   FROM `forum_cats` as f1
    LEFT JOIN `forum_sub` as f2
    ON f1.cat_id = f2.cat_id
   GROUP BY f2.cat_id
   ");
  
while($forumF = mysql_fetch_assoc($forumQ))
{
if($forumF['catName'] != $lastboard)
{
echo '<div class="forumCat">'.$forumF['catName'].'</div>';
$lastboard = $forumF['catName'];
}
echo '<div class="forumSub">'.$forumF['subName'].'</div>';
}
?>
</div>

I just started with php and made an image. But when I try to open it in my browser, it shows a broken image icon. I have put the font in the same folder as the .php file, but it doesn't work. Can somebody help me solve this problem?

Here is the code:
Code: [Select]
<?php
$font_path = "nakedchick.TTF";
$font_size = 30;

$img_number = imagecreate(300,50);
$backcolor = imagecolorallocate($img_number,0,162,255);
$textcolor = imagecolorallocate($img_number,255,255,255);

imagefill($img_number,0,0,$backcolor);
$number = " So your ip is $_SERVER[REMOTE_ADDR]? ";

ImageTTFText($img_number, $font_size,10,5,5,$number,$font_path,$textcolor);

header("Content-type: image/png");
imagepng($img_number);
?>

And also the files: (.php in attachment)
http://falcogerritsjans.nl/u/signature2.php
http://falcogerritsjans.nl/u/nakedchick.ttf

All the tables are correct and it's making the connect to the database fine it's just not working, did I write it wrong?


Code: [Select]
function newPm($to, $from, $title, $text){
$q = $db->query("SELECT * FROM ibf_message_topics ORDER BY mt_id DESC");
$lastMsg = $db->fetch_assoc($q);
$mid = $lastMsg['mt_id'] + 1;
$msgId = $lastMsg['mt_msg_id'] + 1;
$db->query("INSERT INTO ibf_message_topics SET mt_id=$mid, mt_msg_id=$msgId, mt_date=". time(). ", mt_title='$title', mt_from_id=$from, mt_to_id=". $to. ", mt_vid_folder='in', mt_read=0, mt_owner_id=$to, mt_user_read=0") or die(mysql_error());
$db->query("INSERT INTO ibf_message_text SET msg_id=$msgId, msg_date=". time() .", msg_post='$text', msg_sent_to_count=1, msg_author_id=$from") or die(mysql_error());
$userq = $db->query("SELECT new_msg FROM ibf_members WHERE id = $to");
$userData = $db->fetch_assoc($userq);
$msgCount = $userData['new_msg'] + 1;
$db->query("UPDATE ibf_members SET new_msg=$msgCount, show_popup=1 WHERE id = $to") or die(mysql_error());
}

Here's how that function is being called in the beginning of the page:


Code: [Select]
if($action =="banUser"){
$expire = time() + (3600000 * 24 * $_GET['duration']);
$q = $db->query("SELECT * FROM ibf_message_topics ORDER BY mt_id DESC");
$lastMsg = $db->fetch_assoc($q);
$mid = $lastMsg['mt_id'] + 1;
$msgId = $lastMsg['mt_msg_id'] + 1;
$title = "Notification";
$duration = $_GET['duration'] ." days";
if($_GET['duration'] == "1"){
$duration = "1 day";
}
if($_GET['duration'] == "Forever"){
$duration = "forever";
}
$temp = 0;
if($expire > time()){
$temp = 1;
}
$body = "This automated message has been sent to notify you that your account has been banned $duration.  To appeal this ban, click on Irc from the menu on the homepage and ask to speak to a moderator.  If this ban is temporary, your account will be reinstated automatically at the appropriate time";
newPm($id, 3017, $title, $body);
$msgCount = $_GET['msg'] + 1;
$db->query("UPDATE ibf_members SET ban_level = $level, tempbanned = $temp, banned = 1, ban_expire='$expire', ban_reason='". $_GET['reason']."', ban_by='". $name."' WHERE id=$id") or die(mysql_error());
?>
<center><b>User banned!</b> (<a href="index.php?code=plyrmgmt">Back to Player Management</a>)</center>

Hello,
I've been working on some stuff, and get the information parsed like this:
Code: [Select]
Value1,Value2,Value3 0.68,4377.54,11069.02So I'm trying to explode it and insert the latest numbers into the database. I'm using:

$value = explode(",", $variable);
$secondsplit = explode(" ", $value[2]);
mysql_query("INSERT INTO table(row) VALUES('".mysql_real_escape_string($secondsplit[1])."')");

The problem is that it has something like an enter in the database, or a space. But I can't figure out how to get rid of that problem. Does anyone know what's wrong?

Regards,
NLCJ

Hello all, I'm trying to clean up some user input for my database but the mysql_real_escape_string function doesn't seem to work, and neither does addslashes(). I've browsed the net and made sure I'm connected to the database before the function is called. I can't figure out what I'm doing wrong. Here's the relevant part of the code:

Code: [Select]
<?php

mysql_connect("localhost","adminname","adminpassword") or die (mysql_error());
mysql_select_db("databasename") or die (mysql_error());

$comment=mysql_real_escape_string($_POST['commentbox']);

?>
...and then the result is put into the database along with some other data.

The database entry is correct, except, when I check the database or echo the result I get the same thing that was entered into 'commentbox'. For instance, if I enter "I am very 'confused' by this" into the box, the same string will be found in the database table. No slashes, just quotes. Anyone have an idea what's wrong with this? Because it all seems simple and correct but doesn't work.

I have something like below

Code: [Select]
$j = explode("-", $ROW['options']);
if(array_search("src_str", $j) == false) echo '_no';      // This doesn't work
Also i tried
Code: [Select]
$j = explode("-", $ROW['options']);
if(!in_array("src_str", $j)) echo '_no';      // This also doesn't work
Is this bug or am i doing something wrong?

Im using func_get_args, but it gives an error?:

Too few arguments?, when its correct (as the number of %s = the number of values within $args)

<?php
function sprintify() {
global $urls;
$args = func_get_args();
$input = $args[0];
unset($args[0]);
return sprintf($urls[$input], implode(', ', $args));
}

echo sprintify('default', 46, 464, 46);

/*
For your information:
$urls['default'] = '%s/%s/%s';
*/
?>

Hi, when I output this, it's same order, I want it to be:

email/message/to/toLastName

please see code:
$testArray=array("toLastName","to","message","email");
$reversedTestArray=rsort($testArray);//rsort returns TRUE on success
//$strTestArrayReversed=implode(",",$testArray);
print_r($testArray);

Any idea what I am doingwrong, it looks fairly straightforward.

Any help much appreciated!

Hey,

$todo_upgrades_sql = "SELECT * FROM todo_upgrades WHERE time_completion >= $time";
$todo_upgrades_res = mysql_query($todo_upgrades_sql) or die (mysql_error()); results:

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1

Hi, I am trying to get the previous id for the table xdocument, but browser outputs this warning:

Warning: mysql_num_rows() expects parameter 1 to be resource, boolean given

for this code:
Code: [Select]
<?php
//HELPER FCN used by FCN: writeXMLtoDBviaDOM
function mysql_next_id($table) {
    $result = mysql_query('SHOW TABLE STATUS LIKE "'.$table.'"');
    $rows = mysql_fetch_assoc($result);
    return $rows['Auto_increment'];
}

//TEST RUN:
$_filePath="C:\dir\email.xml";
$node=basename($_filePath);
$dom=new DOMDocument();
$dom->load($node);
$labelPath=array();
mysql_connect("localhost","root");
mysql_select_db("dummydpev");
$isXdocExist=mysql_query("SELECT (file_Path,file_Name) FROM xdocument WHERE file_Path='$_filePath' AND file_Name='$node'");
$docId=0;

if(mysql_num_rows($isXdocExist)==0) {
mysql_query("INSERT INTO xdocument (file_Path,file_Name) VALUES ('$_filePath','$node')");
$docId=mysql_next_id("xdocument")-1;
}
else
$docId=mysql_next_id("xdocument")-1;

writeXMLtoDBViaDOM($dom->documentElement,$labelPath,$docId,$_filePath);
?>
So I think my problem is with the multiple WHERE clause conditions, can I do it like what I have above?

Any help much appreciated!