PHP - Can You Take A Look At This Image Upload Code And Tell Me What's Wrong With It?

i need to upload files to a different folder dependint on option in form, make thumbnails, and store title and src for image and thumb in database table dependant on category. i think i'm pretty close, but there's still something wrong.

Here is my upload form :

Code: [Select]
<form enctype="multipart/form-data" action="upload.php" method="POST">
 Photo: <input type="file" name="photo"><br>
 Category: <select name="cat">
<option value="weddings">Weddings</option>
<option value="music">Music</option>
<option value="portraits">Portraits</option></select>
Title: <input type="text" name="title"><br>
 <input type="submit" value="Upload photo">
 </form>
form processed by upload.php :
Code: [Select]
<?php 
 
 require "db.php";
 
 //Get form info 
 $name=$_POST['name']; 
 $title=$_POST['title']; 
 $category=$_POST['cat']; 
 $pic=($_FILES['photo']['name']); 
 //set target dir source file width height
 $target = $cat."/"; 
 $src = $target . basename( $_FILES['photo']['name']); 
 $destination = $cat."/thumbs";
 $thumbsrc = $destination . basename( $_FILES['photo']['name']); 
 $width = 200;
 $height = 200;
    header("content-type: image/jpeg");
    $src_img = imagecreatefromjpeg("$src");
    $srcsize = getimagesize("$dest");
    $dst_img = imagecreatetruecolor($width, $height);

    imagecopyresampled($dst_img, $src_img, 0, 0, 0, 0, $width, $height, $srcsize[0], $srcsize[1]);
    imagejpeg($dst_img);
    
 //Unstert into db
 mysql_query("INSERT INTO `$category` VALUES ('$name', 'Stitle', '$src, $thumbsrc')") ; 
 
 //move photo 
 if(move_uploaded_file($_FILES['photo']['tmp_name'], $fulltarget)) 
 { 
 //Ok 
 echo "The file ". basename( $_FILES['uploadedfile']['name']). " has been uploaded, and your information has been added to the directory"; 
 } 
 else { 
 
 //not ok 
 echo "Sorry, there was a problem uploading your file."; 
 } 
 ?>

call a script from main page
Code: [Select]
<div class="gallery">
 <?php include "weddings/get.php" ?>
 </div>
 <div class="gallery">
 <?php include "music/get.php" ?>
 </div>

get.php displays links

Code: [Select]
<?php
include "db.php"; 
$cat = weddings;
$q = "SELECT id, title, src, thumbsrc FROM $cat";

$result = $mysqli->query($q) or die(mysqli_error($mysqli));

if ($result) {
    
    echo "<ul id='photos'> \n";
    
    while ($row = $result->fetch_object()) {
   
        $title = $row->title;
        $src = $row->src;
        $thsrc = $row->thumbsrc;
        $id = $row->id;
        
        echo "<a href='$src' class="lightbox" rel="$cat" title="$name - $title"><img src='$thsrc' id='$id'      alt='$name' /></a>":
        }    
        
        echo "</ul>";
    

    
}



?>   
I think i'm going along the right sort of path, but i'm not sure.

How can i edit just one image at on time with a multiple image upload form? I have the images being stored in a folder and the path being stored in MySQL. I also have the files being uploaded with a unique id. My issue is that I want to be able to pass the values of what is already in $name2 $name3 $name4 if I only want to edit $name1. I don't want to have to manually update the 4 images. Here is the PHP:
Code: [Select]
<?php

require_once('storescripts/connect.php');
mysql_select_db($database_phpimage,$phpimage);
$uploadDir = 'upload/';
if(isset($_POST['upload']))
{


foreach ($_FILES as $file)
{

    $fileName = $file['name'];
    $tmpName = $file['tmp_name'];
    $fileSize = $file['size'];
    $fileType = $file['type'];

    if ($fileName != ""){
        $filePath = $uploadDir;
        $fileName = str_replace(" ", "_", $fileName);

        //Split the name into the base name and extension
        $pathInfo = pathinfo($fileName);
        $fileName_base = $pathInfo['fileName'];
        $fileName_ext = $pathInfo['extension'];

        //now we re-assemble the file name, sticking the output of uniqid into it
        //and keep doing this in a loop until we generate a name that 
        //does not already exist (most likely we will get that first try)
        do {
           $fileName = $fileName_base . uniqid() . '.' . $fileName_ext;
        } while (file_exists($filePath.$fileName));

$file_names [] = $fileName;

        $result = move_uploaded_file($tmpName, $filePath.$fileName);
    }


if(!get_magic_quotes_gpc())
{
$fileName = addslashes($fileName);
$filePath = addslashes($filePath);
}
$fileinsert[] = $filePath;
}
}

$mid   = mysql_real_escape_string(trim($_POST['mid']));
$cat   = mysql_real_escape_string(trim($_POST['cat']));
$item  = mysql_real_escape_string(trim($_POST['item']));
$price = mysql_real_escape_string(trim($_POST['price']));
$about = mysql_real_escape_string(trim($_POST['about']));

$fields = array();
$values = array();
$updateVals = array();
for($i = 0; $i < 4; $i++)
{
    $values[$i] = isset($file_names[$i]) ? mysql_real_escape_string($file_names[$i]) : '';

    if($values[$i] != '') {
        $updateVals[] = 'name' . ($i + 1) . " = '{$values[$i]}'"; 
    }
}
$updateNames = '';
if(count($updateVals))
{
    $updateNames = ", " . implode(', ', $updateVals);
}

$update = "INSERT INTO image
               (mid, cid, item, price, about, name1, name2, name3, name4)
           VALUES
               ('$mid', '$cat', '$item', '$price', '$about', '$values[0]', '$values[1]', '$values[2]', '$values[3]')
           ON DUPLICATE KEY UPDATE
                cid = '$cat', item = '$item', price = '$price', about = '$about' $updateNames";
$result = mysql_query($update) or die (mysql_error());

Hello

I am having problems uploading an image through a HTML form. I want the image to be uploaded to the server and the image name to be written to the mysql database.

