PHP - How To Retrieve This Variable?

Have page#1 with thumbs view_thumbs.php , when a thumb is clicked thumb link goes to page#2 which is the video_play.php page(which must play embed codes from xml sheet)
Using GET method to identify incoming link from page#1.
QUESTION is how can i retrieve file(embed code)  from xml to play on page#2 with incoming GET info from page#1?
(embeds not you only from you tube, so no youtube solutions only, just retrieve file)

I somehow have to fill play video div on page#2/video_play.php  according to GET data from page#1/view_thumbs.php

I have a form that ask user to enter other details but the primary key as this is automated and when they click on Submit button it takes the user to different form. now on this form I would like to retreive the primary that has just been added to the table. How can I do this?

Hello, I have a booking system which has time and date fields and if someone tries to book, for example, on 01/01/2011 at 09:00, when this slot is already taken, an error would be produced - which is fine. However I'm not sure in telling them what hours are available.

There are 9 available times: 09,10,11,12,13,14,15,16,17:00.

I will need to perform an sql query to gather all the times on the inputted date, I'm guessing a for loop would be the most efficient way?

The only way I could think of is using multiple IF queries, for example:

Code: [Select]
<?php
$sql = "SELECT `Hour` FROM `jobs` WHERE `Hour` = '09:00:00' AND Day ='$Day' AND Month ='$Month' AND Year ='$Year'";
$result = mysql_query($sql);
if(mysql_num_rows($result) > 0){
$09Available = 'n'; // Time not available
}else{
$09Available = 'y';
}

$sql = "SELECT `Hour` FROM `jobs` WHERE `Hour` = '10:00:00' AND Day ='$Day' AND Month ='$Month' AND Year ='$Year'";
$result = mysql_query($sql);
if(mysql_num_rows($result) > 0){
$10Available = 'n'; // Time not available
}else{
$10Available = 'y';
}

$sql = "SELECT `Hour` FROM `jobs` WHERE `Hour` = '11:00:00' AND Day ='$Day' AND Month ='$Month' AND Year ='$Year'";
$result = mysql_query($sql);
if(mysql_num_rows($result) > 0){
$11Available = 'n'; // Time not available
}else{
$11Available = 'y';
}

?>

etc. etc..

How would I go about creating a more efficient method?

Thank you, Jack.

I have a form where you can pick all the days in the week. When the form is posted my code finds the date of the day you picked that most recently went by. Then the code takes that date, and echos the date of every day of the week that you picked that comes after that date for a year.
But for some reason he thinks we're in 2009, even though i know the date puts out that we're in 2010.

Here's the code:

<?php
//function
if(isset($_POST['submit'])) {
function nextWeeksDay($date_begin,$nbrweek)
{
$nextweek=array();
for($i = 1; $i <= $nbrweek; $i++)  { // 52 week in one year of course
$nextweek[$i]=date('d-m-y', strtotime('+'.$i.' week',$date_begin));
}
return $nextweek;
}
//Get what user posted as day, and find the date of the past day gone.
$roday = $_POST['day'];
echo $roday;
echo date('d-m-y',strtotime('last ' . $roday));
$sistdag = date('d-m-y',strtotime('last ' . $roday));
/// end function
/// example of a select date
// var
$date_begin = strtotime($sistdag); //D Day Month Year  - like function format.
$nbrweek=52;
// call function
$result=nextWeeksDay($date_begin,$nbrweek);
// Preview
for($i = 1; $i <= $nbrweek; $i++)  {
echo '<br> - '.$result[$i];
}
}
?>

All help appreciated!

What php method is good for getting file from a .xml sheet ?

