PHP - Update 2 Record Same Time

Anyone have any idea what I did wrong this time? 

This is def where my problem is
Code: [Select]
// UPDATE THE RECORD WITH THE CURRENT FORM DATA
$edit_query_insert="UPDATE client_information SET account_number = '$account_number', name_first = '$name_first', name_last = '$name_last', address = '$address', city = '$city', state = '$state', zipcode = '$zipcode', telephone = '$telephone', telephone_alt = '$telephone_alt', email = '$email'";

This is the code for the page itself:
Code: [Select]
// SELECT THE DATABASE
mysql_select_db("terra_elegante_operations", $con);


// GET THE FORM DATA FROM PREVIOUS PAGE
// ASSIGN NEW VARIABLES
$account_number = $_POST['account_number'];
$name_first = $_POST['name_first'];
$name_last = $_POST['name_last'];
$address = $_POST['address'];
$city = $_POST['city'];
$state = $_POST['state'];
$zipcode = $_POST['zipcode'];
$telephone = $_POST['telephone'];
$telephone_alt = $_POST['telephone_alt'];
$email = $_POST['email'];


// UPDATE THE RECORD WITH THE CURRENT FORM DATA
$edit_query_insert="UPDATE client_information SET account_number = '$account_number', name_first = '$name_first', name_last = '$name_last', address = '$address', city = '$city', state = '$state', zipcode = '$zipcode', telephone = '$telephone', telephone_alt = '$telephone_alt', email = '$email'";

if (!mysql_query($edit_query_insert,$con))
  {
  die('Error: ' . mysql_error());
  }
?>


<table border="0" cellspacing="0" cellpadding="3" width="960" bordercolor="#000000">
  <tr>
    <td valign="top" width="50%"><!-- Open Main left Cell --><table border="0" cellspacing="0" cellpadding="1" width="100%" bordercolor="#000000"><tr><td colspan="4"><B>CLIENT PROFILE</B></td></tr>
   
<?php
// Query & assign to the $client_information table.
$get_client_information = "SELECT * from client_information where account_number = $account_number";
$client_information = mysql_query($get_client_information) or die (mysql_error());

// The Array & Output - Included HTML Output here for $client_information

while ($row = mysql_fetch_array($client_information))
{
?>
  <tr>
    <td width="30%"><font face="verdana" size="2" color="#000000">Account Number:</font></td><td colspan="2"><font face="verdana" size="2" color="#000000"><?php echo $row['account_number']; ?></font></td>
  </tr>
  <tr>
    <td><font face="verdana" size="2" color="#000000">Last Name:</font></td><td><font face="verdana" size="2" color="#000000"><?php echo $row['name_last']; ?></font></td>
  </tr>
  <tr>   
    <td><font face="verdana" size="2" color="#000000">First Name:</font></td><td><font face="verdana" size="2" color="#000000"><?php echo $row['name_first']; ?></font></td>
  </tr>
  <tr>
    <td><font face="verdana" size="2" color="#000000">Address:</font></td><td><font face="verdana"size="2" color="#000000"><?php echo $row['address']; ?></font></td>
  </tr>
  <tr>
    <td><font face="verdana" size="2" color="#000000">City:</font></td><td><font face="verdana" size="2" color="#000000"><?php echo $row['city']; ?></font></td>
  </tr>
  <tr>
    <td width="10%"><font face="verdana" size="2" color="#000000">State:<font></td><td><font face="verdana" size="2" color="#000000"><?php echo $row['state']; ?></font></td>
  </tr>
  <tr>
    <td><font face="verdana" size="2" color="#000000">Zipcode:</font></td><td><font face="verdana" size="2" color="#000000"><?php echo $row['zipcode']; ?></font></td>
  </tr>
  <tr>   
    <td><font face="verdana" size="2" color="#000000">Telephone:</font></td><td><font face="verdana" size="2" color="#000000"><?php echo $row['telephone']; ?></font></td>
  </tr>
  <tr>   
    <td><font face="verdana" size="2" color="#000000">Telephone 2:</font></td><td><font face="verdana" size="2" color="#000000"><?php echo $row['telephone_alt']; ?></font></td>
  </tr>
  <tr>   
    <td><font face="verdana" size="2" color="#000000">E-mail</td></td><td><font face="verdana" size="2" color="#000000"><?php echo "<a class=\"bubble_nav\" href='mailto:?id=$row[email]'>$row[email]</a\>"; } ?></font></td>
  </tr>