Below is the code I am using:
Code: [Select]
<?php
if (isset($_POST['add'])){
   
   echo "<br /> add value is true";
      $name = $_POST['name'];   
      $description = $_POST['description'];   
      $price = $_POST['price'];
      $category_id = $_POST['category_name'];
      $image = $_FILES['image']['name'];   
      
      //file path of the image upload
      $filepath = "../images/";
      //mew name for the image upload
      $newimagename = $name;
      //new width for the image
      $newwidth = 100;
      //new height for the image
      $newheight = 100;
      
      include('../includes/image-upload.php');
      
      
      mysql_query("INSERT INTO item (item_name, item_description, item_price, item_image)
      VALUES ('$name','$description','$price','$image')"); ?>

Here is the image-upload.php file code:

Code: [Select]
<?php

//assigns the file to the image
$image =$_FILES["image"]["name"];
$uploadedfile =$_FILES["image"]["tmp_name"];

if ($image) {
   //retrieves the extension type from image upload
   $extension = getextension($image);
   //converts extension to lowercase
   $extension = strtolower($extension);
   
   //create image from uploaded file type
   if($extension=="jpg" || $extension=="jpeg") {
      $uploadedfile = $_FILES['image']['tmp_name'];
      $src = imagecreatefromjpeg($uploadedfile);
   }else if($extension=="png") {
      $uploadedfile = $_FILES['image']['tmp_name'];
      $src = imagecreatefrompng($uploadedfile);
   }else{
      $src = imagecreatefromgif($uploadedfile);
   }
   
   //creates a list of the width and height of the image
   list($width,$height)=getimagesize($uploadedfile);
   
   //adds color to the image
   $tmp = imagecreatetruecolor($newwidth,$newheight);
   
   //create image
   imagecopyresampled($tmp,$src,0,0,0,0,$newwidth,$newheight,$width,$height);
   
   //set file name
   $filename = $filepath.$newimagename.".".$extension;
   $imagename = $newimagename.".".$extension;
   //uploads new file with name to the chosen directory
   imagejpeg($tmp,$filename,100);
   
   //empty variables
   imagedestroy($src);
   imagedestroy($tmp);
   
}


?>
Any help would be appreciated, fairly new to all this!

Thanks!!!

So, I'm learning how to upload pictures into a system from my awesome PHP book. I've looked and looked through the script but I can't figure out whats wrong with it.

Goal:
The script is meant to save a full version of the image in the images folder and a thumbnail in the thumbnail folder.
Bug:
The full image does not appear in any folder, and the thumbnail is created but its put in the images folder.

I've checked the GD library, and everything is supported.

image_effect.php

<?php
//change this path to match your images directory
$dir ='C:/x/xampp/htdocs/images';

//change this path to match your fonts directory and the desired font
putenv('GDFONTPATH=' . 'C:/Windows/Fonts');
$font = 'arial';

// make sure the requested image is valid
if (isset($_GET['id']) && ctype_digit($_GET['id']) && file_exists($dir . '/' .
    $_GET['id'] . '.jpg')) {
    $image = imagecreatefromjpeg($dir . '/' . $_GET['id'] . '.jpg');
} else {
    die('invalid image specified');
}

// apply the filter
$effect = (isset($_GET['e'])) ? $_GET['e'] : -1;
switch ($effect) {
case IMG_FILTER_NEGATE:
    imagefilter($image, IMG_FILTER_NEGATE); 
    break;
case IMG_FILTER_GRAYSCALE:
    imagefilter($image, IMG_FILTER_GRAYSCALE); 
    break;
case IMG_FILTER_EMBOSS:
    imagefilter($image, IMG_FILTER_EMBOSS); 
    break;
case IMG_FILTER_GAUSSIAN_BLUR:
    imagefilter($image, IMG_FILTER_GAUSSIAN_BLUR);
    break;
}

// add the caption if requested
if (isset($_GET['capt'])) {
    imagettftext($image, 12, 0, 20, 20, 0, $font, $_GET['capt']);
}

//add the logo watermark if requested
if (isset($_GET['logo'])) {
    // determine x and y position to center watermark
    list($width, $height) = getimagesize($dir . '/' . $_GET['id'] . '.jpg');
    list($wmk_width, $wmk_height) = getimagesize('images/logo.png');
    $x = ($width - $wmk_width) / 2;
    $y = ($height - $wmk_height) / 2;
    
    $wmk = imagecreatefrompng('images/logo.png');
    imagecopymerge($image, $wmk, $x, $y, 0, 0, $wmk_width, $wmk_height, 20);
    imagedestroy($wmk);
}

// show the image
header('Content-Type: image/jpeg');
imagejpeg($image, '', 100);
?>


check_image.php

<?php
include 'db.inc.php';
//connect to MySQL
$db = mysql_connect(MYSQL_HOST, MYSQL_USER, MYSQL_PASSWORD) or 
    die ('Unable to connect. Check your connection parameters.');
mysql_select_db(MYSQL_DB, $db) or die(mysql_error($db));

//change this path to match your images directory
$dir ='C:/x/xampp/htdocs/images';

//change this path to match your thumbnail directory
$thumbdir = $dir . '/thumbs';

//change this path to match your fonts directory and the desired font
putenv('GDFONTPATH=' . 'C:/Windows/Fonts');
$font = 'arial';

// handle the uploaded image
if ($_POST['submit'] == 'Upload') {

    //make sure the uploaded file transfer was successful
    if ($_FILES['uploadfile']['error'] != UPLOAD_ERR_OK)
    {
        switch ($_FILES['uploadfile']['error']) {
        case UPLOAD_ERR_INI_SIZE:
            die('The uploaded file exceeds the upload_max_filesize directive ' .
                'in php.ini.');
            break;
        case UPLOAD_ERR_FORM_SIZE:
            die('The uploaded file exceeds the MAX_FILE_SIZE directive that ' .
                'was specified in the HTML form.');
            break;
        case UPLOAD_ERR_PARTIAL:
            die('The uploaded file was only partially uploaded.');
            break;
        case UPLOAD_ERR_NO_FILE:
            die('No file was uploaded.');
            break;
        case UPLOAD_ERR_NO_TMP_DIR:
            die('The server is missing a temporary folder.');
            break;
        case UPLOAD_ERR_CANT_WRITE:
            die('The server failed to write the uploaded file to disk.');
            break;
        case UPLOAD_ERR_EXTENSION:
            die('File upload stopped by extension.');
            break;
        }
    }
    
    //get info about the image being uploaded
    $image_caption = $_POST['caption'];
    $image_username = $_POST['username'];
    $image_date = @date('Y-m-d');
    list($width, $height, $type, $attr) =
        getimagesize($_FILES['uploadfile']['tmp_name']);

    // make sure the uploaded file is really a supported image
    $error = 'The file you uploaded was not a supported filetype.';
    switch ($type) {
    case IMAGETYPE_GIF:
        $image = imagecreatefromgif($_FILES['uploadfile']['tmp_name']) or
            die($error);
        break;
    case IMAGETYPE_JPEG:
        $image = imagecreatefromjpeg($_FILES['uploadfile']['tmp_name']) or
            die($error);
        break;
    case IMAGETYPE_PNG:
        $image = imagecreatefrompng($_FILES['uploadfile']['tmp_name']) or
            die($error);
        break;
    default:
        die($error);
    }

    //insert information into image table
    $query = 'INSERT INTO images
        (image_caption, image_username, image_date)
    VALUES
        ("' . $image_caption . '", "' . $image_username . '", "' . $image_date .
        '")';
    
    $result = mysql_query($query, $db) or die (mysql_error($db));
    
    //retrieve the image_id that MySQL generated automatically when we inserted
    //the new record
    $last_id = mysql_insert_id();
    
    // save the image to its final destination
    $image_id = $last_id;
    imagejpeg($image, $dir . '/' . $image_id  . '.jpg');
    imagedestroy($image);

} else {
    // retrieve image information
    $query = 'SELECT
        image_id, image_caption, image_username, image_date
    FROM
        images
    WHERE
        image_id = ' . $_POST['id'];
    $result = mysql_query($query, $db) or die (mysql_error($db));
    extract(mysql_fetch_assoc($result));

    list($width, $height, $type, $attr) = getimagesize($dir . '/' . $image_id .
        '.jpg');
}

if ($_POST['submit'] == 'Save') {
    // make sure the requested image is valid
    if (isset($_POST['id']) && ctype_digit($_POST['id']) &&
        file_exists($dir . '/' . $_POST['id'] . '.jpg')) {
        $image = imagecreatefromjpeg($dir . '/' . $_POST['id'] . '.jpg');
    } else {
        die('invalid image specified');
    }

    // apply the filter    
    $effect = (isset($_POST['effect'])) ? $_POST['effect'] : -1;
    switch ($effect) {
    case IMG_FILTER_NEGATE:
        imagefilter($image, IMG_FILTER_NEGATE); 
        break;
    case IMG_FILTER_GRAYSCALE:
        imagefilter($image, IMG_FILTER_GRAYSCALE); 
        break;
    case IMG_FILTER_EMBOSS:
        imagefilter($image, IMG_FILTER_EMBOSS); 
        break;
    case IMG_FILTER_GAUSSIAN_BLUR:
        imagefilter($image, IMG_FILTER_GAUSSIAN_BLUR);
        break;
    }

    // add the caption if requested
    if (isset($_POST['emb_caption'])) {
        imagettftext($image, 12, 0, 20, 20, 0, $font, $image_caption);
    }

    //add the logo watermark if requested
    if (isset($_POST['emb_logo'])) {
        // determine x and y position to center watermark
        list($wmk_width, $wmk_height) = getimagesize('images/logo.png');
        $x = ($width - $wmk_width) / 2;
        $y = ($height - $wmk_height) / 2;
    
        $wmk = imagecreatefrompng('images/logo.png');
        imagecopymerge($image, $wmk, $x, $y, 0, 0, $wmk_width, $wmk_height, 20);
        imagedestroy($wmk);
    }

    // save the image with the filter applied
    imagejpeg($image, $dir . '/' . $_POST['id'] . '.jpg', 100);

    //set the dimensions for the thumbnail
    $thumb_width = $width * 0.10;
    $thumb_height = $height * 0.10;

    //create the thumbnail
    $thumb = imagecreatetruecolor($thumb_width, $thumb_height);
    imagecopyresampled($thumb, $image, 0, 0, 0, 0, $thumb_width, $thumb_height,
        $width, $height);
    imagejpeg($thumb, $dir . '/' . $_POST['id'] . '.jpg', 100);
    imagedestroy($thumb);
?>
<html>
 <head>
  <title>Here is your pic!</title>
 </head>
 <body>
  <h1>Your image has been saved!</h1>
  <img src="images/<?php echo $_POST['id']; ?>.jpg" />
 </body>
</html>
<?php
} else {
?>
<html>
 <head>
  <title>Here is your pic!</title>
 </head>
 <body>
  <h1>So how does it feel to be famous?</h1>
  <p>Here is the picture you just uploaded to our servers:</p>
<?php 
   if ($_POST['submit'] == 'Upload') {
       $imagename = 'images/' . $image_id  . '.jpg';
   } else {
       $imagename = 'image_effect.php?id=' . $image_id  . '&e=' .
           $_POST['effect'];

       if (isset($_POST['emb_caption'])) {
           $imagename .= '&capt=' . urlencode($image_caption); 
       }

       if (isset($_POST['emb_logo'])) {
           $imagename .= '&logo=1'; 
       }
   }
?>
   <img src="<?php echo $imagename; ?>" style="float:left;">
  <table>
   <tr><td>Image Saved as: </td><td><?php echo $image_id  . '.jpg'; ?></td></tr>
   <tr><td>Height: </td><td><?php echo $height; ?></td></tr>
   <tr><td>Width: </td><td><?php echo $width; ?></td></tr>
   <tr><td>Upload Date: </td><td><?php echo $image_date; ?></td></tr>
  </table>
  <p>You may apply special options to your image below. Note: saving an image
with any of the options applied  <em>cannot be undone</em>.</p>
  <form action="<?php echo $_SERVER['PHP_SELF']; ?>" method="post">
   <div>
    <input type="hidden" name="id" value="<?php echo $image_id;?>"/>
    Filter: <select name="effect">
     <option value="-1">None</option>
<?php
    echo '<option value="' . IMG_FILTER_GRAYSCALE . '"';
    if (isset($_POST['effect']) && $_POST['effect'] == IMG_FILTER_GRAYSCALE) {
        echo ' selected="selected"';
    }
    echo '>Black and White</option>';

    echo '<option value="' . IMG_FILTER_GAUSSIAN_BLUR . '"';
    if (isset($_POST['effect']) && $_POST['effect'] ==
        IMG_FILTER_GAUSSIAN_BLUR) {
        echo ' selected="selected"';
    }
    echo '>Blur</option>';

    echo '<option value="' . IMG_FILTER_EMBOSS . '"';
    if (isset($_POST['effect']) && $_POST['effect'] == IMG_FILTER_EMBOSS) {
        echo ' selected="selected"';
    }
    echo '>Emboss</option>';

    echo '<option value="' . IMG_FILTER_NEGATE . '"';
    if (isset($_POST['effect']) && $_POST['effect'] == IMG_FILTER_NEGATE) {
        echo ' selected="selected"';
    }
    echo '>Negative</option>';
?>
    </select>
    <br/><br/>
<?php
    echo '<input type="checkbox" name="emb_caption"';
    if (isset($_POST['emb_caption'])) {
        echo ' checked="checked"';
    }
    echo '>Embed caption in image?';
    echo '<br/><br/><input type="checkbox" name="emb_logo"';
    if (isset($_POST['emb_logo'])) {
        echo ' checked="checked"';
    }
    echo '>Embed watermarked logo in image?';
?>
    <br/><br/>
    <input type="submit" value="Preview" name="submit" />
    <input type="submit" value="Save" name="submit" />
   </div>
  </form>
 </body>
</html>
<?php
}
?>


Any help appreciated.

hello friends,

while clicking the form all the information goes to database, I have one image upload field,
when cliking the submit button, i would like 'image name' to go in database and file to go in
/upload folder, i have tried this for hours and gave up,

if anyone help me in this, i would be very greatful

I have a working image upload script that uploads, renames the file and adds filename to the database.

is it possible to include some sort of image resize code? if so can anyone point me in the right direction or better still show some example code and explain how it works etc.

below is my working code:

Code: [Select]
<?php
$rand = mt_rand(1,9999999);
$member_id = $_SESSION['SESS_MEMBER_ID'];
$caption = $_POST["caption"];

if(isset($_FILES['uploaded']['name']))
{
$allowed_filetypes = array('.jpg','.gif','.bmp','.png','.jpeg');
$max_filesize = 524288; // Maximum filesize in BYTES (currently 0.5MB) 
    $fileName = basename($_FILES['uploaded']['name']);
$errors = array();
$target = "gallery/";
$fileBaseName = substr($fileName, 0, strripos($fileName, '.'));

   // Get the extension from the filename.
   $ext = substr($fileName, strpos($fileName,'.'), strlen($fileName)-1); 
 
   //$newFileName = md5($fileBaseName) . $ext;
   $newFileName = $target . $rand . "_" . $member_id.$ext;
   
   // Check if filename already exists
   if(file_exists("gallery/" . $newFileName)) 
    {
     $errors[] = "The file you attempted to upload already exists, please try again.";
    }
   // Check if the filetype is allowed.
   if(!in_array($ext,$allowed_filetypes))
    {
         $errors[] = "The file you attempted to upload is not allowed.";
    }
    
// Now check the filesize.
   if(!filesize($_FILES['uploaded']['tmp_name']) > $max_filesize)
    {
         $errors[] = "The file you attempted to upload is too large.";
    }
  
    // Check if we can upload to the specified path.
   if(!is_writable($target))
    {
         $errors[] = "You cannot upload to the specified directory, please CHMOD it to 777.";
    }
 
    //Here we check that no validation errors have occured.
    if(count($errors)==0)
    {

//Try to upload it.
        if(!move_uploaded_file($_FILES['uploaded']['tmp_name'], $newFileName))
        {
            $errors[] = "Sorry, there was a problem uploading your file.";
        }
    }
    //Lets INSERT database information here
    if(count($errors)==0)
    {
$result = mysql_query("INSERT INTO `gallery` (`image`, `memberid`, `caption`) VALUES ('$newFileName', '$member_id', '$caption')")
    or die (mysql_error()); 

}
    //If no errors show confirmation message
    if(count($errors)==0)
    {
         echo "<div class='notification success png_bg'>
<a href='#' class='close'><img src='img/cross_grey_small.png' title='Close this notification' alt='close' /></a>
<div>
Image has been uploaded.<br>\n
</div>
</div>";


//echo "The file {$fileName} has been uploaded";
echo "<br>\n";
echo "<a href='gallery.php'>Go Back</a>\n";

   }
    else
    {
        //show error message
        echo "<div class='notification attention png_bg'>
<a href='#' class='close'><img src='img/cross_grey_small.png' title='Close this notification' alt='close' /></a>
<div>
Sorry your file was not uploaded due to the following errors:<br>\n
</div>
</div>";
//echo "Sorry your file was not uploaded due to the following errors:<br>\n";
        echo "<ul>\n";
        foreach($errors as $error)
        {
            echo "<li>{$error}</li>\n";
        }
        echo "</ul>\n";
echo "<br>\n";
echo "<a href='gallery.php'>Go Back</a>\n";
    }
    
}
else
{
    //Show the form
echo "Use the following form below to add a new image to your gallery;<br /><br />\n";
    echo "<form enctype='multipart/form-data' action='' method='POST'>\n";
    echo "Please choose a file:<br /><input class='text' name='uploaded' type='file' /><br />\n";
echo "Image Caption:<br /><input class='text' name='caption' type='text' value='' /><br /><br />\n";
    echo "<input class='Button' type='submit' value='Upload' />\n";
    echo "</form>\n";

}
?>
Many thanks to phpfreaks again.

Ive made this code:
Code: [Select]
<?php

$button = $_GET['submit'];
$search = $_GET['search'];


$s = $_GET['s'];
if (!$s)
$s = 0;


$e = 10; 


$next = $s + $e;
$prev = $s - $e;




 if (strlen($search)<=2)
  echo "Must be greater then 3 chars";
 else
 {
  echo "<br /><table><tr><td><img src='juzzy.jpg' /></td><td><form action='search.php' method='GET'><input type='text' onclick=value='' size='50' name='search' value='$search'> <input type='submit' name='submit' value='Search'></form></td></tr></table>";
  
  
  mysql_connect("localhost","*********","*******");
  mysql_select_db("************");
   
   
   $search_exploded = explode(" ",$search);
   
   foreach($search_exploded as $search_each)
   {
   
        
    $x++;
    if ($x==1)
     $construct .= "keywords LIKE '%$search_each%'";
    else
     $construct .= " OR keywords LIKE '%$search_each%'";
   
   }
   
 
  $constructx = "SELECT * FROM searchengine WHERE $construct";
  
  $construct = "SELECT * FROM searchengine WHERE $construct LIMIT $s,$e";
  
  $run = mysql_query($constructx);
  
  $foundnum = mysql_num_rows($run);  //here is the thing which is causing the error.

  $run_two = mysql_query("$construct");
  
  if ($foundnum==0)
   echo "No results found for <b>$search</b>";
  else
  {
   echo "<table bgcolor='#0000FF' width='100%' height='1px'><br /></table><table bgcolor='#f0f7f9' width='100%' height='10px'><tr><td><div align='right'>Showing 1-10 of <b>$foundnum</b> results found for <b>$search.</b></div></td></tr></table><p>";
   
   while ($runrows = mysql_fetch_assoc($run_two))
   {
   
   $title = $runrows['title'];
   $desc = $runrows['description'];
   $url = $runrows['url'];
   
   echo "<table width='300px'>
   <h4><a href='http://$url'><b>$title</b></a><br />
   $desc<br>
   <font color='00CC00'>$url</font></table></h4>
   ";
   }
?>

<table width='100%'>
<tr>
<td>
<div align="left">

<?php
if (!$s<=0)
 echo "<a href='search.php?search=$search&s=$prev'>Prev</a>";

$i =1; 
for ($x=0;$x<$foundnum;$x=$x+$e)
{


 echo " <a href='search.php?search=$search&s=$x'>$i</a> ";


$i++;


}

if ($s<$foundnum-$e)
  echo "<a href='search.php?search=$search&s=$next'>Next</a>";

}
}  


?>
</div>
</td>
</tr>
</table>
And when ive uploaded it to the host and tryed to search using it (this is just the main code, not the index code) it comes up with this one error:
Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/seanhall/public_html/Search/search.php on line 54

Good day all,
I have this change password code and it works well when all the parameters are ok, like username correct and email correct. But when I test it to see the result if the wrong username or email is entered the else statement doesnt run, not even an error, just skips the code and shows the other parts of the page, just as if the code did not run.
Here is the code:

<?php
        include("mysql_connect.php");
        $username=$_POST['username'];
        $email=$_POST['email'];
        $newpassword=$_POST['newpassword'];
        $confirm_newpassword=$_POST['confirm_newpassword'];
        $query = "SELECT * FROM users WHERE username='$username' AND email='$email'"; 
$result = mysql_query($query) or die(mysql_error());
  while($row = mysql_fetch_array($result)){
    if ($username == $row["username"] && $email == $row["email"]){
    echo "<center><h1>Thank you " . $row["firstname"] ." ". $row["surname"] .". Your password has been changed.<br/> An email has also been sent to $email with the details of the new password.</h1></center>";
    $sql="UPDATE users SET password = '$newpassword', password_confirm='$confirm_newpassword' WHERE (id = $row[id])";
    $update = mysql_query($sql) or die(mysql_error());
    $to = $row["email"];
$subject = "Your password change at My Site";
$message = "Dear " . $row["firstname"] ." ". $row["surname"] .",\r\rYour Password Change has been completed successfully.\r\rYour New Password is:\r". $row["password"] .".\r\rPlease guard this Password carefully.\r\rRegards,\rAdmin - My Site";
require_once "class.phpmailer.php";
$mail = new PHPMailer();
$mail->IsSendmail();
$mail->SetFrom('admin@mysite.com', 'Admin - My Site');
$mail->AddAddress($to);
$mail->Subject = $subject;
$mail->Body = $message;
$mail->Send();
}
else{
echo"<center><h1>Invalid username and/or email.<br/>Please go back to the <a href=\"password_recovery.php\">Password Change Request</a> page and enter correct details.</h1></center>";
}
}
?>

here is code:
Code: [Select]
<?php
session_start(); // Must start session first thing
/* 
Created By Adam Khoury @ www.flashbuilding.com 
-----------------------June 20, 2008----------------------- 
*/
// Here we run a login check
if (!isset($_SESSION['id'])) { 
   echo 'Please <a href="login.php">log in</a> to access your account';
   exit(); 
}
//Connect to the database through our include 
include_once "connect_to_mysql.php";
// Place Session variable 'id' into local variable
$userid = $_SESSION['id'];
// Query member data from the database and ready it for display
$sql = mysql_query("SELECT * FROM members WHERE userid='$userid' LIMIT 1");
while($row = mysql_fetch_array($sql)){
$name = $row["name"];
$phone = $row["phone"];
$username = $row["username"];
$address = $row["address"];
$city = $row["city"];
$state = $row["state"];
$zip = $row["zip"];
$cell = $row["cell"];
$email = $row["email"];
$accounttype = $row["accounttype"];
$rank = $row["rank"];
$badges = $row["badges"];
}
// Set error message as blank upon arrival to page
$errorMsg = "";
// First we check to see if the form has been submitted 
if (isset($_POST['username'])){
$name = ereg_replace("[^A-Z a-z0-9]", "", $_POST['name']); // filter everything but numbers and letters
$phone = ereg_replace("[^A-Z a-z0-9]", "", $_POST['phone']); // filter everything but spaces, numbers, and letters
$username = ereg_replace("[^A-Z a-z0-9]", "", $_POST['username']); // filter everything but spaces, numbers, and letters
$address = ereg_replace("[^A-Z a-z0-9]", "", $_POST['address']); // filter everything but spaces, numbers, and letters
$city = ereg_replace("[^A-Za-z0-9]", "", $_POST['city']); // filter everything but lowercase letters
$state = ereg_replace("[^A-Za-z0-9]", "", $_POST['state']); // filter everything but lowercase letters
$zip = ereg_replace("[^A-Za-z0-9]", "", $_POST['zip']); // filter everything but lowercase letters
$cell = ereg_replace("[^A-Za-z0-9]", "", $_POST['cell']); // filter everything but lowercase letters
$email = stripslashes($_POST['email']);
$email = strip_tags($email);
$email = mysql_real_escape_string($email);

if((!$email)){

$errorMsg = "You did not submit the following required information!<br /><br />";

    if(!$email){ 
       $errorMsg .= "--- Email Address"; 
    
   }
} else { $sql = mysql_query("INSERT INTO events (name, phone, username, address, city, state, zip, cell, email) 

VALUES('$name','$phone','$username','$address','$city','$state','$zip','$cell','$email") or die (mysql_error());

$to = "$email";
// Change this to your site admin email
$from = "events@final.net46.net";
$subject = "Complete your registration";
//Begin HTML Email Message where you need to change the activation URL inside
$message = '<html>
<body bgcolor="#FFFFFF">
Hi ' . $username . ',
<br /><br />
You must complete this step to activate your account with us.
<br /><br />
Please click here to activate now &gt;&gt;
<a href="http://www.somewebsite.com/activation.php?id=' . $id . '">
ACTIVATE NOW</a>
<br /><br />
Your Login Data is as follows: 
<br /><br />
E-mail Address: ' . $email . ' <br />
Password: ' . $password . ' 
<br /><br /> 
Thanks! 
</body>
</html>';
// end of message
$headers = "From: $from\r\n";
$headers .= "Content-type: text/html\r\n";
$to = "$to";
// Finally send the activation email to the member
mail($to, $subject, $message, $headers);
// Then print a message to the browser for the joiner 
print "<br /><br /><br /><h4>OK $firstname, one last step to verify your email identity:</h4><br />
We just sent an Activation link to: $email<br /><br />
<strong><font color=\"#990000\">Please check your email inbox in a moment</font></strong> to click on the Activation <br />
Link inside the message. After email activation you can log in.";


exit(); // Exit so the form and page does not display, just this success message
} // Close else after database duplicate field value checks
  } // Close else after missing vars check
 //Close if $_POST

 
?>
<?php


// if no id is specified, list the available articles
if(!isset($_GET['eventid']))
{
   $self = $_SERVER['PHP_SELF'];

   $query = "SELECT eventid, event FROM Registration ORDER BY eventid";
   $result = mysql_query($query) or die('Error : ' . mysql_error());
  
   // create the article list
   $description = '<ol>';
   while($row = mysql_fetch_array($result, MYSQL_NUM))
   {
      list($eventid, $event, $date) = $row;
      $description .= "<li><a href=\"$self?eventid=$eventid\">$event</a></li>\r\n";
   }

   $description .= '</ol>';

   $Events = 'Events';
} else {
   // get the article info from database
     $query = "SELECT event, description, startdate, enddate location, subevent1, subevent2, subevent3, subevent4, subevent5, subevent6, subevent7, subevent8, price1, price2, price3, price4, price5, price6, price7, price8 FROM Registration WHERE eventid=".$_GET['eventid'];
   $result = mysql_query($query) or die('Error : ' . mysql_error());
   $row = mysql_fetch_array($result, MYSQL_ASSOC);

  $event = $row['event'];
   $description = $row['description'];
   $startdate = $row['startdate'];
     $enddate = $row['enddate'];

     $location = $row['location'];
 $subevent1 = $row['subevent1'];
$subevent2 = $row['subevent2'];
$subevent3 = $row['subevent3'];
$subevent4 = $row['subevent4'];
$subevent5 = $row['subevent5'];
$subevent6 = $row['subevent6'];
$subevent7 = $row['subevent7'];
$subevent8 = $row['subevent8'];

$price1 = $row['price1'];
$price2 = $row['price2'];
$price3 = $row['price3'];
$price4 = $row['price4'];
$price5 = $row['price5'];
$price6 = $row['price6'];
$price7 = $row['price7'];
$price8 = $row['price8'];
}
?>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8" />
<title>Register</title>
<style type="text/css">
#apDiv1 {
position:absolute;
left:33px;
top:320px;
width:252px;
height:48px;
z-index:1;
}
#apDiv2 {
position:absolute;
left:33px;
top:361px;
width:254px;
height:46px;
z-index:2;
}
#apDiv3 {
position:absolute;
left:33px;
top:525px;
width:256px;
height:43px;
z-index:3;
}
#apDiv4 {
position:absolute;
left:33px;
top:402px;
width:250px;
height:48px;
z-index:4;
}
#apDiv5 {
position:absolute;
left:106px;
top:616px;
width:263px;
height:255px;
z-index:5;
}
#apDiv6 {
position:absolute;
left:323px;
top:200px;
width:898px;
height:530px;
z-index:5;
}
#apDiv7 {
position:absolute;
left:33px;
top:443px;
width:266px;
height:42px;
z-index:6;
}
#apDiv8 {
position:absolute;
left:111px;
top:500px;
width:125px;
height:37px;
z-index:7;
}
#apDiv8 strong {
font-size: 24px;
}
#apDiv9 {
position:absolute;
left:33px;
top:408px;
width:267px;
height:49px;
z-index:8;
}
#apDiv10 {
position:absolute;
left:33px;
top:449px;
width:242px;
height:23px;
z-index:9;
}
#apDiv8 a {
color: #000;
}
#apDiv11 {
position:absolute;
left:101px;
top:490px;
width:168px;
height:42px;
z-index:10;
font-size: 24px;
font-weight: bold;
}
#apDiv11 a {
color: #000;
}
#apDiv12 {
position:absolute;
left:33px;
top:210px;
width:205px;
height:107px;
z-index:11;
}
#apDiv12 {
text-align: center;
}
#apDiv13 {
position:absolute;
left:33px;
top:320px;
width:248px;
height:47px;
z-index:12;
}
#apDiv {
position:absolute;
left:33px;
top:484px;
width:225px;
height:35px;
z-index:11;
}
#apDiv14 {
position:absolute;
left:33px;
top:566px;
width:298px;
height:51px;
z-index:12;
}
#apDiv15 { position:absolute;
left:101px;
top:611px;
width:168px;
height:42px;
z-index:10;
font-size: 24px;
font-weight: bold;
}
#apDiv5 a {
font-size: 24px;
color: #000;
font-weight: bold;
}
#apDiv23 table tr td1 {
font-size: 14px;
}
</style>
<script type="text/javascript">
function MM_swapImgRestore() { //v3.0
  var i,x,a=document.MM_sr; for(i=0;a&&i<a.length&&(x=a[i])&&x.oSrc;i++) x.src=x.oSrc;
}
function MM_preloadImages() { //v3.0
  var d=document; if(d.images){ if(!d.MM_p) d.MM_p=new Array();
    var i,j=d.MM_p.length,a=MM_preloadImages.arguments; for(i=0; i<a.length; i++)
    if (a[i].indexOf("#")!=0){ d.MM_p[j]=new Image; d.MM_p[j++].src=a[i];}}
}
function MM_findObj(n, d) { //v4.01
  var p,i,x;  if(!d) d=document; if((p=n.indexOf("?"))>0&&parent.frames.length) {
    d=parent.frames[n.substring(p+1)].document; n=n.substring(0,p);}
  if(!(x=d[n])&&d.all) x=d.all[n]; for (i=0;!x&&i<d.forms.length;i++) x=d.forms[i][n];
  for(i=0;!x&&d.layers&&i<d.layers.length;i++) x=MM_findObj(n,d.layers[i].document);
  if(!x && d.getElementById) x=d.getElementById(n); return x;
}
function MM_swapImage() { //v3.0
  var i,j=0,x,a=MM_swapImage.arguments; document.MM_sr=new Array; for(i=0;i<(a.length-2);i+=3)
   if ((x=MM_findObj(a[i]))!=null){document.MM_sr[j++]=x; if(!x.oSrc) x.oSrc=x.src; x.src=a[i+2];}
}
</script>

