PHP - Upon Form Submit, If Record Exists Update It, Else Insert

Hi, I just want to know how to check if a row/record already exists for a given table, but this code gives me message in browser: Warning: mysql_num_rows() expects parameter 1 to be resource, boolean given in myTest.php

This is the the snippet I am running:
Code: [Select]
<?php
$connxn=mysql_connect("localhost","root");
$db=mysql_select_db("siliconvalley");
$toyNodePath="#document/siliconValleyHELLO";
$queryA=mysql_query("SElECT FROM pathexpress (path_express) WHERE path_express='$toyNodePath'");//make sure AT MOST ONE ROW EXISTS!!
if(mysql_num_rows($queryA)==1)
print "ALREADY IN table pathexpress!";
else {
mysql_query("INSERT INTO pathexpress (path_express) VALUES ('$toyNodePath')");
print "ADDED $toyNodePath to table pathexpress!";
}

?>
Please, any help is greatly appreciated!

Hi,

I am new to php and I desperately need help inserting an image into my php submit form.
The form works perfectly but I have no idea how to get an image to be shown when the recipeint fo the email receive it (would love to have my company logo at the top of the mail just after $message..
Below is my code :

....
// Create Mail Message and Send Mail
                  $to         = 'x@domain.coma';
                  $subject    = "Website Enquiry Received from www.domain.com";
                  
                  $message    =
                  "The following message has been sent from the website."  .
                  

                  
                  "\n" .
                  "\n" .
                  "Date Sent: " . date("j F Y") . "\n" .
                  "Date Sent: " . date("g:i a") . "\n" .
                  "\n" .
                  "From: $contactName $contactSurname" . "\n" .
                  "\n" .
                  "Their Contact & Personal Details" . "\n" .
                  "=====================" . "\n" .
                  "\n" .
                  "Marital Status: $contactStatus" . "\n" .
                  "Email: $contactEmail" . "\n" .
                  "Cellphone Number: $contactNumber" . "\n" .
                  "Address 1: $contactAddress1" . "\n" .
                  "Address 2: $contactAddress2" . "\n" .
                  "Suburb: $contactSuburb" . "\n" .
                  "Postal Code: $contactPostalcode" . "\n" .
                  "\n" .
                  "\n" .
                                    
                  $headers    = "From: $contactName $contactSurname <$contactEmail>" . "\r\n" .
                             'X-Mailer: PHP/' . phpversion();
                  
                  mail($to, $subject, $message, $headers);
                  mail($contactEmail, 'Confirmation of email: "' . $subject . '"', $message, $headers);
               
               // Thank You Message
               header('Refresh: 0; url=/quote_confirm.htm');               
               }
            }
            ?>

Hey Everyone, I want to start out by saying thanks in advance for reading this. Since I started working with the XAMPP package this community has been a great resource, though this is my first post.  most of my work has been modifying existing stuff in our network, this is my first project from scratch.

I am working on an access control project where I am storing site names and RFID tags in a table, and using PHP to check for existing records. Basically, I want to submit 2 credentials from a host (site and RFID), check if they exist together in the table, if so return TRUE or 1, if not return FALSE or 0. I am new to both PHP and MySQL (although I took a course years ago) so I am looking here for help.

On this server I have XAMPP installed and everything I need running. I have a table and created a few records for testing. My current trouble is getting PHP to return the proper values for the SQL query. The SQL query works fine, I think - it returns the number of rows that match and that record.  I'm not sure this is the result I need to be able to deal with the way I want.  Using other resources my current PHP statement looks like this:
Code: [Select]
if(mysql_num_rows(mysql_query("SELECT * FROM `users` WHERE 'site_name' LIKE 'berland' AND 'card_id' LIKE '290093C84E' LIMIT 0 , 30"))>0){echo '1';}
   else
   {echo '0';} So, my table has the entry as noted in this query above. Final one will be dynamic where the host will be sending those values - I will likely need help with that as well, but small steps first.;-) Anyway, I was playing around with the end statement >0{echo '1';} but wasn't able to make it do what I want.
Any help is appreciated. Thank you.

