PHP - Insert Or Update

I have a form right now that Updates a table on my database.

I was wondering if I could possibly still have that working but also Insert the same information into another table on the database when the submit button is pressed?

how can i make this code to insert a single, multiple and update rows in the database. The code only insert new rows in the database.

Code: [Select]

if (($handle = fopen('inventorylist.csv', "r")) !== FALSE) {
    while (($data = fgetcsv($handle, 100000, ",")) !== FALSE) {
        $num = count($data);
     

                  $sql="INSERT into inventory(itemNumber,itemDesc,quantityHand,category,Whse) values('$data[0]','$data[1]','$data[2]','$data[3]','$data[4]')";

                    mysql_query($sql) or die(mysql_error());

       
    }
    fclose($handle);

        }

I am trying to create a script that takes information from a form and puts in a database.
In the action page, I decided to post a URL that shows the user there story that they posted. This is where I ran into the problem. . I realized that for the optional fields I could not just use a seperate insert statement, because this creates a new row. So I desided to use update statments, but this STILL does not work, they values or simply not getting inserted.  Here is the code:
Code: [Select]
<?php

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

die('SPAM BOT!');
}
if (
!isset($_POST['title']) 
&& !isset($_POST['summary'])
&& !isset($_POST['story'])
&& !isset($_POST['rating'])
&& !isset($_POST['cat'])
)
{
die("<div id='impor'>You forgot to enter one(or more) of the following fields <br /> 
1. Title <br />
2. Summary <br />
3. Story<br />
 </div>
 ");

}


mysqlConnect();


//take data from form an\ put them in variable
$title_form = bb(mysql_real_escape_string($_POST['title'])); //required 
$summ_form = bb(mysql_real_escape_string($_POST['summary']));// required
$story_form = bb(mysql_real_escape_string($_POST['story'])); 
$cat_form = $_POST['cat'];
$rating_form = $_POST['rating'];
$username = $_SESSION['user'];
// Make the other var into a list of links




mysql_query("
INSERT INTO story_info (title, sum, story, user, cat, rating)
VALUES('$title_form','$summ_form', '$story_form,', '$username', '$cat_form','$rating_form')
");
if(isset($_POST['notes']))
{
$notes_form = mysql_real_escape_string($_POST['notes']);
$notes_final = bb($notes_form);
mysql_query("
UPDATE story_info
SET notes = '$notes_final'
WHERE story = '$story_form' AND user = '$username' AND sum = '$summ_form' AND title = '$title_form'
");
}
//put other in array. Use while loop to put link code. Then but it back into one non array variable
if(isset($_POST['u_id']))
{
$uid = mysql_real_escape_string($_POST['u_id']);
$uid_db = str_replace(' ','_', $uid);
$blerg = "
UPDATE story_info
    SET series_id = '$uid_db'
WHERE story = '$story_form' AND user = '$username' AND sum = '$summ_form' AND title = '$title_form'
";
mysql_query($blerg);

}
echo "<h1> Your Story Has Been Posted! Thanks for posting $username .   </h1>";
echo "Please review the post below <br />";
echo "<h2> $title_form </h2>";
echo "<strong> <h2> Summary: </h2> </strong> $summ_form";
echo "<h4> Story: </h4>";
echo "$story_form";
if(isset($notes))
{
echo "<h4> Author's Notes: </h4> ";
echo "$notes_final";


}
if (isset($uid_db))
{
echo '<h3> Unique Series ID </h3>';
echo '<p> Make sure to write down this! <br />' .$uid_db .'</p> ';
}

$db = mysql_query("
SELECT story_id
FROM story_info
WHERE story='$story_form' AND user='$username'
")or die(mysql_error());
$rows = mysql_fetch_assoc($db);

$id = $rows['story_id'];





echo "Catagory: $cat_form <br />
Rating: $rating_form  <br />
";
echo "<a href='?p=page&id=$id'> Click here to view your story! </a>'";
?>


Please help!

Hi i need to count the number items in an album now on the album i have create a field called count which counts the number items in that album

but now i dnt knw how to update those as soon insert a item in the table item

so i thought woul be possible to create a script that when insert data into item tables also update album table row count by adding one like update count with A now A equal row count ++1  any help on start of it if possible???/

Hello:

Can someone give me some insight on how to be able to not just add (INSERT) a photo and photo description with the following code, but also how to add the ability to UPDATE (if the user wants to replace a photo or adjust the photo description):

Code: [Select]
<?php
include("config.inc.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
{
mysql_query( "INSERT INTO gallery_photos(`photo_filename`, `photo_caption`, `photo_category`) VALUES('0', '".addslashes($photo_caption[$counter])."', '".addslashes($_POST['category'])."')" );
$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;
}

// 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 );

// 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."' /> File ".($counter+1)." Added<br />";
}
}
$counter++;
}

// Print Result
echo <<<__HTML_END

<html>
<head>
<title>Photos uploaded</title>
</head>
<body>
$result_final
</body>
</html>

__HTML_END;
?>

The tutorial says to edit a photo, simply add:
Code: [Select]
function edit_photo( $photo_id, $new_caption, $new_category )        <br>
{        <br>
  mysql_query( "UPDATE gallery_photo SET photo_caption='".addslashes( $new_caption )."', photo_category='".addslashes( $new_category )."' WHERE photo_id='".addslashes( $photo_id )."'"  );        <br>
}


But I can not figure out how to call that function.

Anyone help me out?

Thanks.

I am attempting something similar to the following:

Code: [Select]
mysql_query("UPDATE table SET name='$name' WHERE id=$id");
if (mysql_affected_rows()==0) {
mysql_query("INSERT INTO table (id, name) VALUES ('$name',$id);
}

If the $id row does not exists in the table, mysql_affected_rows() returns 0 and a new $id row gets inserted
but if the $id row already exists and UPDATE changes nothing, mysql_affected_rows() still returns 0
and gives an 'duplicate id' error as expected.

I know I could use a SELECT to test for the existance of the $id row.
In Perl there is an '0E0', 'zero but true', condition to handle this. Is there an equivilant in PHP?
 

Hi I'm currently experiencing a problem with my query. I've used the `INSERT IGNORE` option in my query and it works pretty well not to add duplicates, but the problem is that if my unique field match it doesn't update any other info in the row, is there maybe another option to update a row if an existing field exists but insert new row if it doesn't exists?   my current query is as follow  

$query = mysqli_query($con,"INSERT IGNORE INTO mxit (ip,time,user_agent,contact,userid,id,login,nick,location,profile) 
VALUES ('$ip','$post_time','$mxitua','$mxitcont','$mxituid','$mxitid','$mxitlogin','$mxitnick','$mxitloc','$mxitprof')") or die(mysqli_error($con)); 

Is there any way to tell my php ajax file to run the update query if the data already exist and if not, then create the row in the database?  I have both the update and the insert functions created, but was just wondering if I could tell php which one to use without passing through a parameter.

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();

I put a snippet up yesterday, and thought it had been solved. It had a typo error, but there is still something wrong. The whole page follows, because it might be easier to see what I am doing. The form successfully inserts a new record OK, but it will not update a record that already exists as is intended. Instead, it always creates another new record. Where can I be wrong?


<?php
session_start();

// See if logged in member by checking session data
if (isset($_SESSION['recid'])) {
    // Put stored session variables into local php variable
    $userid      = $_SESSION['recid'];
    $username    = $_SESSION['name'];
    $school      = $_SESSION['college'];
    $payer_email = $_SESSION['payer_email'];
    $group1      = $_SESSION['group1'];
    $group2      = $_SESSION['group2'];
    $group3      = $_SESSION['group3'];
    $group4      = $_SESSION['group4'];
    $group5      = $_SESSION['group5'];
    $group6      = $_SESSION['group6'];

    
} else { ?>
<!-- make login box -->
<html>
<tr>
  <td>&nbsp;
    <p>&nbsp;
    <p>&nbsp;
    <p></td>
</tr>
<table style= border align="center" border="1" width="400" height="200">
    <td align="center" valign="center">You need to<a href="login_allocate_quiz.php">log in</a>as an administrator to<br />
      allocate quizzes to student groups.</td>
</table>
</html>
<?php exit(); 
}

    // Set error message as blank upon arrival to page
    $errorMsg = "";
    // Check to see if the form has been submitted 
    if (isset($_POST['equip'])){
    //Connect to the database through include 
    include_once "demo_conn.php";
    //set variables    
    $equip     = $_POST['equip'];
    $egroup1   = $_POST['egroup1'];
    $egroup2   = $_POST['egroup2'];
    $egroup3   = $_POST['egroup3'];
    $egroup4   = $_POST['egroup4'];
    $egroup5   = $_POST['egroup5'];
    $egroup6   = $_POST['egroup6'];
    
    //create variables to manipulate filenames in database
    $lowquip = strtolower($equip);
    $wordquip = str_replace (" ", "", $lowquip);
    $bigpic    = $wordquip.'big';
    $smallpic  = $wordquip.'small';
    $bigpic    = $bigpic.'.jpg';
    $smallpic = $smallpic.'.jpg';
    $errorMsg = '<font size="-1"><u>ERROR:</u>&nbsp;&nbsp;&nbsp;You have not entered the following required information.';
    $nogroup = ((!$egroup1) && (!$egroup2) && (!$egroup3) && (!$egroup4) && (!$egroup5) && (!$egroup6));
    $noequip = (!$equip);
    if ($nogroup)
        {$errorMsg .= "--- Student Group. (No data was forwarded to the database.)</font>";}
    else if($noequip)
        {$errorMsg .= "--- Quiz Name. (No data was forwarded to the database.)</font>";}
    else 
        {$query = mysql_query("SELECT equip FROM topics WHERE equip = '$equip' AND managerId = '$userid'");
              if (mysql_num_rows($query) > 0)
                mysql_query("UPDATE topics SET egroup1 = '$egroup1', egroup2 = '$egroup2', egroup3 = '$egroup3', egroup4 = '$egroup4', egroup5 = '$egroup5', egroup6 = '$egroup6' WHERE equip = '$equip' AND managerId = '$userid'");
            else
                mysql_query("INSERT INTO topics (managerId, equip, title, url_big, url_small, egroup1, egroup2, egroup3, egroup4, egroup5, egroup6) VALUES ('$userid','$wordquip', '$equip', '$bigpic', '$smallpic', '$egroup1', '$egroup2', '$egroup3', '$egroup4', '$egroup5', '$egroup6')") or die (mysql_error("error 1321"));            
        $URL='make_quiz_list_test4.php';
        header ('Location: '.$URL);
        }    
    }
?>
<!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" dir="ltr" lang="en-US" xml:lang="en">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8" />
<meta http-equiv="X-UA-Compatible" content="IE=EmulateIE7" />
<meta http-equiv="X-UA-Compatible" content="IE=4">
<!-- IE5 mode -->
<meta http-equiv="X-UA-Compatible" content="IE=7.5">
<!-- IE7 mode -->
<meta http-equiv="X-UA-Compatible" content="IE=100">
<!-- IE8 mode -->
<meta http-equiv="X-UA-Compatible" content="IE=a">
<!-- IE5 mode -->
<title>Manager selected quiz list</title>
<link rel="stylesheet" href="style.css" type="text/css" media="screen" />
<!--[if IE 6]><link rel="stylesheet" href="style.ie6.css" type="text/css" media="screen" /><![endif]-->
<!--[if IE 7]><link rel="stylesheet" href="style.ie7.css" type="text/css" media="screen" /><![endif]-->
<script type="text/javascript" src="script.js"></script>
</head>
<body>
<div id="art-page-background-simple-gradient">
  <div id="art-page-background-gradient"></div>
</div>
<div id="art-main">
  <div class="art-sheet">
    <div class="art-sheet-tl"></div>
    <div class="art-sheet-tr"></div>
    <div class="art-sheet-bl"></div>
    <div class="art-sheet-br"></div>
    <div class="art-sheet-tc"></div>
    <div class="art-sheet-bc"></div>
    <div class="art-sheet-cl"></div>
    <div class="art-sheet-cr"></div>
    <div class="art-sheet-cc"></div>
    <div class="art-sheet-body">
      <div class="art-header">
        <div class="art-header-png"></div>
        <div class="art-header-jpeg"></div>
        <div class="art-logo">
          <h1 id="name-text" class="art-logo-name"><a href="#">Safety Testing Online</a></h1>
          <div id="slogan-text" class="art-logo-text">Safety - The Most Valuable Insurance</div>
        </div>
      </div>
      <div class="art-nav">
        <div class="l"></div>
        <div class="r"></div>
        <div class="art-nav-center">
          <ul class="art-menu">
            <li> <a href="../../index.php" class="active"><span class="l"></span><span class="r"></span><span class="t">Home</span></a> </li>
            <li> <a href="../demo_main.php"><span class="l"></span><span class="r"></span><span class="t">Demonstrations Page</span></a>
              <ul>
              </ul>
            </li>
            <li> <a href="logout.php"><span class="l"></span><span class="r"></span><span class="t">Admin Logout</span></a> </li>
          </ul>
        </div>
      </div>
      <div class="art-content-layout">
        <div class="art-content-layout-row">
          <div class="art-layout-cell art-content">
            <div class="art-post">
              <div class="art-post-tl"></div>
              <div class="art-post-tr"></div>
              <div class="art-post-bl"></div>
              <div class="art-post-br"></div>
              <div class="art-post-tc"></div>
              <div class="art-post-bc"></div>
              <div class="art-post-cl"></div>
              <div class="art-post-cr"></div>
              <div class="art-post-cc"></div>
              <div class="art-post-body"></div>
              <div class="art-post-bl"></div>
              <div class="art-post-br"></div>
              <div class="art-post-tc"></div>
              <div class="art-post-bc"></div>
              <div class="art-post-cl"></div>
              <div class="art-post-cr"></div>
              <div class="art-post-cc"></div>
              <div class="art-post-body">
                <div class="art-post-inner art-article">
                  <table style="table-layout:fixed; width:850px;">
                    <tr>
                      <td style="text-align:left; width:30px;">&nbsp;</td>
                      <td style="text-align:left; width:350px;"><font size="+1">Allocation of Woodwork Quizzes to Groups.</font></td>
                      <td style="text-align:left; text-align:center; vertical-align:bottom; width:450px;"><font color="#0000FF">Administrator: <?php echo $username; ?> - <?php echo $school; ?>.</font></td>
                      <td style="text-align:left; width:20px;"></td>
                    </tr>
                  </table>
                  <table style="table-layout:fixed; width:850px;">
                    <tr>
                      <td style="text-align:left; width:30px;"></td>
                      <td style="text-align:left; vertical-align:bottom; width:800px;"><font color="#FF0000"><?php echo "$errorMsg"; ?></font></td>
                      <td style="text-align:left; width:20px;"></td>
                    </tr>
                  </table>
                  <table style="table-layout:fixed; border:thin; text-align:left; width:850px;">
                    <tr>
                      <td style="text-align:right; width:35px;"></td>
                      <td style="text-align:left; width:190px;"></td>
                      <td style="text-align:right; width:20px;"></td>
                      <td style="text-align:left; width:210px;"><font color="#FF0000"></font></td>
                      <td style="text-align:right; width:20px;"></td>
                      <td style="text-align:left; width:110px;"></td>
                      <td style="text-align:right; width:20px;"></td>
                      <td style="text-align:right; width:180px;"></td>
                      <td style="text-align:right; width:35px;"></td>
                    </tr>
                    <hr/>
                    <tr>
                      <td rowspan="12"></td>
                      <td rowspan="12">
                      <br/>
                      <form method="post" enctype="multipart/form-data" action="make_quiz_list_test4.php">
                        <!--<form method="post" action="< ?php echo $PHP_SELF;?>">-->
                        <select size="25" name="equip" />
                        
                        <option selected value="">No Quiz Selected</option>
                        <option value="Biscuit Jointer">Biscuit Jointer</option>
                        <option value="Dowelling Machine">Dowelling Machine</option>
                        <option value="Drill Cordless">Drill - Cordless</option>
                        <option value="Drill with Cord">Drill - Power Corded</option>
                        <option value="Pedestal Drill">Drill - Pedestal</option>
                        <option value="Edge Tool Sharpener">Edge Tool Sharpener</option>
                        <option value="General Workshop Safety">General Workshop Safety</option>
                        <option value="Pedestal Grinder">Grinder - Pedestal</option>
                        <option value="Hand Tools">Hand Tools</option>
                        <option value="Jointer">Jointer (fixed)</option>
                        <option value="Jointer Surfacer Combo">Jointer/Surfacer (combo)</option>
                        <option value="Shaper">Shaper (fixed)</option>
                        <option value="Lathe for Wood">Lathe - Wood</option>
                        <option value="Linisher">Linisher</option>
                        <option value="Mortiser with Hollow Chisel">Mortiser - Hollow Chisel</option>
                        <option value="Nailgun for Brads">Nailer - Air (brads)</option>
                        <option value="Planer Portable">Planer - (portable)</option>
                        <option value="Router Portable">Router - Plunge</option>
                        <option value="Router with Sliding Table">Router Table - Slide</option>
                        <option value="Sander Belt">Sander - Belt (fixed)</option>
                        <option value="Sander Disc Belt Combo">Sander - Belt/Disc Combo)</option>
                        <option value="Sander Portable Belt">Sander - Belt (portable)</option>
                        <option value="Sander Disc">Sander - Disc (fixed)</option>
                        <option value="Sander Orbital">Sander - Orbital</option>
                        <option value="Sander Random Orbit">Sander - Random Orbital</option>
                        <option value="Sander Bobbin">Sander - Vertical Spindle</option>
                        <option value="Saw Bandsaw">Saw - Bandsaw</option>
                        <option value="Saw Bench">Saw - Circular (bench)</option>
                        <option value="Saw Portable Circular">Saw - Circular (portable)</option>
                        <option value="Saw Drop or Chop">Saw - Drop (alt Chop)</option>
                        <option value="Saw Drop and Slide">Saw - Drop & Slide</option>
                        <option value="Jigsaw Portable">Saw - Jigsaw (portable)</option>
                        <option value="Saw Panel">Saw - Panel (fixed)</option>
                        <option value="Saw Radial Arm">Saw - Radial Arm</option>
                        <option value="Saw Sabre">Saw - Sabre(portable)</option>
                        <option value="Saw Scroll">Saw - Scroll</option>
                        <option value="Screw Driver Portable">Screwdriver - Portable</option>
                        <option value="Thicknesser">Thickness Planer</option>
                        </td>
                        <td>&nbsp;</td>
                        <td>&nbsp;</td>
                        <td>&nbsp;</td>
                        <td rowspan="7"><br />
                          <br />
                          <br />
                          <input type="checkbox" name="egroup1" value="1" />
                          <?php echo $group1; ?>
                          <p>
                            <input type="checkbox" name="egroup2" value="1" />
                            <?php echo $group2; ?>
                          <p>
                            <input type="checkbox" name="egroup3" value="1" />
                            <?php echo $group3; ?>
                          <p>
                            <input type="checkbox" name="egroup4" value="1" />
                            <?php echo $group4; ?>
                          <p>
                            <input type="checkbox" name="egroup5" value="1" />
                            <?php echo $group5; ?>
                          <p>
                            <input type="checkbox" name="egroup6" value="1" />
                            <?php echo $group6; ?>
                          <p>
                            <input type="submit" value="submit" name="Send Data">
                      </form>
                      </td>
                      <td></td>
                      <td></td>
                      <td></td>
                    </tr>
                    <tr>
                      <td></td>
                      <td style="border:solid; color:#006600; 1px; padding:10px; text-align:left;"><font size="-1">Select a Quiz Topic from the drop down list on the left. Then go to the check boxes on the right to select all of the groups that are expected to undertake this test.
                        <p>You can select only one quiz each time, but you can select from one to six groups to undertake that quiz.
                        <p>Repeat this process until you have allocated all of the tests that you require each group to complete.
                        <p>If you make a mistake you can delete a quiz allocation <a href="../../under_con.php">here</a> at any time. 
                        </font></td>
                      <td></td>
                      <td></td>
                      <td style="color:#006600;"><font size="-1">Go back to the <br />
                        <a href="member_account.php">main edit page</a>.<br/>
                        &nbsp;<br />
                        &nbsp;<br/>
                        &nbsp;<br/>
                        &nbsp;<br/>
                        &nbsp;<br/>
                        &nbsp;<br/>
                        &nbsp;<br/>
                        &nbsp;<br/>
                        &nbsp;<br/>
                        &nbsp;<br/>
                        &nbsp;<br/>
                        &nbsp;<br/>
                        &nbsp;<br/>
                        &nbsp;<br/>
                        &nbsp;<br/>
                        </font></td>
                    </tr>
                    <tr>
                      <td></td>
                      <td>&nbsp;<br/>
                        &nbsp;<br/>
                        &nbsp;<br/>
                        &nbsp;<br/></td>
                      <td></td>
                      <td></td>
                      <td></td>
                    </tr>
                  </table>
                  <!-- /article-content -->
                </div>
                <div class="cleared"></div>
              </div>
              <div class="cleared"></div>
            </div>
          </div>
        </div>
      </div>
    </div>
    <div class="cleared"></div>
    <div class="art-footer">
      <div class="art-footer-inner">
        <div class="art-footer-text">
          <p><a href="#">Contact Us</a> | <a href="#">Terms of Use</a> | <a href="#">Trademarks</a> | <a href="#">Privacy Statement</a><br />
            <?php 
 $time = time () ; 
 //This line gets the current time off the server
 $year= date("Y",$time); 
 //This line formats it to display just the year
 echo "Copyright &copy; 2010 - " . $year;
 //this line prints out the copyright date range, you need to edit 2010 to be your opening year
 ?>
            All Rights Reserved.</p>
        </div>
      </div>
      <div class="art-footer-background"></div>
    </div>
    <div class="cleared"></div>
  </div>
</div>
<div class="cleared"></div>
<p class="art-page-footer">Designed by Frank.</p>
</div>
</body>
</html>

Hi All,

I have an insert/update that i am using in several places across my site, it works fine everywhere apart from on one page.

I am clearly missing something but cant for the life of me work it out.

My php:

if ($_SERVER['REQUEST_METHOD']=='POST') {
    $jobId = $_SESSION['current_job_id'];
    $qty = $_POST['drinkItemQty'];
    // prepare insert query
    $stmt = $conn->prepare("INSERT INTO ssm_drink_order (drink_qty, job_id, drink_id) 
                            VALUES (?,?,?) 
                            ON DUPLICATE KEY UPDATE 
                            drink_qty = VALUES(drink_qty)"
                        ); 
    
    
    foreach ($_POST['drinkItemId'] as $k => $diid) {

        if ($qty[$k] > 0) {

            $stmt->bind_param("iii", $qty[$k], $jobId, $diid);

            $stmt->execute();
        }

        if ($qty[$k] < 1) {

            $stmt1 =$conn->prepare("DELETE FROM ssm_drink_order WHERE job_id = ?");
            $stmt1->bind_param('i', $jobId);
            $stmt1->execute();
        }
    }   
}

the page html

<tbody>
    <tr>
        <th style="width:70%;" class="text-center">Drink Item</th>
        <th class="text-center">Quantity</th>
    </tr>

    <tr>
        <td>
            House Gin
            <input name="drinkItemId[]" type="hidden" value="2">
        </td>
        <td class="text-center">
            <input name="drinkItemQty[]" type="number" value="999" class="text-center">
        </td>
    </tr>
    <tr>
        <td>
            House Brandy
            <input name="drinkItemId[]" type="hidden" value="4">
        </td>
        <td class="text-center">
            <input name="drinkItemQty[]" type="number" value="" class="text-center">
        </td>
    </tr>
    <tr>
        <td>
            House Vodka
            <input name="drinkItemId[]" type="hidden" value="1">
        </td>
        <td class="text-center">
            <input name="drinkItemQty[]" type="number" value="" class="text-center">
        </td>
    </tr>
    <tr>
        <td>
            House Whiskey
            <input name="drinkItemId[]" type="hidden" value="3">
        </td>
        <td class="text-center">
            <input name="drinkItemQty[]" type="number" value="" class="text-center">
        </td>
    </tr>
</tbody>

Any help is as ever greatly appreciated

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

Does anyone see anything wrong with the SQL?  This function keeps returning false.

Thank you for your time.

Code: [Select]
function insert_survey1($survey1_anwers) {
  // extract order_details out as variables
  extract($survey1_anwers);
 
  $username = $_SESSION['valid_user'];
  $conn = db_connect();

  // select user_id based on the entered data
  $query = "SELECT user_id FROM user WHERE
gender = '".$gender."',
birth_range = '".$birth_range."',
degree_year = '".$degree_year."'
username = '".$username."'";

  $result = $conn->query($query);

  //if the resulting user_id exists (AND has the POST data just entered, since the query must match those to return a row) ,
  if($result->num_rows>0) {
    //return the current row of the result set as an object and place it into user variable
    $user = $result->fetch_object();
//set variable for user_id to the fetched user object data representing the user_id int he db( because it was fetched from the sql select result)
    $user_id = $user->user_id;
//update the fields since the user exists already.
$query = "UPDATE user
SET gender = '".$gender."',
birth_range = '".$birth_range."',
degree_year = '".$degree_year."'
WHERE user_id = '".$user_id."'";

// $query = "UPDATE `alumni_survey`.`user`
// SET `gender` = '".$gender."',
// `birth_range` = '".$birth_range."',
// `degree_year` = '".$degree_year."'
// WHERE `user`.`user_id` = '".$user_id"'";
  } else {
//otherwise, if the user doesn't exist already insert this new data.
    $query = "INSERT INTO user (gender, birth_range, degree_year)
VALUES('".$gender."','".$birth_range."','".$degree_year."')
WHERE user_id = '".$user_id."'";
    $result = $conn->query($query);

    if (!$result) {
       return false;
    }
  }
 
  return $user_id;
}

Well, I made this yesterday then realised, I need to check is it exists...
I got this but when I go to accept the application and the member exists in the table it enters it anyway...

Code: [Select]
<?php
$member=$_POST['memberid'];
$status=$_POST['Status'];

$con = mysql_connect("host","user","pass");
if (!$con)
{
die('Could not connect: ' . mysql_error());
}
mysql_select_db("a2186214_hbclan",$con);
$sql="UPDATE application SET Status = '$status' WHERE ID = '$member'";
$sql1="INSERT INTO table_members(name) SELECT application.Name FROM application WHERE application.ID = '$member'";
if ($status == 'ACCEPTED')
{
if(mysql_num_rows(mysql_query("SELECT name FROM table_members WHERE name = '$member'")))
{
if(mysql_query($sql, $con) or die(mysql_error()))
{
echo 'Status Changed.<br /><a href="../applications.php">Return To Members List</a>';
}
else
{
die('Could not submit: ' . mysql_error());
}
}
else
{
if(mysql_query($sql, $con) or die(mysql_error()))
{
if(mysql_query($sql1, $con) or die(mysql_error()))
{
echo 'Status Changed.<br /><a href="../applications.php">Return To Members List</a>';
}
}
else
{
die('Could not submit: ' . mysql_error());
}
}
}
else
{
if(mysql_query($sql, $con) or die(mysql_error()))
{
echo 'Status Changed.<br /><a href="../applications.php">Return To Members List</a>';
}
else
{
die('Could not submit: ' . mysql_error());
}
}
mysql_close($con);

?>

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.