<style type="text/css">
#apDiv6 #form1 table tr th {
text-align: center;
}
#apDiv6 table tr td table tr td {
text-align: center;
}
#apDiv16 {
position:absolute;
left:330px;
top:45px;
width:208px;
height:100px;
z-index:13;
}
#apDiv6 table tr td #apDiv16 table tr th {
font-size: 36px;
}
#apDiv17 {
position:absolute;
left:183px;
top:342px;
width:427px;
height:65px;
z-index:13;
}
#apDiv6 table tr td #Accordion1 .AccordionPanel.AccordionPanelOpen .AccordionPanelContent #apDiv17 table tr th {
color: #999;
}
</style>

<style type="text/css">

#apDiv19 {
position:absolute;
left:33px;
top:320px;
width:271px;
height:33px;
z-index:13;
}
#apDiv20 {
position:absolute;
left:578px;
top:368px;
width:157px;
height:87px;
z-index:14;
}
#apDiv21 {
position:absolute;
left:8px;
top:705px;
width:270px;
height:683px;
z-index:15;
}
#apDiv22 {
position:absolute;
left:476px;
top:313px;
width:596px;
height:124px;
z-index:16;
}
#apDiv6 table tr td table tr th {
text-align: left;
}
#apDiv23 {
position:absolute;
left:626px;
top:250px;
width:247px;
height:85px;
z-index:16;
text-align: center;
font-size: 36px;
}
#apDiv23 table tr td {
text-align: center;
font-size: 24px;
}
#apDiv24 {
position:absolute;
left:626px;
top:295px;
width:247px;
height:63px;
z-index:17;
text-align: center;
font-size: 20px;
}
.klgjsa {
font-size: 18px;
}
#apDiv24 {
font-size: 16px;
}
#apDiv24 {
font-size: 18px;
}
#apDiv24 {
color: #C90;
}
</style>