</table>




<?php
include('includes/footer.php');

?>

There are 50 csv files. each csv file have the same column's name. some content in the column are the same, some don't.

eg：test1.csv,  example1.csv, hello.csv,  world.csv.......test70.csv.
now, i want to make a change to two column's content.

a, all csv files have a column named qty. whose rows content are all 0. now, i want to change it into Code: [Select]
888
b, all csv files have a column named image. whose rows content are all

Code: [Select]
upload/img1.jpg
 upload/img2.jpg
 upload/img3.jpg
 upload/img01.jpg
 upload/img14.jpg
 upload/img01.jpg
.......If i open each csv file then do a search and replace. i fell it too bored.

Thank you in advance.


i want to delete Uploadin the image column, change 0 to 888 in the qty column.

i using the file change.php to update the record.

one csv file. http://phplist.xxmn.com/women.csv



the code:

Code: [Select]
<?php
$dir    = getcwd();
$files = array_diff(scandir($dir), array('..', '.','change.php'));
foreach ($files as $file) {
    if (($handle = fopen($file, "r")) !== FALSE) {
        $new_content = '';
        while (($data = fgetcsv($handle, 100000, ",")) !== FALSE) {
            //var_dump($data);
           $data[2]=888; 
            $new_content .= implode(',', $data);
            //var_dump($new_content);
        }
       file_put_contents($file, $new_content);
        echo 'down';
    }
}

?>
the code doesn't work how to correct it . thank u

Not sure how to update a record in my table here. I got my insert and delete statement working. Just can't get the update to work correctly. I'm not really sure how to do it.



Here is my code for my page, and my update and delete page



Code: [Select]
<?php

ini_set ("display_errors", "1");
error_reporting(E_ALL);

require_once('database.php');
session_start();




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



$query = "INSERT INTO grades (grade_id, student_id, grade_type, grade_name, grade_points) ";
$query .= "VALUES (:grade_id, :student_id, :grade_type, :grade_name, :grade_points) ";

$statement = $db->prepare($query);
$statement->bindValue (':student_id', $_SESSION['student_id']);
$statement->bindValue (':grade_id', $_SESSION['grade_id']);
$statement->bindValue (':grade_type', $_POST['grade_type']);
$statement->bindValue (':grade_name', $_POST['grade_name']);
$statement->bindValue (':grade_points', $_POST['grade_point']);

$statement->execute();

$statement->closeCursor();





$grade_type = $_POST['grade_type'];

if ($grade_type == 'Lab') {


$final *= .60;
}

echo $final;


$grade_type = $_POST['grade_type'];

if ($grade_type == 'Mid-Term') {


$final *= .20;
}

echo $final;



$grade_type = $_POST['grade_type'];

if ($grade_type == 'Final') {


$final *= .20;
}

echo $final;


}

?>
<!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>View Course Grades</title>

<link rel="stylesheet" type="text/css" href="main.css" />
</head>

<body>


   



<?php

$student_name = $_SESSION['student_name'];
$student_id = $_SESSION['student_id'];
$query = "SELECT * FROM grades WHERE student_id = :student_id ";

$statement = $db->prepare($query);
$statement->bindValue (':student_id', $student_id);
$statement->execute();
$grades = $statement->fetchAll();
$statement->closeCursor();


echo "<h1>Show Grades for $student_name </h1>";

foreach ($grades as $grade)
{

echo $grade['grade_type'] . " " . $grade['grade_name']. " " . $grade['grade_points'] . "<br />";
}





