PHP - Update Statement Trouble

I have the following code which seems to be in error in the conditional statement.
The queries to the database produce the expected results, and the echo statements work OK.
I want to make a selection based on whether data exists in the database for passState when passState=1.

Can anyone tell me what is wrong with the conditional statement?

Code: [Select]
<?php
$query1 = mysql_query("SELECT DISTINCT quizTitle, userId, passState, userScore, totalScore, DATE_FORMAT(userDate,'%b %e, %Y') AS userDate FROM quiz WHERE managerId = '$managerId' AND userId = '$userId' AND passState = 1 ORDER BY quizTitle ASC, passState DESC, userDate DESC ");

$query2 = mysql_query("SELECT DISTINCT quizTitle, userId, passState, userScore, totalScore, DATE_FORMAT(userDate,'%b %e, %Y') AS userDate FROM quiz WHERE managerId = '$managerId' AND userId = '$userId' AND passState = 0 ORDER BY quizTitle ASC, passState DESC, userDate DESC "); 
 ?>
                <table width="778" style="font-size:16px">
                  <tr>
 <?php
if ($query1) {
while ($row1 = mysql_fetch_array($query1))
{
           echo'<td width="13"></td>
                    <td width="137" style="vertical-align:middle; text-align:left;">' ?> <?php echo "{$row1['quizTitle']} <br />\n"; ?> <?php echo '</td>
                    <td width="13"></td>
                    <td width="132" style="vertical-align:middle; text-align:left;;">' ?> <?php echo "{$row1['userDate']} <br />\n"; ?> <?php echo '</td>
                    <td width="22"></td>
                    <td width="112" style="text-align:center; text-align:center;">' ?> <?php if ("{$row1['passState']}" == 1) {echo "<img src=' ../wood/wood_tool_images/tick2.png' /><br />\n";}?> <?php echo '</td>
                    <td width="30"></td>
                    <td width="103" style="text-align:center; text-align:center;">' ?> <?php if ("{$row1['passState']}" == 0) {echo "<img src=' ../wood/wood_tool_images/cross2.png' /><br />\n";} ?> <?php echo '</td>
                    <td width="19"></td>
                    <td width="126" style="vertical-align:middle; text-align:center;">' ?> <?php echo "{$row1['userScore']}".'/'."{$row1['totalScore']} <br />\n"; ?> <?php 
  echo '</td>
                    <td width="23"></td>
                    </tr>';                  
}
}else{
while ($row2 = mysql_fetch_array($query2))
{

              echo '<td width="13"></td>
                    <td width="137" style="vertical-align:middle; text-align:left;">' ?> <?php echo "{$row2['quizTitle']} <br />\n"; ?> <?php echo '</td>
                    <td width="13"></td>
                    <td width="132" style="vertical-align:middle; text-align:left;;">' ?> <?php echo "{$row2['userDate']} <br />\n"; ?> <?php echo '</td>
                    <td width="22"></td>
                    <td width="112" style="text-align:center; text-align:center;">' ?> <?php if ("{$row2['passState']}" == 1) {echo "<img src=' ../wood/wood_tool_images/tick2.png' /><br />\n";}?> <?php echo '</td>
                    <td width="30"></td>
                    <td width="103" style="text-align:center; text-align:center;">' ?> <?php if ("{$row2['passState']}" == 0) {echo "<img src=' ../wood/wood_tool_images/cross2.png' /><br />\n";} ?> <?php echo '</td>
                    <td width="19"></td>
                    <td width="126" style="vertical-align:middle; text-align:center;">' ?> <?php echo "{$row2['userScore']}".'/'."{$row2['totalScore']} <br />\n"; ?> <?php 
  echo '</td>
                    <td width="23"></td>
                    </tr>';
                  
}
}
 ?>
                </table>

Hi guys,

Sorry - this might more belong in the SQL section but I think it is PHP related. I am trying to update a table with:

$sql="UPDATE $tbl_name SET (gender, description)  VALUES ('$gender', '$description') WHERE image = ('$photoname')";
$result=mysql_query($sql);