</head>
<body onload="MM_preloadImages('button/pictures2.png','button/projects1.png','button/news2.png','button/eventmanager2.png','button/membermanager2.png','button/newsmanager2.png','button/myprofile2.png')">
<div id="apDiv6">
<table width="600" border="0" align="center" cellpadding="10" cellspacing="1" bgcolor="#336699">
  <tr>
  <td bgcolor="#FFFFFF"><h1 align="center"><?php echo $Events; ?></h1>
  <p>&nbsp;</p>
  <p>&nbsp;</p>
  <p><?php echo $description; ?></p>
   
  <p>&nbsp;</p>
   
  <p>&nbsp;</p>
  <?php
$sql = mysql_query("SELECT * FROM members WHERE userid='$userid' LIMIT 1");
while($row = mysql_fetch_array($sql)){
$name = $row["name"];
$phone = $row["phone"];
$address = $row["address"];
$city = $row["city"];
$state = $row["state"];
$zip = $row["zip"];
$cell = $row["cell"];
$email = $row["email"];
}
$sql = mysql_query("SELECT * FROM Registration WHERE eventid=".$_GET['eventid']." LIMIT 1");
while($row = mysql_fetch_array($sql)){
$event= $row["event"];
$subevent1 = $row['subevent1'];
$subevent2 = $row['subevent2'];
$subevent3 = $row['subevent3'];
$subevent4 = $row['subevent4'];
$subevent5 = $row['subevent5'];
$subevent6 = $row['subevent6'];
$subevent7 = $row['subevent7'];
$subevent8 = $row['subevent8'];

$price1 = $row['price1'];
$price2 = $row['price2'];
$price3 = $row['price3'];
$price4 = $row['price4'];
$price5 = $row['price5'];
$price6 = $row['price6'];
$price7 = $row['price7'];
$price8 = $row['price8'];
}
?>
  <?php