?>

<div id="content">
            <!-- display a table of products -->
           
            <table>
                <tr>
                    <th>Grade Type</th>
                    <th>Grade Name</th>
                    <th>Grade Points</th>
                    <th>Remove</th>
                </tr>
                <?php foreach ($grades as $grade) : ?>
                <tr>
                    <td><?php echo $grade['grade_type'];   ?></td>
                    <td><?php echo $grade['grade_name'];   ?></td>
                    <td><?php echo $grade['grade_points']; ?></td>
                    <td><form action="delete_grade.php" method="post">
                       
                        <input type="submit" name="remove" value="Delete" />




                    </form></td>
                </tr>
                <?php endforeach; ?>
            </table>
           
        </div>
    </div>

    <div id="footer">
       
    </div>






<form name="grades" method="post" action="grades.php">

<p>Grade Type<SELECT NAME="grade_type">
<OPTION VALUE="Mid-Term">Mid-Term
<OPTION VALUE="Final">Final
<OPTION VALUE="Lab">Lab
</SELECT>
<br>







Grade Name:<input type="text" name="grade_name" value=""><br />
Grade Points:<input type="text" name="grade_point" value="">

<input type="submit" name="add_grade" value="Add Grade">


</form>

</table>

</body>

</html>





My delete and update page




Code: [Select]
<html>
<head>
<title>Delete Grade</title>
</head>
<body>
<form method="post" action="delete_grade.php">

<?php


ini_set ("display_errors", "1");
error_reporting(E_ALL);

$dbc = mysqli_connect('localhost', 'se266_user', 'pwd', 'se266') 
or die(mysql_error());

//delete grades

if (isset($_POST['remove']))
{          
foreach($_POST['delete'] as $delete_id)
{             
$query = "DELETE FROM grades WHERE grade_id = $delete_id";             
mysqli_query($dbc, $query) or die ('can\'t delete user');          
}        
echo 'user has been deleted.<br />';   
}

if (isset($_POST['update']))
{          
foreach($_POST['update'] as $update_id)
{             
$query = "UPDATE grades SET grade_id = $grade_id";             
mysqli_query($dbc, $query) or die ('can\'t update user');    
       
}
}

//Display grade info with checkbox to delete  
$query = "SELECT * FROM grades";  
$result = mysqli_query($dbc, $query);  
while($row = mysqli_fetch_array($result))
{      
echo '<input type="checkbox" value="' .$row['grade_id'] . '" name="delete[]" />'; 
echo ' ' .$row['grade_type'] .' '. $row['grade_name'];
echo '<br />';  
}
mysqli_close($dbc);

?>

<input type="submit" name="remove" value="Remove" />
<input type="submit" name="update" value="Update" />

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

Thanks for reading my post. How can I update the ten rows from MYSQL


Thanks in advance

Hi,
I am trying to update the status of the record. I don't want to insert the record if not exists. I just want to know the update is success or not.

I tried using affected_rows but it returns 0 if the existing status is same as the new status or if no record exists.

Please help.

Hello,    Anyone can suggest me what is the best way to update table records. I'm kinda scared to make an update on a table because it may damage the system and I am not really good on SQL commands.   Right now I just made a process on PHP to update table records. It does update email records on but it stop because of the limit of loading the page. Is there anyway accurately update all the data of the table.   Here is what I want to achieve.   I have a table with an "email" field on it, those email data from  "email" field on tb_one must be change to cID records base on tb_two.    tb_one  Field =   - id   - email   - etc.   tb_two Field =    - id   - email (same as on tb_one)   - cID  

hi -
i'm trying to update mysql databse but not working... any ideas???