Aaron

The Script:

<form method="post" action="<?php echo $_SERVER['PHP_SELF'] ?>">
    <input type="text" name="hashtags" />
    <input type="submit" name="submit" />

</form>
<?php

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

    $hashtags = explode(", ", $_POST['hashtags']);

// Prints e.g.: Array ( [0] => #tag1 [1] => #tag2 [2] => #tag3 [3] => #tag4 )
    print_r($hashtags);
    
}

?>

This gets inserted into the input field:

#tag1, #tag2, #tag3, #tag4

I am looking to check if any of the hashtags inside the array already exist in the database, if it does not exists it should create the new ones in the table.   I know how to do this if all do not exists in the array and then it goes over to the MySQL query and inserts all of them.   My Question Is: How to insert only the ones which do not exists out of the array, so the ones which do exists do not get inserted again into the table?
Edited by glassfish, 14 October 2014 - 10:15 AM.

I'm having an issue updating a records. The insert and delete functions are working fine.
The $submit variable is being passed 'Update' ~ that is working.
This is some extremely old code that has migrated to a new server and is no longer working.

Code: [Select]
<?php
   $id = $_GET["id"];
   $delete = $_GET["submit"];
   $sortorder = $_POST["sortorder"];
   $name = $_POST["name"];
   $content = $_POST["content"];
   $submit = $_POST["submit"];
   
   require'../include/maindb.php';
   if($submit=="Submit") {
      $sql="INSERT INTO biography (id, sortorder, name, content) VALUES (NULL, '".$sortorder."', '".nl2br(addslashes(trim($name)))."', '".htmlentities(addslashes(trim($content)))."')";
   }
   if ($submit == "Update") {
       $sql="UPDATE biography SET sortorder='".$sortorder."', name='".nl2br(addslashes(trim($name)))."', content='".htmlentities(addslashes(trim($content)))."' WHERE id='".$id."'";
   }
   if ($delete=="Delete") {
      $sql="DELETE FROM biography WHERE id='".$id."'";
   }
   mysql_query($sql);
   echo(mysql_error());
   header('Location: index.php'); 

?>

Hi guys,

Doing a small project and i'm pretty new to php/mysql so hoping someone can help. Also i wasn't sure if this should be in php section or mysql, so apologises if it's in the wrong section.

Basically...

I have a form with a table in it with the fields (id, model, current stock level, new stock level)

The table is populated using a mysql query to get the data from 1 table in a database.

In the new stock column there's a simple text box to put a number in.

Sooo like

(ID)          (Model)          (current stock level)          (new stock level)
1              AAA                 3                                       [ ]
2              BBB                 1                                       [ ]
3              CCC                4                                       [ ]

A user will then put a new number in the 'new stock level' text box and when it gets submitted the new number replaces the number in 'current stock level'

Basically i know how to do it if it was just the one record, but how do i get it to update all the ones with numbers in the new stock level column at the same time, and ignore it if it doesn't have anything entered in the text box?


appreciate any help!

thanks!

Hi,

I have a simple mySQL database and I would like to update using a simple html form.
One of the field is "accepted" and  is type "boolean".
I have a texbox where I will write the record id and another button which will change the "accepted" value from 0 to 1 for that record id.
The problem is that I don't know how to start....

Thanks in advance

Sergio

My form has 40 fields, and I want to re-generate it to be reviewed as it was when submitted.  Next, I want to be able to UPDATE the forms values, where necessary.

Is there an easy way to UPDATE the entire form from the reviewable version.  Is it smarter to update ONLY the specific items that need modification?

Any examples would be helpful.

Hi there everyone,

I have the below code (needs to be sanitized for SQL injection - i know   ).  Submitting to a MYSQL database.  I wish to check on form submit if the users email address already exists, and if so display a simple error message (even just a windows error message) stating "the email address you have entered already exists".

I don't really know where to start with this, or what the code should look like, so any help and direction would be massively appreciated.  All i do know, is the email column is set to unique, and when i attempt to submit using an email i know exists the code appears to run successfully without spitting out any errors (i.e. the web url changes to the below php code) but the table doesn't update (which is correct).  I just don't know how to then return the user to the form (preferably with all their info still entered) when this happens along with a nice error message...