// when displaying an article show a link
// to see the article list
if(isset($_GET['eventid']))
{
?>
  <div id="jQueryUIAccordion">
<h3>&nbsp;</h3>
<div>
<p>

   
    <table width="575" border="0" cellspacing="2" cellpadding="2">
      <tr>
        <th width="563" bgcolor="#999999" scope="col">Location</th>
        </tr>
      </table>
    <table width="574" height="16" border="0" cellpadding="2" cellspacing="2">
      <tr>
        <th height="12" scope="col"><?php echo $location; ?></th>
        </tr>
      </table>
    <table width="573" border="0" cellspacing="2" cellpadding="2">
      <tr>
        <th width="561" bgcolor="#999999" scope="col">Description</th>
        </tr>
      </table>
    <table width="576" border="0" cellspacing="2" cellpadding="2">
      <tr>
        <th width="564" height="11" scope="col"><?php echo $title1; ?><br /><?php echo $price1; ?></th>
        <th width="564" scope="col"><?php echo $subevent1; ?></th>
       

        </tr>
      <tr>
        <th height="11" scope="col"><?php echo $title2; ?><br /><?php echo $price2; ?></th>
        <th scope="col"><?php echo $subevent2; ?> </th>
      </tr>
      <tr>
        <th height="11" scope="col"><?php echo $title3; ?><br /><?php echo $price3; ?></th>
        <th scope="col"><?php echo $subevent3; ?></th>
      </tr>
      <tr>
        <th height="11" scope="col"><?php echo $title4; ?><br /><?php echo $price4; ?></th>
        <th scope="col"><?php echo $subevent4; ?></th>
      </tr>
      <tr>
        <th height="11" scope="col"><?php echo $title5; ?><br /><?php echo $price5; ?></th>
        <th scope="col"><?php echo $subevent5; ?></th>
      </tr>
      <tr>
        <th height="11" scope="col"><?php echo $title6; ?><br /><?php echo $price6; ?></th>
        <th scope="col"><?php echo $subevent6; ?></th>
      </tr>
      <tr>
        <th height="11" scope="col"><?php echo $title7; ?><br /><?php echo $price7; ?></th>
        <th scope="col"><?php echo $subevent7; ?></th>
      </tr>
      <tr>
        <th height="11" scope="col"><?php echo $title8; ?><br /><?php echo $price8; ?></th>
        <th scope="col"><?php echo $subevent8; ?></th>
      </tr>
      </table>
    <hr />
    <table width="200" border="0" cellspacing="2" cellpadding="2">
      <tr>
        <th scope="col">Price:</th>
        </tr>
      </table>
    <table width="200" border="0" cellspacing="2" cellpadding="2">
      <tr>
        <th scope="col">$<?php echo  $price; ?></th>
        </tr>
      </table>
</p>
<?php
if (isset($_GET['eventid'])) {
include('connect1.php');
$sql = mysql_query("SELECT * FROM Registration WHERE eventid='$eventid' LIMIT 1");
while($row = mysql_fetch_array($sql)){
$eventid = $row["eventid"];
$event = $row["event"];
$date = $row["date"];
$description = $row["description"];
$location = $row["location"];
}
$result = mysqli_query($dbcon, $query) or die('error getting data');

echo "<table>";
while ($row = mysqli_fetch_array($result, MYSQLI_ASSOC)) {
echo "<tr><td>";
echo "<a href=\"registration.php?eventid=".$_GET['eventid']."\"><ul>Register Now!</ul></a>";
echo "</td></tr>";
}
echo "</table>";

}
?>

   
   
   
   
   

 
 
   
   
  <div id="apDiv18"></div>
  <p align="center"><a href="<?php echo $_SERVER['PHP_SELF']; ?>">Back to Events</a></p>
   
   
   
  <?php
}
?></td></tr>
</table>