Code: [Select]
[php]
<?php ob_start();
require_once('../xconfig.php');
if(isset ($_GET['quote'])&& $_GET['quote']!=""){
$quote_id=$_GET['quote'];
mysql_select_db($database, $makeconnection);
$sql_find_quote = "SELECT * FROM tbl_quote WHERE quote_id = $quote_id";
$find_quote = mysql_query($sql_find_quote, $makeconnection) or die(mysql_error());
$row = mysql_fetch_assoc($find_quote);
$totalRows = mysql_num_rows($find_quote);
$quote_author = $_POST['quote_author'];
$quote_desc = $_POST['quote_desc'];

if (isset($_POST['submitted'])&&($_POST['submitted'] == "yes")) {
$register_query = "SELECT quote_desc FROM tbl_quote WHERE quote_desc='$quote_desc'";

  mysql_select_db($database, $makeconnection);
   $register_check=mysql_query($register_query, $makeconnection);
    $register_found_quote = mysql_num_rows($register_check);
  
if($register_found_quote>1){
header ("Location: quote_modify.php?error=quoteexists&quote=$quote_id");
}else{
$sql_modify = "UPDATE tbl_quote SET  
  quote_desc = '$quote_desc'
quote_author = '$quote_author'
WHERE quote_id = '$quote_id'";
}
mysql_select_db($database, $makeconnection);
   $Result1 = mysql_query($sql_modify, $makeconnection) or die(mysql_error()); 
header ("Location: quote.php");
}
}
ob_flush();
?>
[/php]
here's my HTML form

Code: [Select]
  <form action="" method="post" enctype="multipart/form-data" name="form1" id="form1">
    <p>
      <input name="quote_author" type="text" class="active-field" id="quote_author" value="<? echo $row['quote_author'];?>"/>
      <br />
      <input name="quote_desc" type="text" class="active-field" id="quote_desc" value="<? echo $row['quote_desc'];?>" />
      <br />
      <input name="submitted" type="hidden" id="submitted" value="yes" />
      <input name="submit" type="submit" id="submit" class="submit-button" value="modiy"/>
      <br />
    </p>
  </form>

Hey guys, I'm just trying to add a form button to my site that updates a user's data in the mysql database. However I'm struggling trying to find a way to define which field to edit, can someone tell me if I'm along the correct lines:

Page with submit button:
Code: [Select]
<?php

        $result = mysql_query("SELECT * FROM members WHERE Username='$_SESSION[Username]'") 
                or die(mysql_error());  

     while($row = mysql_fetch_array( $result )) {    


echo '<b>Resources</b><br />';
                echo 'Wood: ' . $row['res1'] . ' <br />';
echo 'Iron: ' . $row['res2'] . ' <br />';
echo 'Credits: ' . $row['credits'] . ' <br />';

        } 



echo 'Offence Power: ';
echo $offencepower;
echo '<br />';
echo 'Defence Power: ';
echo $defencepower;
echo '<br />';
echo 'Total Power: ';
echo $totalpower;
        
?>
<br /><br />
 <form action="update.php" method="post">
      <input type="hidden" name="Memberid" value="' . $row['Memberid'] . '">
<input type="submit" name="submit" value="submit">
</form>


     



Update.php:

Code: [Select]
<?php include ('config.php'); ?>

<?php

$Memberid = mysql_real_escape_string($_POST['Memberid']); 

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


$query=("UPDATE members SET totalpower = '10' WHERE Memberid='$Memberid'"); 
 mysql_query($query); 

echo $query;
/* header('Location: ' . $_SERVER['HTTP_REFERER']);*/
  }
 ?>
 


When echoing the query I'm getting:
Quote

UPDATE members SET totalpower = '10' WHERE Memberid='\\\' . $row[\\\'Memberid\\\'] . \\\''



Thanks

Hi there i have webpages that are viewed through an iframe on my index page. Ive just added an update form on the index page itself and on redirection it doesnt go to the page within the iframe anymore, just the page itself.

Code: [Select]
  <iframe src="../swb/main2.php" width="80%" height="800"> </iframe>
The update code is: Code: [Select]
<?php $editFormAction = $_SERVER['PHP_SELF'];
if (isset($_SERVER['QUERY_STRING'])) {
  $editFormAction .= "?" . htmlentities($_SERVER['QUERY_STRING']);
}

