Head First PHP & MySQL

Chapter 7 - Empty Upload Error On Editprofile.php

Thu, 19 Nov 2009 13:54:07 -0500

Hello,
I found an error and needs simple fixing. I download chapter 7 and put it to a test.
I created a Mismatch account, logged in, went to edit profile, filled out everything, uploaded a small photo, clicked submit and everything was fine. Then I went back to edit my profile again, leaving all the information the same except my name, and when I click submit, I get the following error:

Warning: getimagesize() [function.getimagesize]: Filename cannot be empty in /home/rpse/public_html/editprofile.php on line 52

--------------------------Here is the code on that line------------------
LINE 52 STARTS AT list($new_picture_width, $new_picture_height)

CODE

$old_picture = mysqli_real_escape_string($dbc, trim($_POST['old_picture']));
 $new_picture = mysqli_real_escape_string($dbc, trim($_FILES['new_picture']['name']));
 $new_picture_type = $_FILES['new_picture']['type'];
 $new_picture_size = $_FILES['new_picture']['size'];
 list($new_picture_width, $new_picture_height) = getimagesize($_FILES['new_picture']['tmp_name']);
 $error = false;

 // Validate and move the uploaded picture file, if necessary
 if (!empty($new_picture)) {
 if ((($new_picture_type == 'image/gif') || ($new_picture_type == 'image/jpeg') || ($new_picture_type == 'image/pjpeg') ||
 ($new_picture_type == 'image/png')) && ($new_picture_size > 0) && ($new_picture_size <= MM_MAXFILESIZE) &&
 ($new_picture_width <= MM_MAXIMGWIDTH) && ($new_picture_height <= MM_MAXIMGHEIGHT)) {
 if ($_FILES['file']['error'] == 0) {
 // Move the file to the target upload folder
 $target = MM_UPLOADPATH . basename($new_picture);
 if (move_uploaded_file($_FILES['new_picture']['tmp_name'], $target)) {
 // The new picture file move was successful, now make sure any old picture is deleted
 if (!empty($old_picture) && ($old_picture != $new_picture)) {
 @unlink(MM_UPLOADPATH . $old_picture);
 }
 }
 else {
 // The new picture file move failed, so delete the temporary file and set the error flag
 @unlink($_FILES['new_picture']['tmp_name']);
 $error = true;
 echo 'Sorry, there was a problem uploading your picture.';
 }
 }
 }
 else {
 // The new picture file is not valid, so delete the temporary file and set the error flag
 @unlink($_FILES['new_picture']['tmp_name']);
 $error = true;
 echo 'Your picture must be a GIF, JPEG, or PNG image file no greater than ' . (MM_MAXFILESIZE / 1024) .
 ' KB and ' . MM_MAXIMGWIDTH . 'x' . MM_MAXIMGHEIGHT . ' pixels in size.';
 }
 }

Any Suggestions of how to fix this issue?

Chapter 7.5 Code Download

Thu, 19 Nov 2009 03:19:24 -0500

Hi there,

First of all I want to thank the authors for a great book that has helped me alot in learning php and javascript (think that was also written by Michael Morrison).
I love the head first way of teaching/learning

There's just 1 small remark I want to say about the code download of chapter 7.5: eliminating duplicate code.
The initial files in the download don't look like the screenshots in the book, the menu has changed and is now on every page and there is also a footer on every page.
The code downloads initial files don't have these changes.

PS: Yes I realise that editing the files yourself so it matches the screenshots in the book isn't a big deal and you can do it yourself in 10 minutes or less

Kind regards,
Steven Vandemoortele

Chapter 5 Page 251

Wed, 18 Nov 2009 22:47:57 -0500

I am not sure exactly what is happening. I have been working on getting the image to transfer to the appropriate folder and didn't notice that I am not writing to the database. My code to add a score is as follows:

CODE

  "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">



Guitar Wars - Add Your High Score



Guitar Wars - Add Your High Score

require_once('appvars.php');
require_once('connectvars.php');

  if (isset($_POST['submit'])) {
    // Grab the score data from the POST
    $name = $_POST['name'];
    $score = $_POST['score'];
    $screenshot= $_FILES['screenshot']['name'];
	$screenshotsize= $_FILES['screenshot']['size'];

    if (!empty($name) && !empty($score) && !empty($screenshot)) {

      //Move file to GW_Upload path
      $target = GW_UPLOADPATH . $screenshot;


      if (move_uploaded_file($_FILES['screenshot']['tmp_name'], $target)) {
      //echo "$target";
      // Connect to the database
  	  $dbc = mysqli_connect(DB_HOST, DB_USER, DB_PASSWORD, DB_NAME);

      // Write the data to the database
      $query = "INSERT INTO guitarwars VALUES (0, NOW(), '$name', '$score', '$screenshot')";
      mysqli_query($dbc, $query);


      // Confirm success with the user
      echo 'Thanks for adding your new high score!
';
      echo 'Name: ' . $name . '
';
      echo 'Score: ' . $score . '
';
      echo '';
      echo '<< Back to high scores
';

      // Clear the score data to clear the form
                $name = "";
                $score = "";
                $screenshot = "";

                mysqli_close($dbc);

    }
    else {
      echo 'Please enter all of the information to add your high score.
';
    }
    }
  }
?>



  	
    Name:
    

    Score:
    
     Screenshot
    
    
    
  

Here is the connect vars code

CODE

//Define Database connection constants
define('DB_HOST', 'localhost');
define('DB_USER', 'root');
define('DB_PASSWORD', 'root');
define('DB_NAME', 'gwdb');
?>

Strangely even when I place database code directly inline as opposed to calling it with an external script setting the variables it is not writting to the database. Further more the code executes without throwing any errors. It just doesn't write to the database.

Any clues out there?

Chapter 8, Page 490

Tue, 17 Nov 2009 18:49:33 -0500

Hello:

I have a question regarding the 3rd line of coding on page 490 which is:

$score += 1;

This doesn't seem correct. Should this line be:

$score++;

Or should it be something else?

This same coding is listed on page 492 and is in the downloaded coding file (mymismatch.php).

Thank you.

Chapter 4: Sendemail.php Script Not Sticky.

Wed, 11 Nov 2009 11:17:02 -0500

Hello all,
I've been working away at the sendemail.php script from chapter 4 and upon pressing the "submit" button, nothing happens, no error messages, nothing.
Please help me?

Below is my full script (personal info omitted) :

"http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">

Make Me Elvis - Send Email

Private: For Admin's use ONLY

Write and send an email to mailing list members.

if (isset($_POST['submit'])) {
$from = ***********@hotmail.co.uk';
$subject = $_POST ['subject'];
$text = $_POST ['elvismail'];
$output_form = false;

if (empty($subject) && empty($text)) {
//I know both fields are empty
echo 'You forgot the email subject and body text.
';
$output_form = true;
}

if (empty($subject) && (!empty($text))) {
//I know just the text field is empty
echo 'You forgot the email subject.
';
$output_form = true;
}

if ((!empty($subject)) && empty($text)) {
//I know just the subject field is empty
echo 'You forgot the email body text.
';
$output_form = true;
}
}
else {
$output_form = true;
}