</div><div id="apDiv2"><a href="register.php" onmouseout="MM_swapImgRestore()" onmouseover="MM_swapImage('Image3','','button/register2.png',1)"><img src="button/register1.png" name="Image3" width="235" height="50" border="0" id="Image3" /></a></div>
<div id="apDiv4"><a href="projects.php" onmouseout="MM_swapImgRestore()" onmouseover="MM_swapImage('Image4','','button/projects2.png',1)"><img src="button/projects1.png" name="Image4" width="235" height="50" border="0" id="Image4" /></a></div>

<div id="apDiv11"><?php if ($accounttype == "Scout") {
echo '<a href="../logout.php">Logout</a>';} ?></div>
<div id="apDiv12"><?php echo "$accounttype"; ?>
  <p><?php echo "$name"; ?></p>
  <p>Troop 78</p>
</div>

<div id="apDiv5"><?php if ($accounttype == "Admin") {
echo "<a href=\"../logout.php\">Logout</a>";
}
?></div>


<div id="apDiv7"><a href="news.php" onmouseout="MM_swapImgRestore()" onmouseover="MM_swapImage('Image6','','button/news2.png',1)"><img src="button/news1.png" name="Image6" width="235" height="50" border="0" id="Image6" /></a></div>
<div id="apDiv"> <?php if ($accounttype == "Admin") {
echo "<a href=\"../search1.php\" onmouseout=\"MM_swapImgRestore()\" onmouseover=\"MM_swapImage('Image7','','../button/membermanager2.png',1)\"><img src=\"../button/membermanager1.png\" name=\"Image7\" width=\"235\" height=\"50\" border=\"0\" id=\"Image7\" /></a>";
} 
?></div>
<div id="apDiv3"><?php if ($accounttype == "Admin") {
echo "<a href=\"../eventmanager.php\" onmouseout=\"MM_swapImgRestore()\" onmouseover=\"MM_swapImage('Image8','','../button/eventmanager2.png',1)\"><img src=\"../button/eventmanager1.png\"  name=\"Image8\" width=\"235\" height=\"50\" border=\"0\" id=\"Image8\" /></a>";
}
?>
</div>
<div id="apDiv14"><?php if ($accounttype == "Admin") {
echo "<a href=\"../newsmanager.php\" onmouseout=\"MM_swapImgRestore()\" onmouseover=\"MM_swapImage('Image9','','../button/newsmanager2.png',1)\"><img src=\"../button/newsmanager1.png\"  name=\"Image9\" width=\"235\" height=\"50\" border=\"0\" id=\"Image9\" /></a>";
}
?>
</div>