if ((isset($_POST["MM_update"])) && ($_POST["MM_update"] == "form1")) {
  $updateSQL = sprintf("UPDATE player SET Repair=%s WHERE PlayerName=%s",
                       GetSQLValueString($_POST['repair'], "int"),
                       GetSQLValueString($_POST['player'], "text"));

  mysql_select_db($database_swb, $swb);
  $Result1 = mysql_query($updateSQL, $swb) or die(mysql_error());

  $updateGoTo = "repairs.php";
  if (isset($_SERVER['QUERY_STRING'])) {
    $updateGoTo .= (strpos($updateGoTo, '?')) ? "&" : "?";
    $updateGoTo .= $_SERVER['QUERY_STRING'];
  }
  header(sprintf("Location: %s", $updateGoTo));
} ?>
So maybe i can this line:   $updateGoTo = "repairs.php"; to something like   $updateGoTo = "repairs.php target='iframe src="../swb/repairs.php'";

Is this possible??

Thanks

hello all,  I have a table comment as follow:

**Comment**

comment_id         cmt               followupid
1                 Hello              3
2                 hi                 4
3                 Hey                2
4                 wassup             1

My query is that I want to echo "Hello", "hi", "hey" , "Wassup" and other (the record continues) individualy, I have used

$comment = mysql_result($runQuery, $i,"cmt");
echo $comment;

which works fine but the problem is that it echoes all the comments at once, what I want is to echo all the comment but one at a time.  the comment are in  a div tag such that each the div appears only after 1 second the page is loaded. I want each comment to appear after different time interval

for e.g:
 
Hello  to appear at        5pm    (not necessarily the corect time it can be just an int)
hi                         5.10 pm
hey                        6.30 pm

Please Help!

Greetings everyone! I have a form that stores data to a database. Separate from that page I would like to have another where at any given time a user can download a .csv of the most recent addition or two? If not a .csv, can they easily view the record without having to know mySQL / phpAdmin and such?

Thanks!

Jerry

I have 2 tables, access_level and pages. In pages table i will have all the details of page like page_id, code, herf, pagename.. and i will select few from this table and store it in access_level table depending on the department and position. 

Now while editing, i will display all the pages which is stored in access_level pages with a particular page code along with those pages from pages table. if the page_id exists in access_level table, its has to get updated, if its not present then it should get inserted into access_level table. 

These things am doing with checkbox and <li>. 

my access_level table    access_level.JPG   18.19KB   0 downloads   and my pages table    pages.JPG   37.86KB   0 downloads   here is my code