Hi!
I am trying to implement the comment feature.
After a user selects a recipe from the search results (http://razor.ischool.utexas.edu/~nem/project/index.php scroll down to choose a recipe from the search results), the recipe page is displayed. The user may leave a comment at the bottom of the recipe page if she wishes to. The comment would be recorded in a mysql table and be displayed along with other comments for this particular recipe.

The problem is that when the user has entered the comment and name and hits "Add my comment", this error appears: Notice: Undefined index: id in /.../recipeText_w.php on line 57 error retrieving proteins data

While I understand it happens because the recipe Id ($_GET['id']) becomes unavailable after the comment and name are submitted, I am not sure how to make the recipe ID available again so that the same recipe page is displayed.

The script is attached. I will appreciate your advice.

Hello,

I am trying to figure out how to grab the latest aim status update from "http://lifestream.aol.com/stream/iragedxt"

But I can only see the Current Status if I am logged into my aim account on the website so is there a way I can log into my aim account on lifestream.aol.com and then I believe its to use curl to grab the text from the other website?

if so could someone please help me with this?

Thanks,
John

Submit2.php

Code: [Select]
<?php

$db = mysql_connect("localhost", "root") or die("Could not connect."); //username and password

if(!$db) 

die("no db");

if(!mysql_select_db("simple",$db))
if(!mysql_select_db("regis",$db))//database name

  die("No database selected.");
$message=$_POST['message'];
if(isset($_POST['submit'])) //if submit button push has been detected

{

   $message=$_POST['message'];

   if(strlen($message)<1)

   {

      print "You did not input a message";

   }

   else

   {

      $message=strip_tags($message);

      $IP=$_SERVER["REMOTE_ADDR"]; //grabs poster's IP

      $checkforbanned="SELECT IP from admin where IP='$IP'";

      $checkforbanned2=mysql_query($checkforbanned) or die("Could not check for banned IPS");

      if(mysql_num_rows($checkforbanned2)>0) //IP is in the banned list

      {

         print "You IP is banned from posting.";

      }

     else
      
       if(strlen($message)>=1)
       {

         $message=strip_tags($message);
         echo("<SCRIPT LANGUAGE='JavaScript'>window.alert('$message')</SCRIPT>");
         die("<meta http-equiv=\"refresh\" content=\"0; url=registration.php\">");
       }
        $message=$_POST['message'];
         $message=strip_tags($message);
     /*   if($_POST['username'] && $_POST['pass'])
       {

         $name = mysql_query("SELECT * FROM Persons");
         $thedate = date("U"); //grab date and time of the post

         $insertmessage="INSERT into mesej (name,IP,postime,message) values('$name','$IP','$thedate','$message')";

         mysql_query($insertmessage) or die("Could not insert message");

        }     */

   }
}

 if(!isset($message))
 {
  print "<form action='' method='post' name='form'>";

  print "Your message:<br>";

  print "<textarea name='message' cols='40' rows='2'></textarea><br>";

  print "<a onClick=\"addSmiley(':)')\"><img src='smile.gif'></a> ";

  print "<a onClick=\"addSmiley(':(')\"><img src='blush.gif'></a> ";

  print "<a onClick=\"addSmiley(';)')\"><img src='images/wink.gif'></a> ";

  print "<input type='submit' name='submit' value='Set Name'></form>";

  print "<script language=\"Java Script\" type=\"text/javascript\">\n";

  print "function addSmiley(a)\n";

  print "{\n";

  print "document.form.message.value += a;";

  print "document.form.message.focus();\n";

  print "}\n";

  print "</script>\n";

  print "<br><br>";

 }



?>


Registration.php
Code: [Select]
<?php

$db = mysql_connect("localhost", "root") or die("Could not connect."); //username and password

if(!$db){die("no db");}
if(!mysql_select_db("regis",$db)){die("No database selected.");}
$message=$_POST['message'];
echo("<SCRIPT LANGUAGE='JavaScript'>window.alert('$message')</SCRIPT>");
if (isset($_POST['sub']))
         {
          $message=strip_tags($message);



        if (!$_POST['username'] | !$_POST['pass'] | !$_POST['pass2'] )
        {
           print  "You did not complete all of the required fields";
        }

        // checks if the username is in use

        if (!get_magic_quotes_gpc())
       {
        $_POST['username'] = addslashes($_POST['username']);
       }

        $usercheck = $_POST['username'];

        $check = mysql_query("SELECT username FROM registration WHERE username = '$usercheck'")

         or die(mysql_error());

        $check2 = mysql_num_rows($check);

        
       //if the name exists it gives an error

       if ($check2 != 0)
      {
       print ('Sorry, the username '.$_POST['username'].' is already in use.');
      }


       //this makes sure both passwords entered match

       if ($_POST['pass'] != $_POST['pass2'])
      {
       print ('Your passwords did not match. ');
      }

      // here we encrypt the password and add slashes if needed

       $_POST['pass'] = md5($_POST['pass']);

       if (!get_magic_quotes_gpc())
      {
       $_POST['pass'] = addslashes($_POST['pass']);

       $_POST['username'] = addslashes($_POST['username']);
      }

      // now we insert it into the database

     if($_POST['username'] && $_POST['pass'] && $_POST['pass2'] )
     {
     $insert = "INSERT INTO registration (username, password) VALUES ('".$_POST['username']."', '".$_POST['pass']."')";
     $add_member = mysql_query($insert);

     echo("<SCRIPT LANGUAGE='JavaScript'>window.alert('Registration had been succesfully added :)')</SCRIPT>");
     print("<meta http-equiv=\"refresh\" content=\"0; url=login.php\">");
     }

   }


 else
 {
  echo "<form action='registration.php' method='post'>

  <table border='0'>

  <tr><td>Username:</td><td>

  <input type='text'name='username' maxlength='60'>

  </td></tr>

  <tr><td>Password:</td><td>

  <input type='password' name='pass' maxlength='10'>

  </td></tr>

  <tr><td>Confirm Password:</td><td>

  <input type='password' name='pass2' maxlength='10'>

  </td></tr>

  <tr><th colspan=2><input type='submit' name='sub' value='Register'></th></tr> </table>

  </form> ";
 }
 

im just want the message text area to be appear in registhration php in text box but its doest not appear instead the output is empty when im testing the first one that is :

  if(strlen($message)>=1)
       {

         $message=strip_tags($message);
         echo("<SCRIPT LANGUAGE='JavaScript'>window.alert('$message')</SCRIPT>");
         die("<meta http-equiv=\"refresh\" content=\"0; url=registration.php\">");

that javascript box can run and read the same message that was input but when come to registrtaion php its only empty which way im wrong ?
 ?>

I have this code which uoploads and resizes the images into a folder without a problem. My problem is I am unable to view the Thumb or Full image which has uploaded to the folder and the database with the other data.  How do i correct this problem code below. Thanks

upload form and script
Code: [Select]

<?php
//database properties
$dbhost = 'localhost';
$dbuser = 'user';
$dbpass = 'pass';
$dbname = 'DB';

// make a connection to mysql here
$conn = mysql_connect ($dbhost, $dbuser, $dbpass) or die ("I cannot connect to the database because: " . mysql_error());
mysql_select_db ($dbname) or die ("I cannot select the database '$dbname' because: " . mysql_error());

/******** start function ********/

function errors($error){
if (!empty($error))
{
$i = 0;
echo "<blockquote>\n";
while ($i < count($error)){
echo "<p><span class=\"warning\">".$error[$i]."</span></p>\n";
$i ++;}
echo "</blockquote>\n";
}// close if empty errors

} // close function


// ----------------Create Smaller version of large image---------------------
function createthumbfull($src_filename, $dst_filename_full)
{
  // Get information about the image
        list($src_width, $src_height, $type, $attr) = getimagesize( $src_filename );

        // Load the image based on filetype
        switch( $type ) {
        case IMAGETYPE_JPEG:
                $starting_image = imagecreatefromjpeg( $src_filename );
                break;
        case IMAGETYPE_PNG:
                $starting_image = imagecreatefrompng( $src_filename );
                break;
        case IMAGETYPE_GIF:
                $starting_image = imagecreatefromgif( $src_filename );
                break;
        default:
                return false;
        }


// get the image to create thumbnail from
    $starting_image; 
// get image width
$width = imagesx($starting_image);
// get image height
    $height = imagesy($starting_image);
// size to create thumnail width
$thumb_width = 600;

    // divide iwidth by specified thumb size
    $constant = $width/$thumb_width;
// round height by constant and add t thumb_height
    $thumb_height = round($height/$constant, 0);


//create thumb with true colours
    $thumb_image = imagecreatetruecolor($thumb_width, $thumb_height);

//create thumbnail resampled to make image smooth
    imagecopyresampled($thumb_image, $starting_image, 0, 0, 0, 0, $thumb_width, $thumb_height, $width, $height);

$ran = rand () ;
$thumb1 = $ran.".jpg";

global $thumb_Add_full;
$thumb_Add_full = $dst_filename_full;
$thumb_Add_full .= $thumb1;

imagejpeg($thumb_image, "" .$dst_filename_full. "$thumb1");
} 



//-------------------- create thumbnail --------------------------------------------
//$src_filename = source of image
//$dst_filename_thumb = location to store final image
function createthumb($src_filename, $dst_filename_thumb)
{
    $size = getimagesize($src_filename); // get image size
   $stype = $size['mime']; //get image type : gif,png,jpg
   $w = $size[0]; // width of image
   $h = $size[1]; // height of image
   
   //do a switch statment to create image from right image type
   
   switch($stype) {
      //if image is gif create from gif
      case 'image/gif':
      $simg = imagecreatefromgif($src_filename);   
      break;
      //if image is jpeg create from jpeg
      case 'image/jpeg':
      $simg = imagecreatefromjpeg($src_filename);      
      break;
      //if image is png create from png
      case 'image/png':
      $simg = imagecreatefrompng($src_filename);      
      break;
      }

   
   $width = $w; // get image width   
    $height = $h; // get image height
   
   // size to create thumnail width
   $thumb_width = 150;
   $thumb_height = 150;
   
   //use true colour for image
   $dimg = imagecreatetruecolor($thumb_width, $thumb_height);
   $wm = $width/$thumb_width; //width divided by new width
   $hm = $height/$thumb_height; //height divided by new height
   $h_height = $thumb_height/2; //ass new height and chop in half
   $w_height = $thumb_width/2; //ass new height and chop in half
   
   //if original width is more then original height then modify by width
   if($w> $h) {
      $adjusted_width = $w / $hm; // add original width and divide it by modified height and add to var
      $half_width = $adjusted_width / 2; // chop width in half
      $int_width = $half_width - $w_height; // take away modified height from new width
      //make a copy of the image
      imagecopyresampled($dimg,$simg,-$int_width,0,0,0,$adjusted_width,$thumb_height,$w,$h);
      
      //else if original width is less or equal to original height then modify by height
      
   } elseif(($w <$h) || ($w == $h)) {
      $adjusted_height = $h / $wm; // diving original height by modified  width
      $half_height = $adjusted_height / 2; // chop height in half
      $int_height = $half_height - $h_height; // take away modified height from new width
      //make a copy of the image
      imagecopyresampled($dimg,$simg,0,-$int_height,0,0,$thumb_width,$adjusted_height,$w,$h);
   } else { // don't modify image and make a copy
      imagecopyresampled($dimg,$simg,0,0,0,0,$thumb_width,$thumb_height,$w,$h);
   }
      
   $ran = "thumb_".rand (); // generate random number and add to a string   
   $thumb2 = $ran.".jpg"; //add random string to a var and append .jpg on the end
   
   global $thumb_Add_thumb; //make this var available outside the function as it will be needed later.
   $thumb_Add_thumb = $dst_filename_thumb; // add destination
   $thumb_Add_thumb .= $thumb2; // append file name on the end
      
   //actually create the final image
    imagejpeg($dimg, "" .$dst_filename_thumb. "$thumb2");    
}

/********end functions ***********/

// if form submitted then process form
if (isset($_POST['submit'])){

// check feilds are not empty
$imageTitle = trim($_POST['imageTitle']);
if (strlen($imageTitle) < 3 || strlen($imageTitle) > 255) {
$error[] = 'Title must be at between 3 and 255 charactors.';
}

// check feilds are not empty or check image file size
if (!isset($_FILES["uploaded"])) {
$error[] = 'You forgot to select an image.';
}

// check feilds are not empty
$imageDesc = trim($_POST['imageDesc']);
if (strlen($imageDesc) < 3) {
$error[] = 'Please enter a description for your image.';
}

// location where inital upload will be moved to
$target = "productimages/" . $_FILES['uploaded']['name'] ;


// find the type of image
switch ($_FILES["uploaded"]["type"]) {
case $_FILES["uploaded"]["type"] == "image/gif":
move_uploaded_file($_FILES["uploaded"]["tmp_name"],$target);
    break;
case $_FILES["uploaded"]["type"] == "image/jpeg":
    move_uploaded_file($_FILES["uploaded"]["tmp_name"],$target);
    break;
case $_FILES["uploaded"]["type"] == "image/pjpeg":
    move_uploaded_file($_FILES["uploaded"]["tmp_name"],$target);
    break;
case $_FILES["uploaded"]["type"] == "image/png":
    move_uploaded_file($_FILES["uploaded"]["tmp_name"],$target);
    break;
case $_FILES["uploaded"]["type"] == "image/x-png":
    move_uploaded_file($_FILES["uploaded"]["tmp_name"],$target);
    break;

default:
    $error[] = 'Wrong image type selected. Only JPG, PNG or GIF accepted!.';
}

// if valadation is okay then carry on
if (!$error) {

// post form data 
   $imageTitle     = $_POST['imageTitle'];
   $imageDesc     = $_POST['imageDesc'];
   
   //strip any tags from input
   $imageTitle   = strip_tags($imageTitle);
   $imageDesc   = strip_tags($imageDesc);
   
   
   // add slashes if needed
   if(!get_magic_quotes_gpc())
{ 
$imageTitle   = addslashes($imageTitle);
$imageDesc   = addslashes($imageDesc);
 }
   
   // remove any harhful code and stop sql injection
   $imageTitle = mysql_real_escape_string($imageTitle); 
   $imageDesc = mysql_real_escape_string($imageDesc); 
   
  
//add target location to varible $src_filename 
$src_filename = $target;
// define file locations for full sized and thumbnail images
$dst_filename_full = 'productimages/';
$dst_filename_thumb = 'productthumb/';

// create the images
createthumbfull($src_filename, $dst_filename_full); //call function to create full sized image
createthumb($src_filename, $dst_filename_thumb); //call function to create thumbnail image
// delete original image as its not needed any more.
unlink ($src_filename);


// insert data into images table
$query = "INSERT INTO table (imageTitle, imageThumb, imageFull, imageDesc) VALUES
  ('$imageTitle', '$thumb_Add_thumb', '$thumb_Add_full', '$imageDesc')";
  $result  = mysql_query($query) or die ('Cannot add image because: '. mysql_error());
 
// show a message to confirm results
echo "<h3 align='center'> $imageTitle uploaded</h3>";
 
}
}


//dispaly any errors
errors($error);
?>

<form enctype="multipart/form-data" action="" method="post">
<fieldset>
<legend>Upload Picture</legend>
<p>Only JPEG, GIF, or PNG images accepted</p>
<p><label>Title<br /></label><input type="text" name="imageTitle" <?php if (isset($error)){ echo "value=\"$imageTitle\""; }?> /></p>

<p><label>Image<br /></label><input type="file" name="uploaded" /></p>

<p><label>Description<br /></label><textarea name="imageDesc" cols="50" rows="10"><?php if (isset($error)){ echo "$imageDesc"; }?></textarea></p>

<p><label>&nbsp;</label><input type="submit" name="submit" value="Add Image" /></p>

</fieldset>
</form>

view data
Code: [Select]

<?php 
 
 // Connects to your Database 
 mysql_connect("localhost", "user", "pass") or die(mysql_error()) ; 
 mysql_select_db("DB") or die(mysql_error()) ; 
 
 //Retrieves data from MySQL 
 $data = mysql_query("SELECT * FROM table") or die(mysql_error());  //Puts it into an array 
 while($info = mysql_fetch_array( $data )) 
 { 
 ?>
 
<?php echo "<img src=http://www.web.com/productimages/" .$info['imagefull'] ." > <br>"; ?>
<?php echo "<img src=http://www.web.com/productthumb/" .$info['imageThumb'] ." > <br>"; ?>


<?php echo "<b>imageTitle:</b> ".$info['imageTitle'] . "<br> "; ?>
<?php echo "<b>imageDesc:</b> ".$info['imageDesc'] . " <hr>"; ?>
 
<?php  }?>

I have two pages - add_product.php and show.php

here is the code for add_product.php

Code: [Select]
<?php

ini_set('display_errors',1);
error_reporting(-1);

require_once ('./includes/config.inc.php');

require_once (MYSQL);

$add_cat_errors = array();

if ($_SERVER['REQUEST_METHOD'] == 'POST')
{
// Check for a name:
if (empty($_POST['product'])) {
$add_cat_errors['product'] = 'Please enter the name!';
}

// Check for a description:
if (empty($_POST['prod_descr'])) {
$add_cat_errors['prod_descr'] = 'Please enter the description!';
}

// Check for a category:
if (!isset($_POST['cat']) || !filter_var($_POST['cat'], FILTER_VALIDATE_INT, array('min_range' => 1))) {
$add_cat_errors['cat'] = 'Please select a category!';
}

// Check for a price:
if (empty($_POST['price']) || !filter_var($_POST['price'], FILTER_VALIDATE_FLOAT) || ($_POST['price'] <= 0)) {
$add_cat_errors['price'] = 'Please enter a valid price!';
}

// Check for a category:
if (!isset($_POST['directory']) || !filter_var($_POST['directory'], FILTER_VALIDATE_INT, array('min_range' => 1))) {
$add_cat_errors['directory'] = 'Please select a directory!';
}

// Check for a stock:
if (empty($_POST['stock']) || !filter_var($_POST['stock'], FILTER_VALIDATE_INT, array('min_range' => 1))) {
$add_cat_errors['stock'] = 'Please enter the quantity in stock!';
}

if (empty($add_cat_errors))
{
$query = "INSERT INTO product (product, prod_descr, catID, price, dirID, stock) VALUES (?, ?, ?, ?, ?, ?)";
// Prepare the statement:
$stmt = mysqli_prepare($dbc, $query);
// For debugging purposes:
// if (!$stmt) echo mysqli_stmt_error($stmt);

// Bind the variables:
mysqli_stmt_bind_param($stmt, 'sssssi', $name, $desc, $_POST['cat'], $_POST['price'], $_POST['directory'], $_POST['stock']);

// Make the extra variable associations:
$name = strip_tags($_POST['product']);
$desc = strip_tags($_POST['prod_descr']);
// Execute the query:
mysqli_stmt_execute($stmt);

if (mysqli_stmt_affected_rows($stmt) == 1) { // If it ran OK.

// Print a message:
echo '<h4>The product has been added!</h4>';

// Clear $_POST:
$_POST = array();

// Clear $_FILES:
$_FILES = array();


} else { // If it did not run OK.
trigger_error('The product could not be added due to a system error. We apologize for any inconvenience.');
}

} // End of $errors IF.

} else { // Clear out the session on a GET request:
} // End of the submission IF.

require_once ('./includes/form_functions.inc.php');
?>

<form enctype="multipart/form-data" action="add_image.php?prodID={$row['prodID']}" method="post" accept-charset="utf-8">

<input type="hidden" name="MAX_FILE_SIZE" value="524288" />

Product<br /><?php create_form_input('product', 'text', $add_cat_errors); ?>
           
            Description<br /><?php create_form_input('prod_descr', 'textarea', $add_cat_errors); ?>
           
Category<br /><select name="cat"<?php if (array_key_exists('cat', $add_cat_errors)); ?>>
<option>Select One</option>
<?php // Retrieve all the categories and add to the pull-down menu:
$q = 'SELECT catID, cat FROM category ORDER BY cat ASC';
$r = mysqli_query ($dbc, $q);
while ($row = mysqli_fetch_array ($r, MYSQLI_NUM)) {
echo "<option value=\"$row[0]\"";
// Check for stickyness:
if (isset($_POST['cat']) && ($_POST['cat'] == $row[0]) ) echo ' selected="selected"';
echo ">$row[1]</option>\n";
}
?>
</select><?php if (array_key_exists('cat', $add_cat_errors)) echo $add_cat_errors['cat']; ?>
           
            Price<br /><?php create_form_input('price', 'text', $add_cat_errors); ?>
           
            Directory<br /><select name="directory"<?php if (array_key_exists('directory', $add_cat_errors)); ?>>
<option>Select One</option>
<?php // Retrieve all the categories and add to the pull-down menu:
$q = 'SELECT dirID, directory FROM directory ORDER BY directory ASC';
$r = mysqli_query ($dbc, $q);
while ($row = mysqli_fetch_array ($r, MYSQLI_NUM)) {
echo "<option value=\"$row[0]\"";
// Check for stickyness:
if (isset($_POST['directory']) && ($_POST['directory'] == $row[0]) ) echo ' selected="selected"';
echo ">$row[1]</option>\n";
}
?>
</select><?php if (array_key_exists('directory', $add_cat_errors)) echo $add_cat_errors['directory']; ?>
</select>

          <br />

Stock<br /><?php create_form_input('stock', 'text', $add_cat_errors); ?>


<input type="submit" value="Add This Product" class="button" />


</fieldset>

</form>

and here is the code for show.php

Code: [Select]
<?php

ini_set('display_errors',1);
error_reporting(-1);

require_once ('./includes/config.inc.php');

require_once (MYSQL);

$add_cat_errors = array();

if($id = isset($_GET['prodID']))
{
$q = "SELECT `prodID`, `product`, `prod_descr`, `catID`, `dirID`, `price`, `stock` FROM product WHERE `prodID`='{$_GET['prodID']}'";
$r = mysqli_query($dbc, $q);
while($row = mysqli_fetch_array($r))
{
echo $row['product'];
echo "<br />";
echo $row['prod_descr'];
echo "<br />";
echo $row['catID'];
echo "<br />";
echo $row ['dirID'];
echo "<br />";
echo $row['price'];
echo "<br />";
echo $row['stock'];
}
}


What I want is to try and retrieve the id of the last record inserted in add_product and pass it into show.php, but I get this error message.

Quote

An error occurred in script 'C:\Users\David Morgan\Desktop\WEBSITES\hairz_&_graces\site\admin\add_image.php' on line 16:
mysqli_fetch_array() expects parameter 1 to be mysqli_result, boolean given

I am struggling to find out where I am going wrong at the moment, if anyone could please help me that would be really appreciated.

Hi,

Is it possible to retrieve all the information from a posted value without knowing the input field?

My page is taking information from a database and then creates a page with checkboxs so that people can select certain fields. There are 1300 fields in the database so I don't know what fields will be submitted when a person saves the page,  is there a simple way to check what fields have been submitted without writing a check for each checkbox?

I hope this makes sense, thanks in advance for any help.

I have 3 dropdown menus which have the same name <select name="dropdown">, how to get the value from 3 of them by using php for loop and array? I did try to put array on them before, but seem it can't work. My codes :

<?php
for ( $counter = 1; $counter <= 3; $counter ++) {   
   if (isset($_POST['submit'])) { //Form has been submitted.
      $dropvalue = $_POST['dropdown[$counter]'];
        echo $dropvalue;
   }
}
?>

<form action="test8.php" name="frmtest8" method='post'>
<select name="dropdown[1]">
   <option value="1st">first</option>
    <option value="2nd">second</option>
    <option value="3rd">third</option>
</select>


<select name="dropdown[2]">
   <option value="1st">first</option>
    <option value="2nd">second</option>
    <option value="3rd">third</option>
</select>

<select name="dropdown[3]">
   <option value="1st">first</option>
    <option value="2nd">second</option>
    <option value="3rd">third</option>
</select>

<input type="submit" name="submit"  value="Send" />
</form>

It gives error message Parse error: parse error in C:\wamp\www\plekz\test8.php on line 23

I guess the error is because of $_POST['dropdown[$counter]']; I cannot put the two symbols [] inside  $_POST[' '] right? How to call the array if cannot put the two symbols?

Hi everyone,   I've been running a self-written php shopping cart for the last 8 years, with lots of success.  Recently however, the credit card processor (Linkpoint) I use upgraded their gateway, and now I have a problem.   Basically, the last page of my checkout does a _POST to a specific url for their gateway.  I send through a bunch of <input> variables, some of them hidden, but all of them check out okay.  I have combed over their specs, made sure I'm not sending any bad characters, made sure I've got the right format for the fields they want, etc...    Right now the transaction is successful, the customer's card is charged, but Linkpoint's system is returning an error message: We are unable to process your request due to invalid data.   Long story short, their support staff has asked me to "send them the xml string" via email.  I have no idea how to do this (even after spending a few hours online trying to figure it out).   Is there a simple way to generate the xml string that's being passed during the _POST?  Some kind of php code I can incorporate into my final checkout page, run a test transaction, and maybe write the string out somewhere so I can get it to them?   Any help you guys could give me would be greatly appreciated.  Thanks in advance!
Danny  

I'm doing this activity where a user chooses a base timezone and when the user clicks convert the current time in the selected GMT will be converted to GMT-11 to GMT+13.

As of now, I have these codes:
act09_view.php:
Code: [Select]
<?php
session_start();
    
    $s="GMT ";
    echo "Select the base time zone:</br>";
   
    for($n=-11;$n<=13;$n++)
    {
        if ($n>=0)
            $s="GMT +";
        $gmt[]=$s . $n . "</br>";
    }

    echo "<select name='gmt'>";
    foreach ($gmt as $value) 
    {
        echo '<option value="' . $value . '">' . $value . '</option>\n';
    } 
    echo '</select>';
    //$_SESSION['value']=$value;
 ?>
<form action="act09_process.php">
       </br><input type='submit' value='Convert'/>
</form>

act09_process.php:
Code: [Select]
<?php
session_start();
//$value=$_SESSION['value'];
//echo $value;

date_default_timezone_set('Asia/Manila');
$gmttime=date('M j, Y g:i:s A');
echo "The current date and time at" . " is " . $gmttime;
?>
I've tried using session variables. I think I executed them incorrectly. 

The output is supposed to look like this:

Hi, I want to be able to let user upload XML form, and then in the action page it needs to extract that so that I can add it to the database.

Here is the upload form:
Code: [Select]
<html>
<head></head>
<body>
<form method='post' action="uploadFileToDB.php" enctype="multipart/form-data">
<p>
<label>
                    Upload image<input type='file' name='imageFileType' id='imageFileType' />
                </label>
            </p>

            <p>
                <input type='submit' value='Upload this image' name='upload' id='upload' />
            </p>
</form>
 </body>
</html>

Here is the uploadFileToDB.php:
Code: [Select]
<?php
require("PHP_xml_parsing_via_DOM.php");
//NB: this script does the actual shreddering (XML to SQL)

//IF User uploaded dir or XML file successful, then:
if(isset($_POST['upload'])) {
//SHRED NOW
//NB: how to retrieve the uploaded xml file
$_filePath=??
$node=basename($_filePath);
$dom=new DOMDocument();
$dom->load($node);
$labelPath=array();
mysql_connect("localhost","root");
mysql_select_db("dummydpev7");

$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)==1) {
print "Entry already exists!";
$docId=mysql_next_id("xdocument")-1;
}
else {
mysql_query("INSERT INTO xdocument (file_Path,file_Name) VALUES ('$_filePath','$node')");
$docId=mysql_next_id("xdocument")-1;
}
print "<br />".$docId;

writeXMLtoDBViaDOM($dom->documentElement,$labelPath,$docId,$_filePath);
}
//ELSE
else
//Please upload Valid XML
print "Problem with XML file being uploaded.";

?>

The question in point is how do I extract the file I uploaded to set to $_filePath?? in the script so that I pass it to my function writeXMLtoDBviaDOM??

Please any help much appreciated!