if ((!empty($subject)) && (!empty($text))) {
//Both fields are filled, send the email
$dbc = mysqli_connect(***********', *********, *******', ***********')
or die('Error connecting to MySQL server.');

$query = "SELECT * FROM email_list";
$result = mysqli_query($dbc, $query)
or die('Error querying database.');

while ($row = mysqli_fetch_array($result)) {
$to = $row['email'];
$first_name = $row['first_name'];
$last_name = $row['last_name'];
$msg = "Dear $first_name $last_name,\n$text";
mail($to, $subject, $msg, 'From: ' . $from);
echo 'Email sent to: ' . $to . '
';
}

mysqli_close($dbc);
}

if ($output_form) {
?>

}
?>

Page 264 - Loop Through Array In Index Php Question

Tue, 10 Nov 2009 23:10:45 -0500

The following code has me questioning the need for the incremental on $i at the end of the code, $i++;

As $i is assigned a value of 0 and then used in the conditional for the following IF statement IF ($i == 0) { do this .... Else { do this

As far as I understand $i will never loop as the condition is met on the first pass, so we can display a high-score of 0, and the value of $i is reset every time the script is run.

So why increment the counter ?

/ Retrieve the score data from MySQL
$query = "SELECT * FROM guitarwars ORDER by score desc, date asc";
$data = mysqli_query($dbc, $query);

// Loop through the array of score data, formatting it as HTML
echo '';
$i = 0;
while ($row = mysqli_fetch_array($data)) {
// Display the score data
if ($i == 0) {
echo '';
}
echo '';
if (is_file(IMG_PATH . $row['screenshot']) && filesize(IMG_PATH . $row['screenshot']) > 0) {
echo '';
}
else {
echo '';
}
$i++;
}
echo '

Top Score: ' . $row['score'] . '
'; echo '' . $row['score'] . ' '; echo 'Name: ' . $row['name'] . ' '; echo 'Date: ' . $row['date'] . '

Mysql Client (or Terminal) Not Functioning

Tue, 10 Nov 2009 18:30:10 -0500

It's probably staring me in the face, but after devoting the bulk of my day trying to solve this problem from several angles, it's time to put the call out for advice.

First, my system is Mac 2 x 2.8 GHz Quad-Core Intel Xeon, running 10.5.8

After several false starts, I believe I've installed MySQL 5.1.40-community for Mac OS X.
(I'd tried installing a 5.0.87 version a bit earlier, but in working with it in terminal, I kept getting "No such file or directory" replies. So I disabled it using sudo rm /usr/local/mysql and then sudo rm -rf /Library/StartupItems/MySQLCOM/)

Okay. Back to 5.1 and terminal

When I entered the command cd /usr/local/mysql, it replied with:
(name of computer):mysql (name of user)$
to which I entered mysql, as suggested often works on page 64.

Instead of working, it returned -bash: mysql; command not found.

However, when I entered ./bin/mysqlshow -u root
It returned with a short table of databases.

Feeling confident, I typed CREATE DATABASE aliendatabase;
It replied -bash: CREATE: command not found

Since I couldn't find any other suggestions in Head First, I went to Visual QuickStart. I suggested that to use the mysql client, that I enter ./bin/mysql -u root -p
I did that, and it asked for my password. I entered my root password.

It then returned ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES)

I tried entering a slightly different code, ./bin/mysql - root -p

To which it returned with a long text beginning:
./bin/mysql Ver 14.14 Distrib 5.1.40, for apple-darwin9.5.0 (i386) using readline 5.1
Copyright 2000-2008 MySQL AB, 2008 Sun Microsystems, Inc.
This software comes with ABSOLUTELY NO WARRANTY. This is free software,
and you are welcome to modify and redistribute it under the GPL license
Usage: ./bin/mysql [OPTIONS] [database]
-?, --help Display this help and exit.
-I, --help Synonym for -?

I have yet to see "mysql>" that would enable me to start building my database.
According to the system preferences screen, the MySQL Server Instance is running.

(And yes, the system preferences has unexpectedly quit several times today, giving the MySQL preference as likely the origin of its problems.)

The above is a very abbreviated version of my attempts, but you get the gist.

Thanks!

Chapter 2 - Test Drive (page 89)

Sat, 07 Nov 2009 21:24:41 -0500

I've been getting this error on my browser and I'm not too sure of how to fix this.

CODE

Warning: mysqli_connect() [function.mysqli-connect]: (HY000/2005): Unknown MySQL server host 'localhost:/tmp/mysql.sock' (1) in /Users/alavador/Sites/004_HF_PHP&MYSQL/ch02/initial/aliens/report.php on line 24
Error connecting to MySQL server.

i havent changed anything from the code that was instructed in the book but the my own MySQL information.

CODE

<html>

<head>

 <title>Aliens Abducted Me - Report an Abduction</title>

</head>

<body>

 <h2>Aliens Abducted Me - Report an Abduction</h2>

<?php
$name = $_POST['firstname'] . ' ' . $_POST['lastname'];
$when_it_happen = $_POST['whenithappened'];
$how_long = $_POST['howlong'];
$how_many = $_POST['howmany'];
$alien_description = $_POST['aliendescription'];
$what_they_did = $_POST['whattheydid'];
$fang_spotted = $_POST['fangspotted'];
$email = $_POST['email'];
$other = $_POST['other'];

 $dbc = mysqli_connect ('localhost:/tmp/mysql.sock', 'root', '', 'aliendatabase' )
 or die ('Error connecting to MySQL server.');

 $query = "INSERT INTO aliens_abduction (first_name, last_name, " .
 "when_it_happened, how_long, how_many, alien_description, ".
 "what_they_did, fang_spotted, other, email) " .
 "VALUES ('Sally, 'Jones', '3 days ago', '1 day ', 'four', " .
 "'green with six tentacles', 'We just talked and played with a dog', " .
 "'yes', 'I may have seen your dog. Contact me.', " .
 "'sally@gregs-list.net'";

 $result = mysqli_query($dbc, $query)
 or die('Error querying database.');

 mysqli_close($dbc);

echo 'Thanks for submitting to the form. ';
echo 'You were abducted ' . $when_it_happen;
echo ' and were gone for ' . $how_long . ' ';
echo 'Number of aliens: '.$how_many .' ';
echo 'Describe them: ' . $alien_description . ' ';
echo 'The aliens did this: ' . $what_they_did . ' ';
echo 'Was Fang there? ' . $fang_spotted . ' ';
echo 'Other comments: ' . $other . ' ';
echo 'Your email address is ' . $email;
?>

</body>

</html>

i'm wondering if there is something up with my phpmyadmin settings?
i'm pretty new at this and much help would be appreciated thanks

Form Validation Code

Wed, 04 Nov 2009 18:53:34 -0500

On page 295 of book , Would it be more descriptive and correct to write IF ($output_form = true) {
instead of just If ($output_form) {

To display the form as shown below

.... // code above to validate and send email.
echo 'Email sent to: ' . $to . '
';
}
mysqli_close($dbc); // close database link
}
if ($output_form = true) { // code to be executed if condition is true;
?>

Blank Php Page

Tue, 03 Nov 2009 20:04:13 -0500

Hello - I am having the same problem with the code as I did on chapter one... I never solved it but thought I would move on... basically, the php page is returned blank, with no data going to the server. I thought it might be a powweb issue but they say php is working fine... please take a look at my code and let me know what I am doing wrong if you can. Thanks.

test

$dbc = mysqli_connect('abelincolnstory.powwebmysql.com', 'smoramarco', 'password', 'elvis_store')
or die ('Error connecting to MySQL server.');

$first_name = $_POST['firstname'];
$last_name = $_POST['lastname'];
$email = $_POST['email'];

$query = "INSERT INTO email_list (first_name, last_name, email)" .
"VALUES ('$first_name', '$last_name', '$email')";

mysqli_query($dbc, $query)
or die('Error querying database.');

echo 'Customer added.';

mysqli_close($dbc);

?>

Chapter 5 - Index.php Not Displaying Images

Sun, 01 Nov 2009 21:58:48 -0500

Hi everyone! This book is great but these Chapter 5 errors have SERIOUSLY slowed me down and are driving me insane.

So I am using the final versions of the code provided by Head First... and with index.php when I upload the images, it will move images from the tmp folder to the images folder BUT it is not displaying the images.

It will say 'unverified score' or 'verified score' (aka the 'alts') but there is nothing I can do to make the images show up.

I've made the file permissions 777 and I've tried several little things with the code..

Please HELP!

Ch. 6 Authorize.php Script

Fri, 30 Oct 2009 00:38:38 -0400

Hello all,

Winding my way through the book, on or about pg 315 where we are to move the php script that uses headers for HTTP authentication from the beginning of admin.php and stick it in a separate include file called 'authorize.php', and put the relevant hooks via 'require_once()' in both 'admin.php' and 'removescore.php'.

What works:

The HTTP authentication header script in the beginning of admin.php works fine. Just like it should. But when I cut-n-paste that script into a new file called authorize.php, save that file, and put

CODE

<?php
require_once('authorize.php');
?>

at the very beginning of admin.php, exactly where the previous script was 'cut' from... this is what I get instead of a log-in window:

QUOTE

Warning: Cannot modify header information - headers already sent by (output started at E:\xampplite\htdocs\guitarwars\authorize.php:1) in E:\xampplite\htdocs\guitarwars\authorize.php on line 9

Warning: Cannot modify header information - headers already sent by (output started at E:\xampplite\htdocs\guitarwars\authorize.php:1) in E:\xampplite\htdocs\guitarwars\authorize.php on line 10

Guitar Wars
Sorry, you must enter a valid user name and password to access this page.

Lines 9 & 10 are the lines in authorize.php where it sends the headers. Again, nothing has changed from before when it *did* work, except which file its stored in. I've been looking at the final versions of admin.php and authorize.php from the code archive, but as of yet I can't seem to pin point where I went wrong.

Any help or nudges in the right direction would be much appreciated.

TIA,

Monte

I Need Some Support For Chapter 9

Thu, 29 Oct 2009 08:58:37 -0400

This may seem like an incredibly stupid question but I just don't get this.

Where exactly are you supposed to put all the commands on page 514. Is all that code supposed to go in the query variable? And what variable are you supposed to use in mysqli_query?

I tried looking for support in the final php script but it doesn't really help.

Forgive me for asking something that's probably right in my face. Maybe someone can just post the code for that page?

Thanks.

Chapter 1 Not Working

Wed, 28 Oct 2009 19:50:58 -0400

Hello,

I can't seem to get the report.php to work correctly, sending the info to the database and showing a successful report submission. Instead I get a blank php page (except for the html Thanks for submitting) and it doesn't get entered in the database. I have pasted the code below. Please tell me what I did wrong. Thank you!

Steve

Test

Thanks for submitting

$first_name = $_POST['firstname'];
$last_name = $_POST['lastname'];
$when_it_happened = $_POST['whenithappened'];
$how_long = $_POST['howlong'];
$how_many = $_POST['howmany'];
$alien_description = $_POST['aliendescription'];
$what_they_did = $_POST['whattheydid'];
$fang_spotted = $_POST['fangspotted'];
$email = $_POST['email'];
$other = $_POST['other'];

$dbc = mysqli_connect('abelincolnstory.powwebmysql.com', 'smoramarco', '*I omitted password for security*', 'aliendatabase')
or die('Could not connect');

$query = "INSERT INTO aliens_abduction (first_name, last_name, when_it_happened, how_long, " .
"how_many, alien_description, what_they_did, fang_spotted, other, email) " .
"VALUES ('$first_name', '$last_name', '$when_it_happened', '$how_long', '$how_many=', " .
"$alien_description', '$what_they_did', '$fang_spotted', '$other', '$email')";

$result = mysqli_query($dbc, $query)
or die('Error querying database.');

mysqli_close($dbc);

echo 'Thanks for submitting the form.
';
echo 'You were abducted ' . $when_it_happened;
echo 'and were gone for ' . $how_long . '
';
echo 'number of aliens: ' . $how_many . '
';
echo 'Describe them: ' . $alien_description . '
';
echo 'The aliens did this ' . $what_they_did . '
';
echo 'Was Fang there? ' . $fang_spotted . '
';
echo 'Other comments: ' . $other . '
';
echo 'Your email address is ' . $email;

?>

Chapter 7 : Log In Problems

Tue, 27 Oct 2009 03:34:27 -0400

Hi guys,

This is the first post I'm making, and just to get it out of the way I appreciate whatever help you wish to give me at this ungodly hour (3:14a EST at the time) in advance. Thank you.

Okay, now for the problem. I'm currently working on Chapter 7 with cookie powered logins. I got the sign up sheet to work with my current database and was easy enough because it was INPUTTING data on the user. The problem I've been having over the past week is getting that data BACK via login. I'll explain.

I created my login page and I thought everything went well until I clicked the submit button and I got the error of not it being a valid login. I thought I misspelled it so I created a new user using the sign up sheet I had made earlier. User was put in the database, but that still didn't let me in. I played around the code a bit and broke it down to what could have caused the problem:

CODE

   if (!empty($user_username) && !empty($user_password)) {
        // Look up the username and password in the database
        $query = "SELECT user_id, username FROM mismatch_user WHERE username = '$user_username' AND password = SHA('$user_password')";
        $data = mysqli_query($dbc, $query);

        if (mysqli_num_rows($data) == 1) {
          // The log-in is OK so set the user ID and username session vars (and cookies), and redirect to the home page
          $row = mysqli_fetch_array($data);
          $_SESSION['user_id'] = $row['user_id'];
          $_SESSION['username'] = $row['username'];
          setcookie('user_id', $row['user_id'], time() + (60 * 60 * 24 * 30));    // expires in 30 days
          setcookie('username', $row['username'], time() + (60 * 60 * 24 * 30));  // expires in 30 days
          $home_url = 'http://' . $_SERVER['HTTP_HOST'] . dirname($_SERVER['PHP_SELF']) . '/index.php';
          header('Location: ' . $home_url);
        }
        else {
          // The username/password are incorrect so set an error message
          $error_msg = 'Sorry, you must enter a valid username and password to log in.';
        }
      }
     

I turned the mysqli_num_rows to 0, and that basically lets everyone in. Not very secure, but close. To tell the truth, I still have no idea why it's blocking me out when code is saying "The username and password in this table is RIGHT THERE. They match.Let him in" But it doesn't, and I don't get it.

And to add insult to injury, I decided to start from scratch and just take the code from the site (thanks!) and see if it'll make sense when done the right way. I uploaded the table to the database I'm working with, change the connectvar file so it'll connect and signup works... for the most part:

CODE

Warning: mysqli_num_rows() expects parameter 1 to be mysqli_result, boolean given in C:\wamp\www\Mismatch_2\signup.php on line 29

That shows up every time I sign up or fail to log in from Mismatch. I'm new to PHP, and even when I'm looking into the error I have no clue what that means. All I did was copy, paste, and change the database connection.

I'm using IE and Firefox to see if there are any browser issues such as cookies being off. They're enabled for both so I'm officially out of ideas.

Short version: I'm hopeless with log ins and I need help. They won't let me, you know, log in.

EDIT: Okay, so I sort of fixed the PHP error by adding in 'username' and 'password' to quickly sign up users on the sign up page. Still not able to log in.