SitePoint Sponsor

User Tag List

Results 1 to 4 of 4

Thread: I got an error

  1. #1
    SitePoint Member
    Join Date
    Oct 2010
    0 Post(s)
    0 Thread(s)

    Smile I got an error

    I am going through the book Build Your Database Driven Web Site. I am on chapter 5 and I am trying to get the jokes.html.php page to load and work. I am getting this error when I try to install a joke to the data base. Warning: Invalid argument supplied for foreach() in C:\xampp\htdocs\chapter5\jokes\jokes.html.php on line 12

    Here is the code I am working with I just do not see a problem on line 12.
    <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Strict//EN"
    <html xmlns="" xml:lang="en" lang="en">
    		<title>List of Jokes</title>
    		<meta http-equiv="content-type"
    				content="text/html; charset=utf-8"/>
    		<p><a href="?addjoke">Add your own joke</a></p>
    		<p>Here are all the jokes in the database:</p>
    		<?php foreach ($jokes as $joke): ?>
    			<form action="?deletejoke" method="post">
    						<?php echo htmlspecialchars($joke['text'], ENT_QUOTES,
    								'UTF-8'); ?>
    						<input type="hidden" name="id" value="<?php
    								echo $joke['id']; ?>"/>
    						<input type="submit" value="Delete"/>
    						(by <a href="mailto:<?php
    								echo htmlspecialchars($joke['email'], ENT_QUOTES,
    										'UTF-8'); ?>"><?php
    								echo htmlspecialchars($joke['name'], ENT_QUOTES,
    										'UTF-8'); ?></a>)
    		<?php endforeach; ?>
    Thank you in advance for all help Codin.

  2. #2
    SitePoint Wizard bronze trophy
    Join Date
    Jul 2006
    Augusta, Georgia, United States
    16 Post(s)
    4 Thread(s)
    $jokes has not been defined. You can't iterate over something that does not exist. Though, if it has been defined (just not showing the code) then that error means that $jokes is not an array, in short.
    The only code I hate more than my own is everyone else's.

  3. #3
    SitePoint Wizard silver trophybronze trophy Cups's Avatar
    Join Date
    Oct 2006
    France, deep rural.
    17 Post(s)
    1 Thread(s)
    $jokes is supposed to be an array, either it is empty or it has not been set. I am not familiar with the book you mention.
    add this line right at the beginning of this file to see which it is, empty or not set.
    PHP Code:
    <?php var_dump($jokes); ?>
    You had better then check through the code carefully, because this file clearly does not even connect to the database. Find that code and check it, move that line I gave you to AFTER the connection to the database, and the subsequent call to fetch rows.

  4. #4
    From space with love silver trophy
    SpacePhoenix's Avatar
    Join Date
    May 2007
    Poole, UK
    103 Post(s)
    0 Thread(s)
    In the line of the file (can't remember off hand which file) where the jokes are fetched from the database, add this line above the line where you fetch the result set (the jokes) from the database:

    PHP Code:

    That will initiate the $jokes variable as an empty array, then when your using $jokes with the foreach it will always see an array, even if there are no jokes returned.
    Community Team Advisor
    Forum Guidelines: Posting FAQ Signatures FAQ Self Promotion FAQ
    Help the Mods: What's Fluff? Report Fluff/Spam to a Moderator

Tags for this Thread


Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts