PHP - Really Odd Mysqli_fetch_array Behaviour

Hey everyone I've been working on converting my old mysql code to to the mysqli version and am running into some trouble. I am pulling posts form phpbb and displaying them in a script. My first script below works just fine.

Code: [Select]
<?php
require("connect.php");
$query="SELECT * FROM phpbb_topics WHERE (forum_id='13' OR forum_id='14') AND topic_status = '0'";
$query2="SELECT * FROM phpbb_topics WHERE (forum_id='15' OR forum_id='16') AND topic_status = '0'";
$result=mysql_query($query);
$result2=mysql_query($query2);

echo "<table border=0 cellpadding=2>";
echo "<tr><td>Lost</td><td>Found</td></tr>";
while($row=(mysql_fetch_array($result)) || $row2=(mysql_fetch_array($result2)))
{

$forum_id=mysql_result($result,$k,"forum_id");
$topic_id=mysql_result($result,$k,"topic_id");
$topic_title=mysql_result($result,$k,"topic_title");

$forum_id2=mysql_result($result2,$k,"forum_id");
$topic_id2=mysql_result($result2,$k,"topic_id");
$topic_title2=mysql_result($result2,$k,"topic_title");

echo "<tr><td width='15%'><a href=/sahbb/viewtopic.php?f=$forum_id&t=$topic_id>$topic_title</a></td>
<td width='15%'><a href=/sahbb/viewtopic.php?f=$forum_id2&t=$topic_id2>$topic_title2</a></td>
</tr>";
$k++;

}
echo "</table>";
mysql_close($connect);
?>

however its not very clean or memory efficient so i have converted it to the following.

Code: [Select]

<?php
require("includes_database/mysqli_connect.php");
$query="SELECT * FROM phpbb_topics WHERE (forum_id='13' OR forum_id='14')";
$query2="SELECT * FROM phpbb_topics WHERE (forum_id='15' OR forum_id='16')";
$result=mysqli_query($dbc, $query);
$result2=mysqli_query($dbc, $query2);

echo "<table border=1 cellpadding=2>";
echo "<tr><td>Lost</td><td>Found</td></tr>";
while(($row = mysqli_fetch_array($result, MYSQLI_ASSOC)) || ($row2 = mysqli_fetch_array($result2, MYSQLI_ASSOC)))
{

echo "<tr><td width='15%'><a href=/sahbb/viewtopic.php?f=".$row['forum_id']."&t=".$row['topic_id'].">".$row['topic_title']."</a></td>
<td width='15%'><a href=/sahbb/viewtopic.php?f=".$row2['forum_id']."&t=".$row2['topic_id'].">".$row2['topic_title']."</a></td>
</tr>";

}
echo "</table>";

mysqli_free_result($result);
mysqli_free_result($result2);
mysqli_close($dbc);

?>


I know the error is in my while loop but i cant seem to figure out exactly where. The new code displays all of the first query in the table and then below that it displays the next query insted of displaying them side by side below would be an example of what is happening


