PHP - Keep Getting Error When Update Mysql Statement Please Help.

I can't find the error, someone help me please.                   $conn = mysql_connect("localhost","root","Pass");
                $err_db = mysql_select_db('bd_amics');
                $sql = ("INSERT INTO `'".$_SESSION["use"][14]."'` (ID,Amic,PubID) VALUES ('".$_SESSION["person"][14]."', "1", '".$_SESSION["person"][15]."')");
                mysql_query("SET NAMES utf8");
                mysql_query($sql, $conn);
                mysql_close();                   $conn3 = mysql_connect("localhost","root","Pass");
                $err_db3 = mysql_select_db('bd_amics');
                $sql3 = ("UPDATE `'".$_SESSION["person"][14]."'` SET Amic="2" WHERE ID='".$_SESSION["use"][14]);
                mysql_query("SET NAMES utf8");
                mysql_query($sql3, $conn3);
                mysql_close();

Hey i keep getting undefined  index error when i submit the editing page I cant figure out what the problem is I have checked if i have miss spelled anything from the mysql table and i haven't  please help everything exist in mysql but still im getting this error and not letting me update it


Notice: Undefined index: uruklink in D:\wamp\www\admin\edit.php on line 8
Notice: Undefined index: ketabsetlink in D:\wamp\www\admin\edit.php on line 9

<?php
include "../configdb.php";

$id = $_GET['id'];
if(isset($_POST['submit']))
{
    //global variables
$uruklink = $_POST['uruklink'];
$ketabsetlink = $_POST['ketabsetlink'];


//run the query which adds the data gathered from the form into the database    
$result = mysql_query("UPDATE softlinks SET uruklink='$uruklink', ketabsetlink='$ketabsetlink' WHERE id='$id' ",$connect);
echo "<b>Your Page have been edited successfully";
// echo "<meta http-equiv=Refresh content=2;url=index.php>";
}
elseif($id)
{
$result = mysql_query("SELECT * FROM softlinks WHERE id='$id' ",$connect);
        while($row = mysql_fetch_assoc($result))
{
$uruklink = $row['uruklink'];
$ketabsetlink = $row['ketabsetlink']; ?>

<h3>::Edit Page</h3>
<form method="post" action="<?php echo $_SERVER['PHP_SELF'] ?>?id=<?php echo $row['id']?>">
<input type="hidden" name="id" value="<?php echo $row['id']?>">
<input name="name" size="40" maxlength="255" value="<?php echo $uruklink; ?>">
<input name="footer" size="40" maxlength="255" value="<?php echo $ketabsetlink; ?>">
<input type="submit" name="submit" value="Submit">       

     
      <?php
}
}
?>

Can anyone post a generic update function to update mysql table.
The manual approach:

update $tablename
set $column1='a', $column2='b'
where $id=$value;

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;
?>

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
:

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;

Having update statement trouble... The error I'm getting is...

"Could not query the database - : "

Not sure what I'm missing, I had this working before also, but now it's not.


Here is my code for the update page...



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 user');          
}        
echo 'user has been deleted.<br />';   
}