$s1 = mysql_query("SELECT pages.page_id as pid, pages.code, pages.page, 
            pages.href, access_level.aid, access_level.page_id as pgid, 
            access_level.department, access_level.position, 
            access_level.active 
        FROM pages
        LEFT JOIN access_level ON (pages.page_id=access_level.page_id 
            AND access_level.department=".$department." 
            AND access_level.position=".$position.") WHERE pages.code='snor die(mysql_error());
				while($s2 = mysql_fetch_array($s1)) {  ?>
				<tr><td><li><?php echo $s2['page']; ?>  </td><td><input type="checkbox" name="sn[]" value="<?php echo $s2['pid']; ?>" <?php if($s2['pgid'] === $s2['pid']) echo 'checked="checked"';?> />
                <input type="hidden" value="<?php echo $s2['pid']; ?>" name="page_id[<?php echo $s2['pgid']; ?>]">

while submittings i am not getting the logic, how can be done. Please somebody suggest me

Hi all, Im really struggling to build an update multiple records form, Ive built my table which calls all data i need from the db in a looped region which works fine I just cant understand how to then input these back into the table in the correct rows, if this makes sense? Ive been reading this tutorial but Its not very informative its more of a copy and paste http://www.phpeasystep.com/mysql/10.html

I am trying to get this query correct.  I want to insert a record into the database upon form submission but only if the record does not already exist.  If the record exists, then I want it to be updated in the database.    What is happening:  Upon form submit, a new record is entered into the database every time.  Note:  The contact_id column is both primary key and unique in my database.  Here is my code:

if($_POST['submit']){
  $con=mysqli_connect("localhost","username","password","database_name");
  // Check connection
  if (mysqli_connect_errno())
    {
      echo "Failed to connect to MySQL: " . mysqli_connect_error();
    }
	
	$org = mysql_real_escape_string($_POST['organization']);
  	$namefirst = mysql_real_escape_string($_POST['firstName']);
        $namelast = mysql_real_escape_string($_POST['lastName']);
	$emailaddy = mysql_real_escape_string($_POST['email']);
	$phonenum = mysql_real_escape_string($_POST['phone']);
	$appquestion = mysql_real_escape_string($_POST['appquestion']);
	$banner = mysql_real_escape_string($_POST['banner']);
	$bulletin = mysql_real_escape_string($_POST['bulletin']);
	$giveaway = mysql_real_escape_string($_POST['giveaway']);
	$app = mysql_real_escape_string($_POST['app']);
	$tshirt = mysql_real_escape_string($_POST['tshirt']);
	$tshirtp = mysql_real_escape_string($_POST['tshirtp']);
	$print = mysql_real_escape_string($_POST['print']);
	$party = mysql_real_escape_string($_POST['party']);
	$orgnotes = mysql_real_escape_string($_POST['notes']);
	
 
$sql="INSERT INTO database_name (contact_id, first_name, last_name, email_address, phone_number, org, appquestion, banner, bulletin, giveaway, app, tshirt, promised_tee, print, party, org_notes)
      VALUES
      ('','$namefirst','$namelast','$emailaddy','$phonenum','$churchorg','$appquestion','$banner','$bulletin','$giveaway','$app','$tshirt','$tshirtp','$print','$party','$orgnotes')	
	    
	  ON DUPLICATE KEY UPDATE first_name = '$namefirst', last_name = '$namelast', email_address = '$emailaddy', phone_number = '$phonenum', org = '$org', appquestion = '$appquestion', banner = '$banner', bulletin = '$bulletin', giveaway = '$giveaway', app = '$app', tshirt = '$tshirt', promised_tee = '$tshirtp', print = '$print', party = '$party', org_notes = '$orgnotes'" ;

						

    if (!mysqli_query($con,$sql))
    {
      die('Error: ' . mysqli_error($con));
    }
      echo "1 record added";



  mysqli_close($con);
}

From everything I have read, I need to use ON DUPLICATE KEY UPDATE to replace the old information with new information in the database upon form submission.  While the insert part of my code is working, the portion with ON DUPLICATE KEY UPDATE is not working.   Why might this portion of the code not be working?  Is there a better way to insert else update the information?   Thank you for any help or guidance you can give me!  I've been working on this concept for three days and have read a ton of information about it, but am still not able to get it to work.

Hello, Here is my current code: index.php

<html>
<body>
<form id="hey" name="hey" method="post" onsubmit="return false">
Name:<input type="text" name="name">
<input type="submit" name="submit" value="click">
</form>
<table class="table table-bordered" id="update">
<thead>
<th>Name</th>
</thead>
<tbody>
<script type="text/javascript">
      $("#hey").submit(function() {
          
        $.ajax({
          type: 'GET',
          url: 'response.php',
          data: {   username: $('#name').val()},
          success: function (data) {
            $("#update").prepend(data);
          },
          error: function (xhr, ajaxOptions, thrownError) {
            alert(thrownError);
          }
        });
      });
      
    </script>
</tbody>
</table>

response.php

<?php
$username = $_GET['username'];
echo "<tr>";
echo "<td>$username</td>";
echo "</tr>";
?>

This code works fine, it prints out the rows as what the user enters. Now what I want to do is, log all these entries to a mySQL database and also, display these rows over the site. i.e., any user who is online, should be seeing this without having to refresh the page too.. Real time updates in a way.   How can I achieve that? Thanks!