[table Lost Found Lost, Australian Sheppard Lost German Shepherded / Collie Mix Lost Golden Retriever/Cocker Mix Lost Female Grey Tiger Lost Pitbull Mix Lost 2 Chihuahua Lost Black Lab Lost - German Shepard Mix and Lab Mix Lost - Female German Sheperd Aprox 8 Week Old Kitten Found! 2 Pugs FOUND Found 1 Corgi female/ 1 Shih Tzu male Found Tan and Black Australian Shepard Found Australian Shepard Found Intact Male Pitbull/Lab Mix
Any help that any of you could provide would be greatly appreciated!

Hi I am a student who is fairly new to PHP and MySQL. I have been working on creating a registration page for a website and I'm getting the following warnings when I've tested the page:   Warning: mysqli_fetch_array() expects parameter 1 to be mysqli_result, boolean given in /home/ed12e2w/public_html/COMM2735/dynamic_website/registration.php on line 74

Warning: mysqli_free_result() expects parameter 1 to be mysqli_result, boolean given in /home/ed12e2w/public_html/COMM2735/dynamic_website/registration.php on line 80   I think that my query has failed but I'm not completely sure on what to change in order to solve this.   Here is the section of code I'm having problems with:     Attached Files  register.php   733bytes   4 downloads

Someone help me in this problem please??

Warning: mysqli_fetch_array() expects parameter 1 to be mysqli_result, boolean given in line 8

$rec= mysqli_query ($db, "SELECT FROM joborder WHERE id=$id");

$record = mysqli_fetch_array ($rec); // line 8

$fnames= $record ['fnames'] ; 

Edited March 8 by kei

Warning: mysqli_fetch_array() expects parameter 1 to be mysqli_result, boolean given in /home/myritebook/public_html/footer.php on line 13

I am trying to fix the above error.

Please Help.

code is given below:

<?php
include 'db.php';

if ($conn) {
   echo "Database Found ";
}
else {
 die("Database connection failed");
}
$find_count=mysqli_query($conn,"SELECT * FROM count_number");

while($row=mysqli_fetch_array($find_count));
{
$current_count=$row['count'];
$new_count=$current_count+1;

try{
$sql= "UPDATE count_number SET count = '$new_count' where id=1";  
$update_count=mysqli_query ($conn,$sql);

}

catch(Exception $e){
echo 'error;'.$e->getMessage();
}
}
?>

I have a development machine running WAMP on a win7 64 bit box. php 5.3.13 I have a server that runs Apache 2.2, php 5.3.12 MySql, etc.   I am running joomla 2.5.27 on both machines. I require a number of php includes to many of the joomla articles (this works great via a plugin called Directphp)   After considerable time getting the site fully working on the dev machine, I ran into an unforseen problem when I uploaded to the production box. For some unknown reason, the includes work fine on the dev machine using $DOCUMENT_ROOT to define the root (then tag the correct path and file to this) However, on the production box, this doesn't work - but...  $_SERVER['DOCUMENT_ROOT'] does.   Annoyingly, $_SERVER['DOCUMENT_ROOT'] won't work on the dev machine - and $DOCUMENT_ROOT doesn't work on the production box.   So, I can't come up with a generic method to keep both machines happy. I've checked the php.ini files on both boxes and the register global is OFF on both.   They also seem to interperate the syntax differently in the actual include files - one box hates double quotes - the other has issues with single quotes. This is really annoying as most of the includes are HTML snippets, coded into php. The double/single quote problem means I would need to have two versions of the include files.   Can anyone help me with this? - serious hair pulling has started!        

Please help.  I have tried to condense the following code to make it easier for someone to shed insight.  The results make totally no sense to me.   I have the following two lines of code:
 

require_once('/var/www/bidjunction/application/classes_3rd/htmlpurifier/library/HTMLPurifier.auto.php');
$config = HTMLPurifier_Conf::createDefault();

Let me explain what happens in these two lines of code.  First....

require_once('/var/www/bidjunction/application/classes_3rd/htmlpurifier/library/HTMLPurifier.auto.php'):

HTMLPurifier.auto.php is shown below:

<?php

/**
 * This is a stub include that automatically configures the include path.
 */

set_include_path(dirname(__FILE__) . PATH_SEPARATOR . get_include_path() );
require_once 'HTMLPurifier/Bootstrap.php';
require_once 'HTMLPurifier.autoload.php';

// vim: et sw=4 sts=4

The only thing Bootstrap.php does is define a class and execute the following line:
 

define('HTMLPURIFIER_PREFIX', realpath(dirname(__FILE__) . '/..'));

The only thing HTMLPurifier.autoload.php does is execute HTMLPurifier_Bootstrap::registerAutoload()  (which was one of the classes defined in Bootstrap.php). The only thing HTMLPurifier_Bootstrap::registerAutoload() does is:

spl_autoload_register(array('HTMLPurifier_Bootstrap','autoload'), true, true);

Now the second line:

$config = HTMLPurifier_Conf::createDefault();

I expected that HTMLPurifier_Conf::createDefault() would be executed, but no, instead the script goes to HTMLPurifier_Bootstrap:autoload() which returns false.

Next, the script goes to function PHPMailerAutoload() which is in PHPMailerAutoload.php.

What!!!  What does PHPMailerAutoload have to do with this?   While a perfect answer would be great, general comments and a strategy to troubleshoot be the next best thing.   I am stumped! Please help.

I have something strange going on with sessions set after a user logs in.

After posting the form, the following code (only part of the log in script) correctly assigns the users ID to $_SESSION['id'] but after a while it starts showing up as the users level ($_SESSION['level']). I have rechecked all of my code to see if something mistakenly assigns the level to $_SESSION['id'] but everything seems fine.

I am going to rewrite the log in script today, as I am sure that I can streamline it but wondered if anyone can give any advice on what it happening here to make sure I do not fall into the same trap!

Thanks
Steve

$username = mysql_escape_string($_POST['Lname']);  
$password = mysql_escape_string(md5($_POST['Lpassword'])); 
   
  $search = mysql_query("SELECT 
  userid, username, password, active, level 
  FROM 
  users WHERE username like binary '".$username."' AND password='".$password."' AND active='1'") 
  or die(mysql_error());  
  
  $match  = mysql_num_rows($search);  
  $level = mysql_fetch_assoc($search);
  
if($match > 0) //The username and password is correct
  {//START MANUAL LOGIN & SET SESSION VARIABLES  
  $_SESSION['user'] = $username;
  $_SESSION['level'] = $level['level'];
  $_SESSION['loggedin'] = '1';
  $_SESSION['id'] = $level['userid'];
 

I have 2 pieces of different code that get run at different times, but act on the same text file.
(The first example writes data and the second rewrites data with some expired data removed from the rewrite.)

The first code example appends data to a new line each time it is run except when it is run just after the second code example has ran. When run after the second example, the first code example will append the data to the last line of the text file instead of appending to a new line.
Why is this?

Here is the first code example...
Code: [Select]
<?php

$message = "Hello, World! \nGoodbye!";
$message_br = str_replace("\n", '<br />', $message); // couldn't use nl2br because i needed to remove the \n completely. 
$userName = "Anon";
$coordinates = "1234567890";
$locationType = "geo";
$dateDay = "23";
$dateMonth = "2";
$dateYear = "2011";
$timeHour = "9";
$timeMins = 45;
$timeAMPM = "AM";

// Format the time/Date
date_default_timezone_set('UTC');
$inputTime = date('c', mktime((int)$timeHour, (int)$timeMins, 0, (int)$dateMonth, (int)$dateDay, (int)$dateYear));

// Send all data so far, to an array.
$entry_array = array();
array_push($entry_array, $inputTime, $locationType, $coordinates, $userName, $message_br);

// write the array to CSV file.
$fp = fopen('messages.txt', 'a');
fputcsv($fp, $entry_array, "|");
fclose($fp);

?>

Here is the second...
Code: [Select]
<?php

$one_day = 60*60*24;
$timestamp = time();
date_default_timezone_set('UTC');
$expiry_date = date('c', $timestamp+$one_day); 

$future_date = array();
$delete_line = array();

// Open existing data in the text file.
$lines = file('messages.txt', FILE_IGNORE_NEW_LINES | FILE_SKIP_EMPTY_LINES); 
foreach ($lines as $line){
  list($field1, $field2, $field3, $field4, $field5) = explode('|', $line);
  if ($field1 < $expiry_date){ 
    array_push($delete_line, $line); // add to the to-be-deleted array.
  }
  else { array_push($future_date, $line); }
}

$array2string = implode("\n", $future_date); // convert array data to string.

// write the data to CSV file.
$fp = fopen('messages.txt', 'w');
fwrite($fp, $array2string);
fclose($fp);

?>

Hi Guys, I am fairly new to PHP, and I recently changed my whole site to use PHP sessions, which worked fine.
Then I added PHP parts in my pages that display different menu choices depending on if a PHP session exists. This also works fine, until I found that any HTML/PHP pages that have form/submits no longer work, and I get kicked back to the index.php

After slow backtracking, I removed new parts, and found the forms started working again if I removed the PHP part that chooses which JavaScript file to reference, as follows from contact.php

<?php
if (isset($_SESSION['SESS_MEMBER_ID'])){
    echo "<script language=\"JavaScript\" type=\"text/javascript\" src=\"menu_horz.js\"></script>";
}
else {echo "<script language=\"JavaScript\" type=\"text/javascript\" src=\"log_menu_horz.js\"></script>";
}
?>

I tried changing the echo ".." to use single quotes ' '  instead, but then it doesn't work at all then with a form or no form on the page. I assume I am doing something wrong, but I can't find any resources that give me a definitive way of referencing Javascript files.  What freaked me out was only the ones with forms were an issue.
I am using <?php session_start(); ?> at the beginning of every page (before any output). Other PHP code on the page is working fine. Only the above part seems to be the problem, and works too, as long as I don't submit a form.

- Could it be more weirder :-)

- I tried also to find a workaround, but it would mean having PHP inside my JavaScript file, but I am not sure it would work, since JS is client side, and PHP server...  Essentially, I just want to run certain JS menus depending if the person is logged in or not.

- Example contact.php attached

Any ideas of what the problem might be with the code above?
Will be grateful for any help you can give.

Regards
D

This topic has been moved to JavaScript Help.

http://www.phpfreaks.com/forums/index.php?topic=306496.0