if (isset($_POST['update']))
{      

$course_id  = $_POST['course_id'];
$course_name = $_POST['course_name'];
$student_id = $_POST['student_id'];

 

$query = "UPDATE users SET course_name ='". $course_name ."' WHERE course_id = $course_id";             
$updres = mysqli_query($query);
if(!$updres)
{   die(" Could not query the database - : <br/>". mysqli_error() ); }
else
{ 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);

?>

<form method="POST" 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 />
<input type="submit" name="remove" value="Remove" />
<input type="submit" name="update" value="Update" />
<br><br>
</form>



</body>
</html>

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

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'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.

HI All,

I am writing a prepared statement to update some user information.

Included in this table are the username and password fields. 

In this particular form, i dont want the user to have access to this information and have built a form that only shows what i want them to be able to change.

The bit that i am not sure about is the prepared statement that i am writing.

I am getting a boolean error suggesting that my prepare failed and i think this may be because i have not named every field in the table.

To give an idea of the table fields i have pulled this from php my_admin (this is not the sql i am running)

UPDATE `ssm_user` SET `user_id`=[value-1],`user_email`=[value-2],`user_password`=[value-3],
`user_firstname`=[value-4],`user_lastname`=[value-5],`user_accountlevel`=[value-6],
`user_mobile`=[value-7],`user_role`=[value-8],`user_lastlogondate`=[value-9] WHERE 1

my prepared statement is

$stmt = $conn->prepare("
			UPDATE ssm_user 
			SET 
			user_email=?,
			user_firstname=?,
			user_lastname=?,
			user_accountlevel=?,
			user_mobile=?,
			WHERE user_id = ?
			");

		$stmt->bind_param('sssssi', $email, $fname, $lname, $accountlevel, $mobile, $uid);
    	$stmt->execute();
    	return $stmt->affected_rows;

Do i have to declare every field in the table or is there something that i am missing here.

There are about 400 records in a database with a field zabp_package = T_SIMT.
They were uploaded in an order where specific category lists were uploaded together.  For example, first 100 dining, then 75 insurance, then 150 health, then 75 cars.  So from an auto increment standpoint they were inserted in that order.
I want to select at random 100 of these 400 and update two fields.  My update statement is:
update  `usersOld` SET  `m_org` = 'ZABP.org Corporate HQ' , `m_orgID` = 'PFL2a96bW' WHERE `zabp_package` = 'T_SIMT'
This works for all, I just need to limit a random selection to 100.
Any Help on this, thanks in advance.

 

In the same $-POST , i wanted  to perform update and delete. With the updated and deleted database, I need to select the updated data from the database. However, it tells me:  Warning: mysqli_num_rows() expects parameter 1 to be mysqli_result, boolean given in... .I am new to sql in php, is it true that i cannot perform sql in this way? Or is there any suggestion to perform select straight after deleting and updating?

CANCEL BOOK RESERVATION
if(isset($_POST['cancelres']))
{


        $query = "DELETE FROM reserved_books WHERE id='$resid';"; //delete reservation
        $query .="UPDATE reserved_books SET queue = queue - 1 WHERE bookid = '$bookid' AND queue > '$bookqueue';";//update queue number where reservation that queue behind/after/ the current reservation
        $query_run = mysqli_multi_query($connection, $query);

        if($query_run)
        {
          $_SESSION['success'] = "Reservation Cancelled";
        }
        else
        {
          $_SESSION['status'] = " Reservation Not Cancelled";    
        }

        $query= "SELECT title FROM books WHERE id = '$bookid';"; //get book title from db
        $query_run = mysqli_query($connection,$query);
        if(mysqli_num_rows($query_run)>0)
        {
            foreach ($query_run as $row) {
            $title = $row['title'];
            }
        }
        $bookres = "SELECT * FROM reserved_books WHERE bookid = '$bookid' AND queue = 1";
        $bookres_run = mysqli_query($connection,$bookres);
        foreach($bookres_run as $row)
        {
            $res_username = $row['username'];
            $res_id = $row['id'];
        }

        $query= "SELECT option_value FROM settings WHERE option_name = 'email_temp_rescollect'"; //get email template from db
        $query_run = mysqli_query($connection,$query);
        if(mysqli_num_rows($query_run)>0)
        {
            $row = mysqli_fetch_array($query_run);
            $rescollect_template = $row[0];
        }}

 

Please help me with this: been doing this for 2 days and still cannot solve it. it won't update...

I have attached my file:

<?php
include('connect-database.php');
if (isset($_POST['submit']) AND $_POST['submit'] == 'update') {
   $error = false;
   extract($_POST);
   if (empty($full_name)) $error = true;
   if (!$error) {
      $update = "UPDATE users SET
               full_name = '$full_name',
               WHERE id=$id
               ";
      mysql_query($update) or die(mysql_error() . "<br><br>" . $update);
      $full_name = '';
      $message = "Record successfully updated.";
   } else {
      $message = "There is an error in your entry";
   }
} else {
   $id = intval(isset($_GET['id']) ? $_GET['id'] : 0);
}
if ($id == 0) {
   echo "<div style='margin-bottom:10px'>Invalid ID.</div>";
   exit;
}
$query = "SELECT * FROM users WHERE id=$id";
$result = mysql_query($query) or die(mysql_error() . "<br><br>" . $query);
if (mysql_num_rows($result) == 0) {
   echo "<div style='margin-bottom:10px'>Record Not Found in Database!</div>";
   exit;
}
$row = mysql_fetch_array($result);
extract($row);

?>
  <div id="mainContent" class="tab_container">
    <div id="tab1" class="tab_content">
    <h1>Edit Personal Data</h1>
   <div style="color:red;font-weight:bold"><? echo $message; ?></div>
          <form name="submit" action="" method="post">
        <ul>
           <li><b>ID # :</b> <?php echo $id?></li>
           <li><b>Name :</b> <input type="text" name="full_name" id="" size="30" value="<?php echo $full_name ?>" /></li>
            <li><b>Address :</b> <input type="text" name="address" id="" size="55" maxlength="100" value="<?php echo $address ?>" /></li>
            <li><b>Contact Number :</b> <input type="text" name="contact_number" id="" size="11" value="<?php echo $contact_number ?>" /></li>
            <li><b>Email Address :</b> <input type="text" name="user_email" id="" size="30" value="<?php echo $user_email ?>" /></li>
            <li><b>Status :</b> <input type="text" name="status" id="" size="10" value="<?php echo $status ?>" /></li>
            <li><b>Nationality :</b> <input type="text" name="nationality" id="" size="20" value="<?php echo $nationality ?>" /></li>
            <li><b>Religion :</b> <input type="text" name="religion" id="" size="20" value="<?php echo $religion ?>" /></li>
        </ul>
    <h2>Self Description</h2>
    <p><textarea rows="9" cols="40" name="self_description" ><?php echo $self_description ?></textarea></p>
   <input type="hidden" name="id" value="<?php echo $id; ?>" />
   <input type="submit" name="submit" value="update" />
   
   </form>
    </div>

The second $navigation variable I have set is where the issue is coming from. It seems I am not aloud to set an if statement within a variable. Can someone please show me a work around to this issue? Any help would be very much appreciated.

Code: [Select]

$selected = "class=\"selected\"";
$naviagtion = "<ul>";
$navigation .= "<li" . if(!isset($_GET['sub']) || ($_GET['sub'] == 1)) { return $selected; } . "><a href=\"?tier=1&sub=1\">Main</a></li>";
$naviagtion = "</ul>";