Needless to say, its not working. Only odd thing is that the $photoname variable is sent with a hidden field on the previous form. I can echo all 3 varaibles though and get the right results. I just dont know why it isnt updating - seems pretty standard to me.

Can anyone help?

Thanks!

I have this simple form that registers schools. This year I have decide to upgrade and include a feature that checks if the school is already registered or not based on the imputed name. Here is the code (that is the only way I know how):


mysql_connect("", "", "") or die(mysql_error( '' ));
mysql_select_db("") or die(mysql_error( '' ));

$query  = "SELECT * FROM School_Registrations WHERE School_Name= '$_POST[SchoolName]' ";
$result = mysql_query($query);
if (mysql_numrows($result) > 0) {
while($row = mysql_fetch_array($result))

echo" error code here";} 

else {mysql_query("INSERT INTO `database`.`School_Registrations` (all the variables here);") 
or die(mysql_error( '' ));  
 
echo "Success Code";}



I am trying to incorporate this code somewhere into the 'else' statement but I have no luck. I am constantly getting some errors and when I fix one there is one more to take its place. I am lost. The last one I can not fix and I am not sure what it wants from me:

Fatal error: Call to undefined function getPage()

It works by itself without the if/else statement but not in the code listed above


$url = 'http://www.otherpage.com/page.php?';
$url .= 'email='.urlencode($_POST['email']);
 
$result2 = getPage('', $url, '', 15);
 
function getPage($proxy, $url, $header, $timeout) {
    $ch = curl_init();
    curl_setopt($ch, CURLOPT_URL, $url);
    curl_setopt($ch, CURLOPT_HEADER, $header);
    curl_setopt($ch, CURLOPT_RETURNTRANSFER, 1);
    curl_setopt($ch, CURLOPT_PROXY, $proxy);
    curl_setopt($ch, CURLOPT_HTTPPROXYTUNNEL, 1);
    curl_setopt($ch, CURLOPT_CONNECTTIMEOUT, $timeout);
    curl_setopt($ch, CURLOPT_REFERER, 'http://azsef.org');
    curl_setopt($ch, CURLOPT_USERAGENT, 'Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US; rv:1.9.0.8) Gecko/2009032609 Firefox/3.0.8');
    $result2['EXE'] = curl_exec($ch);
    $result2['INF'] = curl_getinfo($ch);
    $result2['ERR'] = curl_error($ch);
    curl_close($ch);
    return $result2;
}



Can you tell me why doesn't it work?
Thanks

I am trying to create a query to insert data into a table in my Access database.  I have the following query:

INSERT INTO Issues (DateRequested, CustomerID, ComputerID, Issue, ItemsIncl, ImageName) VALUES (#1/14/2015#, 1, 1, "Computer freezes while I'm on the internet.", "AC Adapter", "none.gif")

which should be performed from within my PHP page.  However, when I check the database afterward, the new record isn't there.  I then tried performing the query directly in Access and it worked fine.  Why would it work in Access, but not when I run the same query in PHP?     Chris

Hi, I am having trouble coding for mysqli update. Please, somebody
tell me the correct way. I'm trying to update the "lastused" (current date)
field in "emailtbl". Somebody please tell the best way to code this.
Below is the message and following, the current code:
  Fatal error: Call to undefined function curdate() in C:\xampp\htdocs\home\lastused.php on line 14  

 
$db = new mysqli('localhost', 'root', 'pass', 'mydb');
if($db->connect_errno > 0)
{die('Unable to connect to database [' . $db->connect_error . ']');}
$sql = <<<SQL
    SELECT *
    FROM `emailtbl`
    WHERE `id` = '$id'
SQL;

if(!$result = $db->query($sql))
{die('There was an error running the query [' . $db->error . ']');}
$lastused = $_POST['lastused'];
$lastused = curdate();
echo "last date accessed is ".$data['lastused'];
$result->free();
$db->escape_string('This is an unescape "string"');
$db->close();
?>
$update 

= mysqli_query($dbconnect, "UPDATE emailtbl SET
   lastused = curdate() WHERE id ='$id'");
    if($update == false)
    { die("UPDATE FAILED: ".mysqli_error($dbconnect)); }
    echo "$lastused is the last date this account was accessed";
 

Sorry I'm still new to php. So I'm trying to get my update statement to work. I will post the statement I have for it, I will also post sql code from the database it is trying to update and I will also post my form page. Appreciate any help, thanks.


Here is my update statement...


Code: [Select]
<?php

if (isset($_POST['update']))
{          
foreach($_POST['update'] as $update_id)
{             
$query = "UPDATE FROM users WHERE course_id = $update_id";             
mysqli_query($dbc, $query) or die ('can\'t update course');          

$course_id  = $_POST['course_id'];
$course_name = $_POST['course_name'];
$student_id = $_POST['student_id'];
$sql = "INSERT INTO users (course_id, course_name, student_id) VALUES ('$course_id', '$course_name', '$student_id');"; 
$db->exec($sql);

}
echo 'course has been updated.<br />';   
}

?>


Here is the page that the update statement is on...


Code: [Select]
<html>
<head>
<title>Update User</title>
</head>
<body>
<form method="post" action="update_user2.php">
<?php
$dbc = mysqli_connect('localhost', 'se266_user', 'pwd', 'se266') 
or die(mysql_error());
//delete users
echo '<b>Delete or Update User</b>.<br />';
if (isset($_POST['remove']))
{          
foreach($_POST['delete'] as $delete_id)
{             
$query = "DELETE FROM users WHERE course_id = $delete_id";             
mysqli_query($dbc, $query) or die ('can\'t delete course');          
}        
echo 'user has been deleted.<br />';   
}

if (isset($_POST['update']))
{          
foreach($_POST['update'] as $update_id)
{             
$query = "UPDATE FROM users WHERE course_id = $update_id";             
mysqli_query($dbc, $query) or die ('can\'t update course');          

$course_id  = $_POST['course_id'];
$course_name = $_POST['course_name'];
$student_id = $_POST['student_id'];
$sql = "INSERT INTO users (course_id, course_name, student_id) VALUES ('$course_id', '$course_name', '$student_id');"; 
$db->exec($sql);

}
echo 'course has been updated.<br />';   
}

//display users info with checkbox to delete  
$query = "SELECT * FROM users";  
$result = mysqli_query($dbc, $query);  
while($row = mysqli_fetch_array($result))
{      
echo '<input type="checkbox" value="' .$row['course_id'] . '" name="delete[]" />'; 
echo ' ' .$row['course_name'] .' '. $row['student_id'];
echo '<br />';  
}
mysqli_close($dbc);

?>
<input type="submit" name="remove" value="Remove" />
<input type="submit" name="update" value="Update" />
<br>
<br>
<form method="GET" action="update_user2.php">
<label for="course_id">Course ID:</label>
<input type="text" id="course_id" name="course_id" /><br />
<label for="course_name">Course Name:</label>
<input type="text" id="course_name" name="course_name" /><br />

<label for="course_name">Student ID:</label>

<input type="text" id="student_id" name="student_id" /><br />



</form>
</body>
</html>


Here is my sql database...

Code: [Select]
DROP DATABASE IF EXISTS se266;
CREATE DATABASE se266;


use se266;
CREATE TABLE users (
  course_id        INT(11)        NOT NULL   AUTO_INCREMENT,
  course_name       VARCHAR(50),
  student_id     VARCHAR(50)    NOT NULL,

  PRIMARY KEY (course_id)
);
-- create the users and grant priveleges to those users
GRANT SELECT, INSERT, DELETE, UPDATE
ON se266.*
TO se266_user@localhost
IDENTIFIED BY 'pwd';

INSERT INTO users (course_id, course_name, student_id)
VALUES ('se255', 'Web Design Using PHP', '43253256');
use se266;
SELECT * FROM users;

I have

<?php

/**

This file is responsible for processing all the add and modify requests
for the movies, games and customer section of the admin page.
The various functions here can be called into the pages we need inorder
to make code management cleaner and easier to handle.

**/

include('databaseconfig.php');

//Add a new customer to the data base.
$query = mysql_query("update customer set customer_id = '" .$_POST['cust_id'] . "', first_name = '" .$_POST['fname'] . "', last_name = '" .$_POST['lastname'] . "', adress = '" .$_POST['address'] . "', postal_code= '" .$_POST['postalcode'] . "', phone_number= '" .$_POST['phonenumber'] . "', user_name = '" .$_POST['fname'] . "', user_pass = '" .$_POST['lastname'] . "'");


echo("<h1>Output</h1>");
echo($query);

echo("<h1>Possible Errors</h1>");
//Echo errors
echo mysql_errno($query) . ": " . mysql_errno($query);





?>

Which should get the information from the forum feilds and insert that into the data base, throwing errors if I left feilds null.

But when I run it and leave everything blank and hit submit or even actually enter the required data all I get is a page that states

Code: [Select]
Output

Possible Errors
:

Believe me!! I have looked and tried so many snippets of code I am exausted!

TableName: keywords
Row: id  productid  keywords

Good morning...
I have been struggling with update, I dont know why... it seems easy eneough and it dosent look that different than a simple insert. Would someone please take a look at the if statement below, more specificly the update section. I am getting an error (Parse error: syntax error, unexpected T_STRING in...... ).

Code: [Select]
<?
$keywd = substr(implode(",", array_keys($arr_tem)),0,200);
$productid = intval($_GET['product_id']);

// Make a MySQL Connection
mysql_connect("localhost", "xxxxxxxxx", "xxxxxxxxx") or die(mysql_error());
mysql_select_db("xxxxxxxxx") or die(mysql_error());

$get = "SELECT * FROM keywords WHERE productid = $productid";
$SQ_query = mysql_query($get) or die("Query failed: $get\n" . mysql_error());
$fetch = mysql_fetch_array($SQ_query);

$id = $fetch['productid'];
$key = $fetch['keywords'];

// Evaluates to true because $var is empty
if (empty($id)) {
mysql_query("insert into keywords
(productid, keywords) VALUES('$productid','$keywd')");
}
else{
if (isset($id)) {
    echo '$var is set even though it is empty';

$mysql_query = mysql_query(UPDATE keywords
 SET keywords = '$keywd'
 WHERE productid = '$productid');

// $mysql_query = mysql_query(UPDATE keywords set keywords = "$keywd" WHERE productid = "$productid");

}
endif;
?>

First time poster, and very amateur php coder.  I am trying to delete items that in a list using ajax.  I can't figure out what I am doing wrong.  Any help would be greatly appreciated!

 

Here is a snippet of my javascript...

    $('.delete-item').click(function() {
        var itemID = $(this).data('itemID');
        var clear = 1;
        $.ajax({
            url: 'includes/delete-item.php',
            method: 'POST',
            data: {
                itemid:itemID,
                clear:1
            },
            success: function(data) {
                $('.content').load('includes/lists.php')
            }
        })
    })

 

and here is the relevant php...

$item = $_POST['itemid'];
$clear = $_POST['clear'];
$clearSQL = "DELETE FROM `List_Items` WHERE `item_ID` = $item";
$cleared = mysqli_query($connect, $clearSQL);

Hello:

I am trying to figure out how to do an UPDATE SET for a photo gallery based on the "photo_id" ... not working to well ...

Currently, it just uploads a photo but updates everything.

This is the code:
Photo_Edit.php
Code: [Select]
<?php

$photo_id = $_REQUEST['photo_id'];

?>

...


<?php


$query=mysql_query("SELECT * FROM gallery_photos WHERE photo_id = $photo_id") or die("Could not get data from db: ".mysql_error());

while($result=mysql_fetch_array($query))
{
  $photo_id=$result['photo_id'];
  $photo_filename=$result['photo_filename'];
  $photo_caption=$result['photo_caption'];
}

?>

<form enctype="multipart/form-data" action="a_Photo_Upload2.php" method="post" name="upload_form">

<input type='hidden' name='photo_id' value='<?php echo $photo_id; ?>' />


<table width='600' border='0' id='tablepadding' align='center'>


<tr>
<td width='50'>
  Photo:
<td width='550'>     
    <input name='photo_filename[]' id='my_photo' type='file' />
    <div style='clear: both;'></div>
    Current photo:
    <div style='clear: both;'></div>
    <img src="../gallery/tb_<?php echo $photo_filename; ?>" width="100px" class='imgCenter' />
    <div style='clear: both;'></div>
    <a href="javascript:void(0);" onmouseover="tooltip.show('<img src=../gallery/tb_<?php echo $photo_filename; ?> width=500 />');" onmouseout="tooltip.hide();">Larger view</a>
</td>
</tr>

<tr>
<td>
     Description:
</td>
<td>
    <textarea name='photo_caption[]' cols='100' rows='10'><?php echo $photo_caption; ?></textarea>
</td>
</tr>

<tr>
<td>
        <input type='submit' name='submit' value='Edit Product' />
</td>
</tr>
</table>
</form>


Goes to this page, where I am having the problems:

a_Photo_Upload2.php
Code: [Select]
<?php echo $photo_id; ?>

<?php
// initialization
$result_final = "";
$counter = 0;

// List of our known photo types
$known_photo_types = array( 
'image/pjpeg' => 'jpg',
'image/jpeg' => 'jpg',
'image/gif' => 'gif',
'image/bmp' => 'bmp',
'image/x-png' => 'png'
);

// GD Function List
$gd_function_suffix = array( 
'image/pjpeg' => 'JPEG',
'image/jpeg' => 'JPEG',
'image/gif' => 'GIF',
'image/bmp' => 'WBMP',
'image/x-png' => 'PNG'
);

// Fetch the photo array sent by preupload.php
$photos_uploaded = $_FILES['photo_filename'];

// Fetch the photo caption array
$photo_caption = $_POST['photo_caption'];

while( $counter <= count($photos_uploaded) )
{
if($photos_uploaded['size'][$counter] > 0)
{
if(!array_key_exists($photos_uploaded['type'][$counter], $known_photo_types))
{
$result_final .= "File ".($counter+1)." is not a photo<br />";
}

else
{

$new_id = mysql_insert_id();
$filetype = $photos_uploaded['type'][$counter];
$extention = $known_photo_types[$filetype];
$filename = $new_id.".".$extention;

mysql_query( "UPDATE gallery_photos SET photo_filename='".addslashes($filename)."' WHERE photo_id='".addslashes($new_id)."'" );

// Store the orignal file
copy($photos_uploaded['tmp_name'][$counter], $images_dir."/".$filename);

// Let's get the Thumbnail size
$size = GetImageSize( $images_dir."/".$filename );
if($size[0] > $size[1])


//{
//$thumbnail_width = 100;
//$thumbnail_height = (int)(100 * $size[1] / $size[0]);
//}
//else
//{
//$thumbnail_width = (int)(100 * $size[0] / $size[1]);
//$thumbnail_height = 100;
//}



{
//$thumbnail_width = 690;
//$thumbnail_height = (int)(500 * $size[1] / $size[0]);



$old_width = $size[0];
$old_height = $size[1];

$thumbnail_width = 690;
$thumbnail_height = ($old_height * $thumbnail_width / $old_width);





}
else
{
$thumbnail_width = (int)(690 * $size[0] / $size[1]);
$thumbnail_height = 500;
}



// Build Thumbnail with GD 1.x.x, you can use the other described methods too
$function_suffix = $gd_function_suffix[$filetype];
$function_to_read = "ImageCreateFrom".$function_suffix;
$function_to_write = "Image".$function_suffix;

// Read the source file
$source_handle = $function_to_read ( $images_dir."/".$filename ); 

if($source_handle)
{
// Let's create an blank image for the thumbnail
      //$destination_handle = ImageCreate ( $thumbnail_width, $thumbnail_height );
     
    $destination_handle = imagecreatetruecolor( $thumbnail_width, $thumbnail_height ); 
     
     

// Now we resize it

       ImageCopyResized( $destination_handle, $source_handle, 0, 0, 0, 0, $thumbnail_width, $thumbnail_height, $size[0], $size[1] );


}

// Let's save the thumbnail
$function_to_write( $destination_handle, $images_dir."/tb_".$filename );
ImageDestroy($destination_handle );
//

$result_final .= "<img src='".$images_dir. "/tb_".$filename."' style='margin-right: 20px; width: 100px;' />";


}
}
$counter++;
}

// Print Result
echo <<<__HTML_END

$result_final

__HTML_END;
?>


Can anyone show me how to make this work, OR show me a way to do this ...

Thank you.

I'm looking for an update statement that will remove all the extra space from a specific field. For example, all data on this field a

"Apple "
"Orange "
"Grapes Banana "

I'd like to update the database to remove the space at the end.

Thanks.

the sql statement dont execute: what would be the problem?                                                                            $sql = "UPDATE ".prefix("loanapplication")." SET                                                                           firstname = :firstname,                                                                          secondname = :secondname,                                                                          surname = :surname,                                                                          officialworkemail = :officialworkemail";                                                                           $sql.= " WHERE username=:username";                           $sql.= " WHERE username=:username";                                         echo "$sql: $sql<br>";                         //print_r($sql);                         $stmt = $database->connection->prepare($sql);                         $stmt->bindParam(':username',$session->username);                         $stmt->bindParam(':firstname',$firstname);                         $stmt->bindParam(':secondname',$secondname);                         $stmt->bindParam(':surname',$surname);                         $stmt->bindParam(':officialworkemail',$officialworkemail);                         $stmt->execute();       sql =UPDATE `emr_loanapplication` SET firstname = :firstname, secondname = :secondname, surname = :surname, officialworkemail = :officialworkemail WHERE username=:username

I can't get my Updated On timestamp to work in the following query...

Code: [Select]
// ******************************
// Create Temporary Password. *
// ******************************
$tempPass = substr(md5(uniqid(rand(), true)), 3, 10);

// Build query.
$r = "UPDATE member
SET pass=?,
updated_on=?
WHERE email=?
LIMIT 1";

// Prepare statement.
$stmt2 = mysqli_prepare($dbc, $r);

// Bind variables to query.
mysqli_stmt_bind_param($stmt2, 'sss', $tempPass, NOW(), $email);

// Execute query.
mysqli_stmt_execute($stmt2);

I used similar code for an INSERT and it worked fine?!  Now sure what is going on here...


Debbie

ive tried to write the $sql in so many ways and this looks the best and its still not working
and ive checked the correct syntax but still.

this is how i wrote:
$sql2 = "UPDATE `tvchaty`.`episodes` SET `showid` = ".($showid).", `epname` = ".($epname).", `season` = ".($season).", `episode` = ".($episode).", `info` = ".($info).", `airdate` = ".($airdate).", `directwatch` = ".($directwatch)." WHERE `episodes`.`id` = ".($id)." LIMIT 1;";   


this is the error:
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'Prideses, `season` = 6, `episode` = 11, `info` = , `airdate` = 2010-11-01, `dire' at line 1

what could be the problem?

tnx....

This isn't the entire code just enough to see what I'm trying to do.

Everything was working until I added the mysql update query in the if statement. Is this possible or am I doing something wrong?

When I run the script it just echos "No results found" twice as $num_results = 2. 

Code: [Select]
<?php

include("../includes/connect.php");

$query = "SELECT ........ ";
$result = $db->query($query);

$num_results = $result->num_rows;

if ($num_results == 0) {

exit;

} else {

$i=0;
while ($i < $num_results) {
$row = $result->fetch_assoc();

$id = $row['id'];

if ($expiration_date > $today) {

### EMAIL CODE HERE ###

$update = "UPDATE model SET reminder_sent = '1' WHERE id = '$id' ";
$result_2 = $db->query($update);
 
$i++;

} else {

echo "No results found.";

$i++;

}
}
}

?>