<div id="apDiv19"><a href="myprofile.php" onmouseout="MM_swapImgRestore()" onmouseover="MM_swapImage('Image5','','button/myprofile2.png',1)"><img src="button/myprofile1.png" name="Image5" width="235" height="50" border="0" id="Image5" /></a></div>
<div id="apDiv21"><img src="button/red.png" width="282" height="687" /></div>
<div id="apDiv23"><?php echo $event; ?> <br />
</div>
<div id="apDiv24"><?php echo $startdate;?> <span class="klgjsa">-</span> <?php echo $enddate; ?></div>
<img name="boyscout" src="buttons/boyscout.jpg" width="1180" height="700" border="0" id="boyscout" alt="" />
</body>
</html>
here is error:
Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /home/a6254834/public_html/register.php on line 469

help?

Can anyone see what is wrong with this code?
I get the following parse error: syntax error, unexpected $end

Code: [Select]
if(isSet($_GET['answer'])) {
        $answ = $_GET['answer'];
        $nextanswer=$answ+1;}
else{}
$counter2 = 1;
while ($counter2 <= $answ):
        echo $Answer[$counter2]."<br>";
        $counter2++;
        endwhile;
if($nextansw>0){
   if(isset($Answer[$nextanswer])){
        echo "<a href=\"/Code-sandbox.php?sid=".$name."&answer=".$nextanswer."\">next</a>";}
    else{echo "End of questions<br>";}
else{}

<?php
global $con;
$name = $_GET['name'];
$email = $_GET['email'];
if((!empty($name)) && (!empty($email))){
    $check = $con->prepare('SELECT email FROM subs WHERE email = ?');
    $check->execute([$email]);
    $row = $check->fetch();
    if($email == $row['email']){
        echo '<span>'.$email.' already in database, try another email!.</span>';
    }else{
        $subscribe = $con->prepare('INSERT INTO subs (name, email) VALUES (?, ?)');
        $subscribe->execute([$name, $email]);
        if($subscribe){
            echo '<span>Hi '.$name.'</b>,subscription is now active.</span>';
        }else{
            echo '<span>Try again</span>';
        }
    }
}else{
    echo '<span>please enter something</span>';
}
?>

the problem found at if($subscribe){

//the echo not showing the span element when data is inserted 

}

 

any help please?

Edited November 14, 2019 by cyberRobot
added code indents

Ok, so basically what I want is the code to check the DB to see if a passworded username is already taken, then display an error if someone tries to post with that same name, but gives a wrong password for that name.  What the code below does, is just that....except, even when you enter the correct password, it displays the error that the name has been taken...how can I fix this so when you enter the right password, it allows you to post?

<script src="http://code.jquery.com/jquery-latest.js" type="text/javascript" charset="utf-8"></script>
<script language="javascript" type="text/javascript">
//<![CDATA[
$(document).ready(function(){
$("form#reply").submit(function() {
var success = 0;
var username     = $('#user').attr('value');
$.ajax({
type: "GET",
url: "checkusername.php",
data: "username="+ username,
success: function(r){
success = r;
}, async:false
});
if(success == 1) {
alert("Username already taken.");
return false;
}else return true;
});
});
//]]>
</script>


The checkusername.php code is:

<?php
require "database.php";
#check user on users table
$user = fetch("SELECT COUNT(pid) FROM posts WHERE user = '".$_GET["username"]."'");
if(!$user || !isset($user)) echo '0';
if($user[0] > 0) echo '1'; else echo '0';
exit();
?>

Hiya peeps!

I have built this code, can anyone see anything wrong with this because its not working at all all it does is refer back to its self;


<?php session_start();

include 'system/template/template.php';
include 'system/mysql/mysql.php';
include 'system/properties/property.php';

$mysql = new mysql();
$mysql->connect();

$property = new property();

if($property->landlord_loggedin()) {
header('Location: login.php');
}


$_SESSION['N_P_ID'] = 1;
if(isset($_SESSION['N_P_ID']) && !empty($_SESSION['N_P_ID'])) {
if(isset($_POST['videotitle']) && !empty($_POST['videotitle']) && isset($_FILES['videofile']) && !empty($_FILES['videofile'])) {
$upload = $bad . '<form id="Upload" action="upload_video.php" enctype="multipart/form-data" method="post">
<h3>Upload a video of your property</h3>
<label>Video Title</label>
<input type="text" name="videotitle"><br />
<input type="file" name="videofile">

<label>Submit</label>
<input type="submit" name="submit" value="Upload"><br />
<a href="landlord_account.php">Skip</a>
</form>';

$extensions = array('mpg', 'avi', 'mpeg');
define ("MAX_SIZE","10240"); 

function getExtension($str) {
$i = strrpos($str,".");
if (!$i) {
return "";
}

$l = strlen($str) - $i;
$ext = substr($str,$i+1,$l);

return $ext;
}

if(isset($_FILES['imageone'])) {

if(!isset($_POST['videotitle'])) {
$bad = '<p class="bad">Please enter a video title.</p>';
$form = $upload;
}

$filename = stripslashes($_FILES['videofile']['name']);

$extension = strtolower(getExtension($filename));

if(!in_array($extension, $extensions)) {

$bad = '<p class="bad">Video is incorrect format, please make sure your video format is either mpg/mpeg or avi.</p>';
$form = $upload;

} else {

$size = filesize($_FILES['videofile']['tmp_name']);

if($size > MAX_SIZE*1024) {

$bad = '<p class="bad">Video too large.</p>';
$form = $upload;

}

$time = time();
$image_name = $time . '.' . $extension;
$newname = "uploads/properties/landlord_files/videos/" . $image_name;

if(move_uploaded_file($_FILES['videofile']['tmp_name'], $newname)) {
if($property->add_video($time, 'flv', $_POST['videotitle'])) {
$srcFile = 'uploads/properties/landlord_files/videos/' . $image_name;
$destFile = 'uploads/properties/landlord_files/videos/' . $time . '.flv';
$ffmpegPath = "/usr/bin/ffmpeg";
$flvtool2Path = "/usr/bin/flvtool2";

$ffmpegObj = new ffmpeg_movie($srcFile);
$srcWidth = makeMultipleTwo($ffmpegObj->getFrameWidth());
$srcHeight = makeMultipleTwo($ffmpegObj->getFrameHeight());
$srcFPS = $ffmpegObj->getFrameRate();
$srcAB = intval($ffmpegObj->getAudioBitRate()/1000);
$srcAR = $ffmpegObj->getAudioSampleRate();

$img = $image_name;
$ff_frame = $ffmpegObj->getFrame(1);

if($ff_frame) {
$gd_image = $ff_frame->toGDImage();
if($gd_image) {
imagepng($gd_image, $img);
imagedestroy($gd_image);
$property->add_image($img, 'png', 'frame_shot');
}
} 

exec($ffmpegPath . " -i " . $srcFile . " -ar " . $srcAR . " -ab " . $srcAB . " -f flv -s " . $srcWidth . "x" . $srcHeight . " " . $destFile . " | " . $flvtool2Path . " -U stdin " . $destFile);
@unlink($newname);
function makeMultipleTwo ($value) {
$sType = gettype($value/2);
if($sType == "integer") {
return $value;
} else {
return ($value-1);
}
}
$ref = 1;
} else {
@unlink($newname);
$bad = '<p class="bad">Video upload failed.</p>';
$form = $upload;
}
} else {
$bad = '<p class="bad">Video upload failed.</p>';
$form = $upload;

}
}
}

if($ref == 1) {
header('Location: landlord_account.php?page=3');
}

} else {
$form = '<form id="Upload" action="upload_video.php" enctype="multipart/form-data" method="post">
<h3>Upload a video of your property</h3>
<label>Video Title</label>
<input type="text" name="videotitle"><br />
<input type="file" name="videofile">

<label>Submit</label>
<input type="submit" name="submit" value="Upload"><br />
<a href="landlord_account.php">Skip</a>
</form>';
}

$template = new template();
$array = array('TITLE' => 'Upload A Video', 'CONTENT' => $form);

$template->newTemplate($array, 'add_property');
} else {
header('Location: landlord_account.php');
}
?>


Many thanks,

James.

I had this code working, then I became curious and tried something else and it failed. I then I went to use the original code that worked but forgot it.

Whats wrong with this code?
<?php
        $A=(echo '2);
        if ($_POST['number'] == '1') {include $A;}
?>