Kind regards,

Tom.

Code: [Select]
<?
$localhost="00.000.000.00";
$username="###";
$password="###";
$database="mfirst";

$firstname=$_POST['firstname'];
$surname=$_POST['surname'];
$dob="{$_POST['dobyear']}-{$_POST['dobmonth']}-{$_POST['dobday']}";

if (isset ($_POST['permissionnewsletter']) || (!empty ($_POST['permissionnewsletter'])))
{ $permissionnewsletter = "Yes"; }
else
{ $permissionnewsletter = "No"; }

$email=$_POST['email'];
$userpassword=$_POST['userpassword'];
$telephone=$_POST['telephone'];

mysql_connect($localhost,$username,$password);
@mysql_select_db($database) or die( "Unable to select database");

$insertintocustomerdetail = "INSERT INTO customerdetail VALUES (NULL,'$firstname','$surname','$dob','$permissionnewsletter','$email','$userpassword','$telephone',now())";
mysql_query($insertintocustomerdetail);

$addressline1=$_POST['addressline1'];
$addressline2=$_POST['addressline2'];
$cityortown=$_POST['cityortown'];
$county=$_POST['county'];
$postcode=$_POST['postcode']=strtoupper(@$_REQUEST['postcode']);

$insertintoaddresstable = "INSERT INTO addresstable VALUES (NULL,LAST_INSERT_ID(),'$addressline1','$addressline2','$cityortown','$county','$postcode',now())";
mysql_query($insertintoaddresstable);

mysql_close();
?>

hi i am trying to make a payroll calculator script that takes employee info, calculates pay, displays submitted info in a table, stores info in an array, and updates the array when new info is submitted. i have most of these accomplished, i am having trouble with the "store into an array, and update the array when new info is submitted" parts of the project. i am still not very fluent in php so there may be easier ways to achieve what i have so far. any pointers would be a great help, this part has got me stumped.

<?php
if(!isset($_SESSION))
{
session_start();
}
// UNCOMMENT NEXT LINE TO PRINT THE $_SESSION ARRAY TO THE SCREEN . . .
// echo '<pre>'; print_r($_SESSION); echo '</PRE>';
if(empty($_SESSION['userID']) || $_SESSION['authorized'] != true ) {



header("Location: login.php");



exit;
}
?>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Strict//EN"
"http://www.w3.org/TR/xhtml1/DTD/xhtml1-strict.dtd">
<html lang="EN" dir="ltr" xmlns="http://www.w3.org/1999/xhtml">
  <head>
    <meta http-equiv="content-type" content="text/xml; charset=utf-8" />
<meta http-equiv="refresh" content="5;url=editprofile.php">
    <title>Saving Profile</title>
  </head>

  <body>
<?php
require_once ("dbconn.php");
?>
<?php
$userID = $_SESSION['userID'];
$insert_query = 'insert into users WHERE userID='$userID'(
aim,
msn,
yim,
psnID,
xblGamertag,
otherContact
) 
values
(
"' . $_POST['aim'] . '", 
"' . $_POST['msn'] . '",
"' . $_POST['yim'] . '",
"' . $_POST['psnID'] . '",
"' . $_POST['xblGamertag'] . '",
"' . $_POST['otherContact'] . '"
)';

mysql_query($insert_query);

?>
Your profile has been saved!  You will now be redirected from where you came from.
<br /><a href="editprofile.php" title="Click here if you don't want to wait">Click here if you don't want to wait.</a>
  </body>
</html>

It creates a new record but I want it to update an existing one.  It's an editprofile script.

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


Thanks in advance

hi
my db table  has 2 field:

ID - Place
1     France
2     Germany

My form has 2 text field (printed with while cycle).

mysql_query("UPDATE mytable SET Place = '" . $_POST['place'] . "' WHERE ID=". $_POST['ID']." ");

This query doesn't work, because updates only the last record.

Where is wrong?

many thanks 

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

?>

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>