Learn VBA & Macros in 1 Week!

PHP - Check If Data Exist Before Insert Not Working

Full Excel VBA Course - Beginner to Expert

Check If Data Exist Before Insert Not Working	View Content

//database
create table mydata (
	id int(11) NOT NULL PRIMARY KEY AUTO_INCREMENT,
	fname varchar(20),	
    phoneno int(12) NOT NULL
    /*......*/
);
//class my data php

<?php

include('connect.php');
class InsertMydata {
    public function insertnow($fname, $phoneno) {
        $connect = new Connect;
        $insrt = $db -> prepare('INSERT INTO mydata (fname, phoneno) VALUES (?,?)');
		$insrt -> execute(array($fname, $phoneno));		
	}
}
?>


//insernow validate form

<?php
include('../classs/mydata.php');
//Declare data and error arrays
$errors = [];
$mydara = [];
if(!preg_match('/^[a-zA-Z]{4,15}$/', $_POST['fname'])) {
	$errors['fname'] = 'Enter full name!';
}
//this block not working even the phone exist
$connect = new Connect;
$phoneno = $_POST['phoneno'];
$checkiexist = $connect -> prepare('SELECT * FROM mydata WHERE phoneno = ?');
$checkiexist -> execute([$phoneno]);
if($checkiexist->rowCount() > 0) {
      $errors['phonenoexist'] = 'Try another phone number!';
 }
if(!empty($errors)){
      $data['success'] = false;
      $data['errors'] = $errors;
}else{
      $data['success'] = true;
      $data['message'] = 'success message!';  
      $mydata = new InsertMydata;
      $mydata -> insertnow($fname, $phoneno);
}
echo json_encode($data);

?>

//my ajax

$("#insertbtn").click( function(e) {
     var fname = $('#fname').val(),
         phoneno = $('#phoneno').val(),
           
       $.ajax({
           url: 'insertnow.php',
           type: 'POST',
           data: {fname:fname, phoneno:phoneno},
           dataType: "JSON",
           encode: true,
        }).done( function (data) {
         
         if (data.success == false) {
           if (data.errors.fname) {
                 $('#fname').append('<p class="text-danger">' + data.errors.fname + '</p>');
            } 
            if (data.errors.phonenoexist) {
              $('.card-header').append('<div class="alert alert-info alert-dismissible" role="alert">
                <button type="button" class="close" data-dismiss="alert" aria-label="Close"><span aria-hidden="true">×</span></button>'+data.errors.phonenoexist+'</div>');
            }
            } else {
             $('.card-header').append('<div class="alert alert-success alert-dismissible" role="alert"><button type="button" class="close" data-dismiss="alert" aria-label="Close"><span aria-hidden="true">×</span></button>'+data.message+'</div>');
        }
    });
       e.preventDefault();
    });


//the problem is, the code insert data even if the phone exist why?

the problem is, the code insert data even if the phone exist why?

Edited April 8 by mahenda

Full Excel VBA Course - Beginner to Expert

Update Data Where Id Exist , Insert If Not Exist Id

Similar Tutorials

View Content

i have error where my code should update existing data where id exist, it get updated ..but the others data is disappeared .only the data updated is remained

$sql1 ="select*from semakan_dokumen where email='$stdEmail'";
$sqlsearch1 = mysqli_query($dbconfig,$sql1);
$resultcount1 = mysqli_num_rows($sqlsearch1);

if($resultcount1 > 0){
$query1=("UPDATE  semakan_dokumen set student_id='$noMatrik', email= '$stdEmail', surat_tawaran='$fileName', ic='$fileName1',sijil_lahir='$fileName2',sijil_spm= '$fileName3',sijil_sekolah= '$fileName4', sijil_dip= '$fileName5',sej_julai='$fileName6',bm_julai='$fileName7',muet='$fileName8', mid1='$fileName9',yuran= '$fileName10',umpa_bend1= '$fileName11',umpa_bend2='$fileName12',bpkp='$fileName13', penaja='$fileName14',kesihatan= '$fileName15', jhepa='$fileName16' where email= '$stdEmail' ");

}else{


//filezip
$query1 = "INSERT INTO semakan_dokumen (email,surat_tawaran,ic,sijil_lahir,sijil_spm,sijil_sekolah,sijil_dip,sej_julai,bm_julai,muet,mid1,yuran,umpa_bend1,umpa_bend2,bpkp,penaja,kesihatan,jhepa) VALUES ('$stdEmail','$fileName','$fileName1','$fileName2','$fileName3','$fileName4','$fileName5','$fileName6','$fileName7','$fileName8','$fileName9','$fileName10','$fileName11','$fileName12','$fileName13','$fileName14','$fileName15','$fileName16')";
}

Check Existing Data Insert Into The Table?

Similar Tutorials

View Content

Hi guys, im inserting data into the table using drop-down list & multi select list,well it works very well. but i need to make sure i should not insert same StudentID & CourseID twice. here my code for you could anyone tell me pls where should i write code to check existing data?
<?php
$con = mysql_connect("localhost","root","");
if (!$con)
  {
  die('Could not connect: ' . mysql_error());
  }

  mysql_select_db("uni", $con)or trigger_error('MySQL error: ' . mysql_error());
$result  = mysql_query("SELECT * FROM student") or trigger_error('MySQL error: ' . mysql_error());

echo '<select name="sid">';

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

    echo '<option value="' . $row['StudentID'] . '">' . $row['StudentName'] . '</option>';
}

echo '</select>';

// ----------------

?>
</div>
<div class="style41" id="Layer7">

<?php
$result  = mysql_query("SELECT * FROM course") or trigger_error('MySQL error: ' . mysql_error());

echo '<select name ="cid[]" multiple="multiple" size="10">';

while($row = mysql_fetch_array($result))
{
    echo '<option value="' . $row['CourseID'] . '">' . $row['CourseName'] . '</option>';
}

echo '</select>';
mysql_close($con);
?>

------------------------------------
<?php

$con = mysql_connect("localhost","root","");
if (!$con)
  {
  die('Could not connect: ' . mysql_error());
  }

  mysql_select_db("uni", $con)or trigger_error('MySQL error: ' . mysql_error());

if (!empty($_POST['sid']) && !empty($_POST['cid']))
{
    $ct = 0;
    $student = $_POST['sid'];
    foreach ($_POST['cid'] as $key => $course)
    {
     $sql = "INSERT INTO take (StudentID, CourseID) VALUES('".mysql_real_escape_string($student)."',
'".mysql_real_escape_string($course)."')";
     $query = mysql_query($sql) or trigger_error('MySQL error: ' . mysql_error());
     if (mysql_affected_rows() > 0){$ct++;}
     }
    echo $ct . ' rows added.';
}

mysql_close($con);

?>

Check If Exist

Similar Tutorials

View Content

Gud pm!!
So i made this script to check if a username and password exist but it kinda fails me.
It gives me a database connection error from my confirm_query() which means it returned false?
so here's my code:

Code: [Select]
function check_if_exist($username, $password)
{
global $connection;
$query = "SELECT username, hashed_password";
$query .= "FROM users ";
$query .= "WHERE username = '$username' ";
$query .= "AND hashed_password = '$password' ";
$query .= " LIMIT 1";
$result_set = mysql_query($query, $connection);
confirm_query($result_set);
if(mysql_num_rows($result_set) == 1)
{
return true;
}
else
{
return false;
}
}

my confirm_query():

Code: [Select]
function confirm_query($result)
{
if(!$result)
{
die("Database connection failure ". mysql_error());
}
}

I have a another script to check if the email exist and it works perfectly, i dunno why this won't work properly..
maybe another simple mistake..
Any ideas or Violent reaction?
Thanks!

Check If Value Exist?

Similar Tutorials

View Content

Hi..

So what i want to do is basicly to check if id XX exist in my database.
How can this be done?

Im thinking of something like:

if(xx exist){do this}
else{do this}

Iv'e tried google etc before i posted here, but couldent really find anything where i found a soutable answer..

Hope someone can help! (:

Insert If Not Exist, Update If If It Does?

Similar Tutorials

View Content

I need to insert data into a table if it doesn't exist or update if it does.

Can someone give me an example of this code.

im using mySQL 5.1.42
im using phpMyAdmin 3.1.o

Check Whether Image Exist Or Not.

Similar Tutorials

View Content

Hello,

i want to check whether image exist or not, but i can't get any data about it. I have tried everything: getimagesize, file_exist, filesize, etc.

<?

$info = @getimagesize('http://jargames.eu/ic.php?lf=files/All phone/240x320/007-quantum_of_solace_240x320.jar');
if(isset($info['mime'])){echo 'Image exist';}
else{echo 'Image doesnt exist';}

?>
Ty, for your help.

Check If Rows Exist

Similar Tutorials

View Content

Is it possible to check if multiple rows exist at the same time. For example, if a row with the id "1" and another row with id "2" exists, and return something like true then false if only the first exists? I have a file that provides tens of thousands to check and it takes forever. I know this sounds bad off the start, but it's not something that is run normally. Only to update my database with new additions. Is there any good way to check a lot at once? I know you can insert many at a time and save a lot of time.

Check If Person_id Already Exist In The Table

Similar Tutorials

View Content

Hi! I wrote a small function that check if person_id already exist in the table called persons_web_tbl. If the person_id exist I get a message otherwise I add twitter/facebook profile of that person. I'm just trying to prevent duplicated entries this way. I will get person_id from table person_tbl, where are all people saved. The function actually works, I'm just curious if I'm on the right path. Thanks!

$person_id = 11;
class test extends dbh{

public function personExist($person_id) {

$sql = "SELECT person_id FROM persons_web_tbl WHERE person_id = ?";
 
	$stmt = $this->conn->prepare($sql);
	$stmt->execute([$person_id]);
	$row = $stmt->fetchColumn();
			
		if ($row > 0){

			echo "found";

		}else {

			$person_web_twitter = "add something";

			$sql = "INSERT INTO persons_web_tbl (person_web_twitter, person_id) VALUES (?, ?)";
			$stmt = $this->conn->prepare($sql);
			$stmt->execute([$person_web_twitter, $person_id]);
			
		}

	 }
}



$person = new test ();
$person = $person->personExist($person_id);

Edited February 15, 2020 by mactron

Check If A File Is Exist In Folder

Similar Tutorials

View Content

Hi everyone, I'm still learning, but getting intermediate in PHP now, but it is still challenge to learn. I'm trying to have php check to see if one file inside folder in server, seem I could not get it right, but I tested it on other site, it works, but not this script, I don't understand why it won't work...maybe logical is wrong?

here my code:

	if ($_POST['video']) {
	        $path1 = "UPLOADS/Home/";
        $path2 = "UPLOADS/Breakfast/";
        $path3 = "UPLOADS/Spider/";
	        $scan1 = scandir($path1);
        $scan2 = scandir($path2);
        $scan3 = scandir($path3);
	        $count1 = count($scan1) - 3;
        $count2 = count($scan2) - 3;
        $count3 = count($scan3) - 3;
	        if($count1 > 0) {
            header('location:exist.html');
        }elseif ($count2 > 0) {
            header('location:exist.html');
        }elseif ($count3 > 0) {
            header('location:exist.html');
        }

But other site, it works:

	$scan = scandir($path);
$count = count($scan) - 3;
	echo $count;
	if($count > 1){
    echo "Hello yourself!<br />";
}

Anyone will help will be appreciate! Thank you!

Gary

Edited April 3, 2019 by sigmahokies

Check If A List Of Directories Exist From Array()

Similar Tutorials

View Content

Code: [Select]
$arr = array('../', 'j/', 'AcidBB/', 'fileBOMB/', 'OurHome', 'up');
foreach ($arr as $value) {
// echo "Value: $value<br /><br />";
if (is_dir($value)) {
echo "<tr> <td>{$value}</td> <td><font color='#66FF33'>Exists</font></td></tr><br />";
} else {
echo "<tr> <td>{$value}</td> <td><font color='#FF0000'>Does Not Exist</font></td></tr><br />";
}
}
~~~ Solved after posting. Sorry. ~~~
Ok i have an Array of directories i need to check before the script installs itself, I know how to check for directories but i dont know how to scan each array in the list without calling each one seperately in Code: [Select]
If() { } Else If { } Else If { } And so on and so on... My Question is, If a For Statement is neaded, How would i go about checking each string in the Array List?

Check If Firstname And Lastname Exist Before Inserting Records

Similar Tutorials

View Content

I have a customer registration form up and running, the form allows customers to complete the forms and the data is then inserted into mysql db table via php form. I want to prevent duplicates records from already existing customers from creating a new records instead I want the customers to update their existing records in the backend. That is allow them to complete the form as normal, once they hit the submit button, the code should check if the customer first name and last name is already in the database if yes then it should update their records and if not it should insert new record to the table.

I do not want to alert the customer that their records already exist. I do not know where to start. Please help

Thank you so much in advance for your help.

How To Check If Multiple Arrays Exist Inside An Array Or Not

Similar Tutorials

View Content

As the title says, how can i check if multiple arrays exist inside an array or not?

Any help is greatly appreciated!

Update Users Email Check If New Email Address Exist Expect For Current Email

Similar Tutorials

View Content

i wanting users to be able to update there email address and check to see if the new email already exists. if the email is the same as current email ignore the check.
i have no errors showing up but if I enter a email already in the db it still accepts the new email instead of bringing the back the error message.
Code: [Select]
// email enterd from form //
$email=$_POST['email'];

$queryuser=mysql_query("SELECT * FROM members WHERE inv='$ivn' ") or die (mysql_error());
while($info = mysql_fetch_array( $queryuser )) {
$check=$info['email'];
// gets current email //
}

if($check!=$email){
// if check not equal to $email check the new email address already exists//
$queryuser=mysql_query("SELECT * FROM members WHERE email='$email' ");
//$result=mysql_query($sql);
$checkuser=mysql_num_rows($queryuser);
if($checkuser != 0)
{
$error= "0";
header('LOCATION:../pages/myprofile.php?id='.$error.'');

}
}

cheers

How To Check Before Insert With Xml

Similar Tutorials

View Content

Hello PHP World,
I don't have access to the database yet for the project I am working on so I created a work around until I get full access to the mysql database.

I Code: [Select]
<?php

$xml_file = "affiliate.xml";

// OPEN XML FILE ######################################################

if(!$xml=simplexml_load_file($xml_file)){
    trigger_error('Error reading XML file',E_affiliate_ERROR);
}
if(!empty($_GET['add'])){


$u_name = stripslashes($_POST['name']);
$u_company = stripslashes($_POST['company']);
$u_address = stripslashes($_POST['address']);
$u_city = stripslashes($_POST['city']);
$u_state = stripslashes($_POST['state']);
$u_phone = stripslashes($_POST['phone']);
$u_email = stripslashes($_POST['email']);
$u_desc = stripslashes($_POST['description']);
$u_region = stripslashes($_POST['region']);

// Generate new (appended) ID

foreach($xml as $affiliate){
    $last_id = $affiliate->uid;
}

$id = $last_id+1;

// Add node

$x = $xml->addChild("affiliate");
$x->addChild("uid",$id);
$x->addChild("name",$u_name);
$x->addChild("company",$u_company);
$x->addChild("address",$u_address);
$x->addChild("city",$u_city);
$x->addChild("state",$u_state);
$x->addChild("phone",$u_phone);
$x->addChild("email",$u_email);
$x->addChild("description",$u_desc);
$x->addChild("region",$u_region);

$xml->asXML($xml_file);

}
?>

html form

Code: [Select]
<br />
<br />

<h1>Affiliate </h1>

<form name="xml_writing" method="post" action="?add=t">
<table width="393">
<tr><td width="56">
Name:<br /></td><td width="206">
<input type="text" name="name" width="150"/></td>
<td>Region:</td>
<td><select name="region" value="options">
<option value="resellerNE">NorthEast</option>
<option value="resellerSE">SouthEast</option>
<option value="resellerC">Central</option>
<option value="resellerNE">NorthWest</option>
<option value="resellerNE">SouthWest</option>
<option value="resellerNE">International</option>
</select></td>
</tr>
<tr>
<td>
Company:<br /></td><td>
<input type="text" name="company" width="150" /></td>
</tr>
<tr><td>
Address:<br /></td><td>
<input type="text" name="address" width="150"/></td>
</tr>
<tr><td height="45">
City:<br /></td><td>
<input type="text" name="city" width="150"/></td>
<tr><td>
State:<br /></td><td>
<input type="text" name="state" width="150"/></td>
<tr><td>
Phone:<br /></td><td>
<input type="text" name="phone" width="150"/></td>
<tr><td>
Email:<br /></td><td>
<input type="text" name="email" width="150"/></td>
</tr>

<tr><td colspan="2">
Short description of yourself, your practice, your services, and other information of interest to potential clients or collaborators.<br /></td>
<tr><td colspan="2">
<textarea name="description" style="width: 406px; height: 136px;"></textarea></td>
</tr>
<tr><td></td><td>
<input type="submit" value="Submit" /></td>
</tr>
</table></form>

What I am trying to do is have on submit check against the email node in the xml file to see if email exist.
if exist string already a member else insert.

if you can help with code or point to something that will help.

"Everyone needs a mentor to lead them into success."
Quote by Shelby Poston

Unable To Insert The Data Into Data Base

Similar Tutorials

View Content

Hi Team,

I have a php page where I have taken the same userid and linked in the next page and also used show/hide function.

I am able to see that the userid is linking but when i submit the data is not getting insert and also no error

Please help

below is the Tower.php file.

Code: [Select]
<!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=iso-8859-1" />
<title>BHP2</title>
<style type="text/css">

</style>
</head>

<body>

<div id="Layer1">
<form id="form5" name="form5" method="link" action="Insert.php">
<div id="Layer2">
<div id="Layer6"><img src="AZimages/BHP-Billiton-logo.jpg" width="235" height="65" alt="BHP" /></div>
<h1 align="center"> </h1>
<div class="style1" id="Layer4">
<h1 align="center" class="style2">BHP DATA TRACKER </h1>
</div>
</div>
<div id="Layer7">
<div align="center"><span class="style4">SELECT THE TOWER BELOW </span>
<div id="Layer13">

<input type="hidden" name="empid" value="<?php echo $_GET['id']; ?>" size="20">
<input type="hidden" name="date" value="<?php echo date("Y-m-d H:i:s"); ?>" >
<input type="submit" name="B1" value="Start !" />

</div>
<div id="Layer12">
<div align="left">

<input name="rad1" type="radio" value="RF" id="rad1" />
<label >RF</label>

</div>
</div>
<div id="Layer11">
<div align="left">
<input name="rad1" type="radio" value="ISAP" id="rad1" />
<label >ISAP</label>

</div>
</div>
<div id="Layer10">
<div align="left">
<input name="rad1" type="radio" value="GSD" id="rad1" checked="checked" />
<label >GSD</label>

</div>
</div>
<div id="Layer9">
<div align="left">
<input name="rad1" type="radio" id="rad1" value="CSD" />
<label>CSD</label>
</p>
</div>
</div>
<br />
</div>
</div>
</form>
</div>
</body>
</html>

Below is the insert.php

<!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">
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1" />
<title>BHP DATA SUMBIT</title>
<?php
include ("count.php");
?>

<?php
if(isset($_GET['action']))
{
$action = $_GET['action'];
if ($action = 'yes')
{
include ("Connection.php");
$PName = $_POST['rad11'];
$Date = date("Y-m-d H:i:s");
$empidno = $_POST['idd'];
$qsdate = $_POST['testinput'];
$cb1 = $_POST['chkbox1'];
$cb2 = $_POST['chkbox2'];
$cb3 = $_POST['chkbox3'];
$cb4 = $_POST['chkbox4'];
$cb5 = $_POST['chkbox5'];
$Com = $_POST['textfield2'];
$dd1 = $_POST['textfield'];
$dd2 = $_POST['select'];
$dd3 = $_POST['select2'];
$dd4 = $_POST['textfield4'];
$dd5 = $_POST['textfield3'];
$dd6 = $_POST['select3'];
$sev = $_POST['radio1'];
$olddate = $_POST['odate'];
$pname = $_POST['radiobutton'];

$query="INSERT INTO bhp ticketinformation (`userid`,
`processname`,
`begindate`,
`dateposted`,
`CALL`,
`EMAIL`,
`NEW`,
`EXISTING`,
`Piroty`,
`MTICKET`,
`Services`,
`group1`,
`group2`,
`Icall`,
`Tcreatedtime`,
`comment`)
VALUES ( '$empidno' , '$pname' , '$olddate' , '$Date' , '$cb1' , '$cb2' , '$cb3' , '$cb4' , '$sev' , '$dd1' , '$dd2' , '$dd3' , '$dd4' , '$dd5' , '$dd6' , '$Com')";
mysql_query($query);
Header('location:tower.php?id=' . $empidno);
}
}
?>
<head>
<style type="text/css">

</style>

<script language="JavaScript" >
function showInfo()
{
var elem = document.getElementById('verify');
if(document.testform.select3.value == "verify" || document.testform.select3.value == "verify1" )
{
elem.style.display="inline";
}
else
{
elem.style.display="none";
}
}
</script>

<script language="JavaScript">

function validator()
{
if(document.testform.Checkbox1.checked == false &&
document.testform.Checkbox2.checked == false &&
document.testform.Checkbox3.checked == false &&
document.testform.Checkbox4.checked == false)
{
alert ('You did not choose any of the checkboxes!');
return false;
}
if (document.testform.textfield.value =="")
{
alert("Enter Max Ticket No");
return false;
}
if (document.testform.select.value == "" || document.testform.select.value == "SELECT SERVICE DROP DOWN")
{
alert ('Select the SELECT SERVICE DROP DOWN');
return false;
}
if (document.testform.select2.value == "" || document.testform.select2.value == "SELECT RG GROUP")
{
alert ('SELECT RG GROUP');
return false;
}
if (document.testform.select3.value == "" || document.testform.select3.value == "SELECT GROUPS")
{
alert ('SELECT GROUPS');
return false;
}
if (document.testform.textfield2.value =="")
{
alert("Comments Feild is Empty.If there are no Comment then type NA(Not Applicable)");
return false;
}
if (document.testform.Checkbox1.checked == false)
document.getElementById("chkbox1").value = "";
else
document.getElementById("chkbox1").value = "EMAIL";
if (document.testform.Checkbox2.checked == false)
document.getElementById("chkbox2").value = "";
else
document.getElementById("chkbox2").value = "NEW";
if (document.testform.Checkbox3.checked == false)
document.getElementById("chkbox3").value = "";
else
document.getElementById("chkbox3").value = "EXISTING";
if (document.testform.Checkbox4.checked == false)
document.getElementById("chkbox4").value = "";
else
document.getElementById("chkbox4").value = "CALL";
alert('Record has been posted in the portal');
}
</script>
</head>

<body>
<div id="Layer1">
<div id="Layer2">
<div id="Layer6"><img src="AZimages/BHP-Billiton-logo.jpg" width="235" height="67" alt="BHP" /></div>
<h1 align="center"> </h1>
<div class="style1" id="Layer4">
<h1 align="center" class="style2">BHP DATA TRACKER </h1>
</div>
</div>
<div id="Layer7">

<form method="POST" action="Insert.php?action=yes&&id=<?php echo $_GET['empid']; ?>" name="testform" onSubmit="return validator();">

<div id="Layer8">

<input type="checkbox" id="Checkbox4" name="checkbox4" value="CALL" />
CALL</label>

</div>
<div id="Layer9">

<label>
<input type="checkbox" id="Checkbox1" name="checkbox1" value="EMAIL" />
EMAIL</label>

</div>
<div id="Layer10">

<label>
<input type="checkbox" id="Checkbox2" name="checkbox2" value="NEW" />
NEW</label>

</div>
<div id="Layer11">

<label>
<input type="checkbox" id="Checkbox3" name="checkbox3" value="EXISTING" />
EXISTING</label>

</div>
<div id="Layer12">

<label>
<input name="radio1" type="radio" id="radio1" value="P1" checked="checked" />
P1</label>

</div>
<div id="Layer13">

<label>
<input name="radio1" type="radio" id="radio1" value="P2" />
P2</label>

</div>
<div id="Layer14">

<label>
<input name="radio1" type="radio" id="radio1" value="P3" />
P3</label>

</div>
<div id="Layer15">

<label>
<input name="radio1" type="radio" id="radio1" value="P4" />
P4</label>

</div>
<div id="Layer16">

<label>MAXIMUM TICKET
<input type="text" name="textfield" />
</label>

</div>
<div id="Layer17">

<label>SERVICE DROP DOWN
<select name="select" style="width: 162px; height: 23px">
<option>SELECT SERVICE DROP DOWN</option>
<option>OTHER(FW)</option>
<option>1 MESSAGE</option>
<option>1 MOBILITY</option>
<option>1 VOICE</option>
<option>1 SAP</option>
<option>1 PORTAL</option>
<option>1 COLLAB</option>
<option>1 GSAP</option>
<option>1 SECURITY</option>
<option>1 WAN</option>
<option>S DOMAIN</option>
<option>1 AUTH</option>
<option>1 DOCM</option>
<option>1 REMOTE</option>
</select>
</label>

</div>
<div id="Layer18">

<label>RG GROUP
<select name="select2" style="width: 162px; height: 23px">
<option>SELECT RG GROUP</option>
<option>I-AM-AU-AM-HWT</option>
<option>I-EUS-IN-CSC-DSK-CSD</option>
<option>I-EUS-IN-CSC-DSK-GSD</option>
<option>I-EUS-GB-DCS-BHPVICFW</option>
<option>I-ITS-AU-HW</option>
<option>I-SRM-AU-IAM-LAMU</option>
<option>I-ITS-AU-SW</option>
<option>C-BHP-AU-CSC-LSD-NONBRG</option>
<option>C-BHP-AU-ACN-AQM</option>
</select>
</label>

</div>
</div>
<div id="Layer19">

<label>SELECT GROUPS
<select name="select3" onchange="showInfo()" style="width: 162px; height: 23px">
<option value="none" >SELECT GROUPS</option>
<option value="verify">TP</option>
<option value="verify1">OA</option>
<option>OC</option>
<option>OTHERS</option>
</select>
</label>
<div id="verify" style="display:none;">

<br/><br/>
<label>INCOMING CALL/EMAIL TIME
<input type="text" name="textfield4" />
</label>
<br/><br/>
<label>MAXIMO TICKET CREATED TIME
<input type="text" name="textfield3" />
</label>
</div>

<div id="Layer24">

<label>COMMENTS
<input type="text" name="textfield2" />
</label>

</div>
<div id="Layer26">

<input name="Reset" type="reset" id="Reset" value="Reset" />

</div>
<div id="Layer25">
<input type="submit" name="Submit" value="Submit" />
<input type="hidden" name="chkbox1" id="chkbox1" />
<input type="hidden" name="chkbox2" id="chkbox2" />
<input type="hidden" name="chkbox3" id="chkbox3" />
<input type="hidden" name="chkbox4" id="chkbox4" />
<input type="hidden" name="chkbox5" id="chkbox5" />
<input type="hidden" name="rad11" id="rad11" value="<?php echo $_GET['rad1']; ?>" />
<input type="hidden" name="idd" id="idd" value="<?php echo $_GET['empid']; ?>" />
<input type="hidden" name="odate" id="odate" value="<?php echo $_GET['date']; ?>" />
</form>

</div>
</div>
</div>
</body>
</html>

THANKS IN ADVANCED

Insert Data To Database Where Data From While Loop

Similar Tutorials

View Content

Hi..

Sorry, if I need to repost my problem in while loop. cause until now I can't resolve my problem in saving all data from while loop.

I have this code StockRequisition.php where FORM was displayed.

<?php
   error_reporting(0);
   date_default_timezone_set("Asia/Singapore"); //set the time zone
$con = mysql_connect('localhost', 'root','');

if (!$con) {
    echo 'failed';
    die();
}

mysql_select_db("mes", $con);
$sr_date =date('Y-m-d H:i:s');

        $sql = "SELECT sr_number FROM stock_requisition ORDER BY sr_date DESC LIMIT 1";
        $result = mysql_query($sql, $con);

        if (!$result) {
            echo 'failed';
            die();
        }
        $total = mysql_num_rows($result);
        if ($total <= 0) {
            $currentSRNum = 1;
            $currentYear  = (int)(date('y'));
            $currentMonth = (int)(date('m'));
            $currentDay = (int)(date('d'));

            $currentSRYMD = substr($row['sr_number'], 0, 6);
            $currentYMD = date("ymd");
            if ($currentYMD > $currentSRYMD)
            {
                $currentSRNum = 1;
            }
            else
            {
                $currentSRNum += 1;
            }

        }
        else {
//------------------------------------------------------------------------------------------------------------------
            // Stock Number iteration....
            $row = mysql_fetch_assoc($result);

            $currentSRNum = (int)(substr($row['sr_number'],0,3));

            $currentSRYear  = (int)(substr($row['sr_number'],2,2));
            $currentSRMonth = (int)(substr($row['sr_number'],0,2));
            $currentSRNum = (int)(substr($row['sr_number'],6,4));
            $currentYear  = (int)(date('y'));
            $currentMonth = (int)(date('m'));
            $currentDay = (int)(date('d'));

            $currentSRYMD = substr($row['sr_number'], 0, 6);
            $currentYMD = date("ymd");
            if ($currentYMD > $currentSRYMD)
            {
                $currentSRNum = 1;
            }
            else
            {
                $currentSRNum += 1;
            }
        }
//------------------------------------------------------------------------------------------------------------------
        $yearMonth = date('ymd');
        $currentSR = $currentYMD . sprintf("%04d", $currentSRNum);
?>
<html>
<title>Stock Requisition</title>
<head>
<link rel="stylesheet" type="text/css" href="kanban.css">

<script type="text/javascript">
function save_sr(){
    var sr_date = document.getElementById("sr_date").value;
    var sr_number = document.getElementById("sr_number").value;
    var Items1 = document.getElementById("Items1").value;
    var SubItems = document.getElementById("SubItems").value;
    var ItemCode = document.getElementById("ItemCode").value;
    var DemandedQty = document.getElementById("DemandedQty").value;
    var UoM = document.getElementById("UoM").value;
    var Class = document.getElementById("Class").value;
    var Description = document.getElementById("Description").value;
    var BINLocation = document.getElementById("BINLocation").value;
    var RequestedBy = document.getElementById("RequestedBy").value;
    var ApprovedBy = document.getElementById("ApprovedBy").value;
    var ReceivedBy = document.getElementById("ReceivedBy").value;
    var IssuedBy = document.getElementById("IssuedBy").value;

    document.stock_requisition.action="StockRequisitionSave.php?sr_date="+sr_date+"&sr_number="+sr_number+"&Items1="+Items1+
    "&SubItems="+SubItems+"&ItemCode="+ItemCode+"&DemandedQty="+DemandedQty+"&UoM="+UoM+"&Class="+Class+"&Description="+
    Description+"&BINLocation="+BINLocation+"&RequestedBy="+RequestedBy+"&ApprovedBy="+ApprovedBy+"&ReceivedBy="+ReceivedBy+
    "&IssuedBy="+IssuedBy;
    document.stock_requisition.submit();
    alert("Stock Requisition data save.");
    window.location = "StockRequisition.php";
}
</script>
</head>
<body>
<form name="stock_requisition" action="<?php echo $_SERVER['PHP_SELF']; ?>" method="post">
<div id="ddcolortabs">
<ul>
<li> <a href="ParameterSettings.php" title="Parameter Settings"><span>Parameter Settings</span></a></li>
<li style="margin-left: 1px"><a href="kanban_report.php" title="WIP Report"><span>Wip Report</span></a></li>
<li><a href="fsn.php" title="Finished Stock Note"><span>WMS FG</span></a></li>
<li id="current"><a href="StockRequisition.php" title="WMS RM"><span>WMS RM</span></a></li>

</ul>
</div>

<div id="ddcolortabs1">
<ul>
<li><a href="ReceivingMaterials.php" title="Receiving Materials"><span>Receiving Materials</span></a></li>
<li><a href="Shelving.php" title="Shelving"><span>Shelving</span></a></li>
<li id="current"><a href="StockRequisition.php" title="Stock Requisition"><span>Stock Requisition</span></a></li>
</ul>
</div>

<div id="SR_date">
<label>Date :</label>
<input type="text" name="sr_date" value="<?php echo $sr_date; ?>" size="16" readonly="readonly" style="border: none;">
</div>
<div id="SR_number">
<label>SR# :</label>
<input type="text" name="sr_number" value="<?php echo $currentSR; ?>" size="10" readonly="readonly" style="font-weight: bold; border: none;">
<br/>
</div>
   <div>
<table>
<thead>
<th>Items</th>
<th>Sub Items</th>
<th>Item Code</th>
<th>Demanded Qty</th>
<th>UoM</th>
<th>Class</th>
<th>Description</th>
<th>BIN Location</th>
</thead>
<?php
$sql = "SELECT DISTINCT Items FROM bom_subitems ORDER BY Items";
$res_bom = mysql_query($sql, $con);

while($row = mysql_fetch_assoc($res_bom)){

    $Items = $row['Items'];
echo "<tr>
        <td style='border: none;font-weight: bold;'> <input type='name' value='$Items' name='Items' id='Items' readonly = 'readonly' style = 'border:none;width:auto;font-family: Arial, Helvetica, sans-serif;font-size: 1em;' size='5'></td>
        </tr>";

$sql = "SELECT Items, SubItems, ItemCode, UoM, Class, Description, BINLocation FROM bom_subitems WHERE Items = '$Items' ORDER BY Items"or die(mysql_error());

$res_sub = mysql_query($sql, $con);

while($row_sub = mysql_fetch_assoc($res_sub)){

     $Items1 = $row_sub['Items'];
     $SubItems = $row_sub['SubItems'];
     $ItemCode = $row_sub['ItemCode'];
     $UoM = $row_sub['UoM'];
     $Class = $row_sub['Class'];
     $Description = $row_sub['Description'];
     $BINLocation = $row_sub['BINLocation'];

    echo "<tr>
        <td style='border: none;'> <input type='hidden' value='$Items1' id='Items1' name='Items1'></td>
        <td style='border: none;'> <input type='text' name='SubItems' value='$SubItems' id='SubItems' readonly='readonly' style='border:none; width:auto;font-family: Arial, Helvetica, sans-serif;font-size: 1em;' size='10'></td>
        <td style='border: none;'> <input type='text' name='ItemCode' value='$ItemCode' id='ItemCode' readonly='readonly' style='border:none; width:auto;font-family: Arial, Helvetica, sans-serif;font-size: 1em;' size='10'></td>
        <td style='border: none;'><center><input type='text' name='DemandedQty' id='DemandedQty' value='' size='7'></center></td>
        <td style='border: none;' size='3'> <input type='text' name='UoM' value='$UoM' id='UoM' readonly='readonly' style='border:none; width:auto;font-family: Arial, Helvetica, sans-serif;font-size: 1em;' size='3'></td>
        <td style='border: none;'> <input type='text' name='Class' value='$Class' id='Class' readonly='readonly' style='border:none; width:auto;font-family: Arial, Helvetica, sans-serif;font-size: 1em;' size='10'></td>
        <td style='border: none;'> <input type='text' name='Description' value='$Description' id='Description' readonly='readonly' style='border:none; width:auto;font-family: Arial, Helvetica, sans-serif;font-size: 1em;' size='10'></td>
        <td style='border: none;'> <input type='text' name='BINLocation' value='$BINLocation' id='BINLocation' readonly='readonly' style='border:none; width:auto;font-family: Arial, Helvetica, sans-serif;font-size: 1em;' size='10'></td>
        </tr>";
}
}


?>
</table>
</div>
<?php
   $RequestedBy = array('AAA', 'BBB', 'CCC', 'DDD');

   $ApprovedBy = array('EEE', 'FFF', 'GGG', 'HHH');

   $ReceivedBy = array('III', 'JJJ', 'KKK', 'LLL');

   $IssuedBy = array('MMM', 'NNN', 'OOO', 'PPP');

?>

<div id='Requested_By'>
<label>Requested By:</label>
<select name="RequestedBy">
<option value="Select">Select</option>
<option value="AAA" <?php if($_POST['RequestedBy'] == 'AAA') echo "selected='selected'"; ?>>AAA</option>
  <option value="BBB" <?php if($_POST['RequestedBy'] == 'BBB') echo "selected='selected'"; ?>>BBB</option>
<option value="CCC" <?php if($_POST['RequestedBy'] == 'CCC') echo "selected='selected'"; ?>>CCC</option>
  <option value="DDD" <?php if($_POST['RequestedBy'] == 'DDD') echo "selected='selected'"; ?>>DDD</option>
</select>
</div>

<div id='Approved_By'>
<label>Approved By:</label>
<select name="ApprovedBy">
<option name='Select'>Select</option>
<option value="EEE" <?php if($_POST['ApprovedBy'] == 'EEE') echo "selected='selected'"; ?>>EEE</option>
  <option value="FFF" <?php if($_POST['ApprovedBy'] == 'FFF') echo "selected='selected'"; ?>>FFF</option>
<option value="GGG" <?php if($_POST['ApprovedBy'] == 'GGG') echo "selected='selected'"; ?>>GGG</option>
  <option value="HHH" <?php if($_POST['ApprovedBy'] == 'HHH') echo "selected='selected'"; ?>>HHH</option>
</select>
</div>

<div id='Received_By'>
<label>Issued By:</label>
<select name="IssuedBy">
<option name='Select'>Select</option>
<option value="III" <?php if($_POST['ReceivedBy'] == 'III') echo "selected='selected'"; ?>>III</option>
  <option value="JJJ" <?php if($_POST['ReceivedBy'] == 'JJJ') echo "selected='selected'"; ?>>JJJ</option>
<option value="KKK" <?php if($_POST['ReceivedBy'] == 'KKK') echo "selected='selected'"; ?>>KKK</option>
  <option value="LLL" <?php if($_POST['ReceivedBy'] == 'LLL') echo "selected='selected'"; ?>>LLL</option>

</select>
</div>

<div id='Issued_By'>
<label>Received By:</label>
<select name="ReceivedBy">
<option name='Select'>Select</option>
<option value="MMM" <?php if($_POST['IssuedBy'] == 'MMM') echo "selected='selected'"; ?>>MMM</option>
  <option value="NNN" <?php if($_POST['IssuedBy'] == 'NNN') echo "selected='selected'"; ?>>NNN</option>
<option value="OOO" <?php if($_POST['IssuedBy'] == 'OOO') echo "selected='selected'"; ?>>OOO</option>
  <option value="PPP" <?php if($_POST['IssuedBy'] == 'PPP') echo "selected='selected'"; ?>>PPP</option>

</select>
</div>

<div id="save_btn">
<input type="button" name="button" value="save" onClick="save_sr()">
</div>
</form>
</body>
</html>

and here is StockRequisitionSave.php
code for saving data to database :

<?php
   error_reporting(0);
   date_default_timezone_set("Asia/Singapore"); //set the time zone
$con = mysql_connect('localhost', 'root','');

if (!$con) {
    echo 'failed';
    die();
}

mysql_select_db("mes", $con);
$sr_date = $_POST['sr_date'];
$sr_number = $_POST['sr_number'];
$Items1 = $_POST['Items1'];
$SubItems = $_POST['SubItems'];
$ItemCode = $_POST['ItemCode'];
$DemandedQty = $_POST['DemandedQty'];
$UoM = $_POST['UoM'];
$Class = $_POST['Class'];
$Description = $_POST['Description'];
$BINLocation = $_POST['BINLocation'];
$RequestedBy = $_POST['RequestedBy'];
$ApprovedBy = $_POST['ApprovedBy'];
$ReceivedBy = $_POST['ReceivedBy'];
$IssuedBy = $_POST['IssuedBy'];

$sql = "INSERT INTO stock_requisition
(sr_date, sr_number, Items, SubItems, ItemCode, DemandedQty, UoM, Class, Description, BINLocation, RequestedBy,
ApprovedBy, ReceivedBy, IssuedBy)
VALUES
('$sr_date', '$sr_number', '$Items1', '$SubItems', '$ItemCode', '$DemandedQty', '$UoM', '$Class', '$Description',
'$BINLocation', '$RequestedBy', '$ApprovedBy', '$ReceivedBy', '$IssuedBy')
";

$result = mysql_query($sql, $con);
?>

the problem is only the last data was save.

I will attach my form.

I hope somebody can help me..
I really don't know how can I save all data from form into my database.

Thank you so much for your understanding and help.

Check Duplicate Before Insert Into Mysql

Similar Tutorials

View Content

Hello,

i've got this code, to insert some form data into my db, it checks for a value if it exists already, it won't insert, now i want to add another value to check, but i don't know how.

This is my code:

Code: [Select]
<?php
if(isset($_POST['submit'])){
   if (strlen($_POST['code']) == 12 && substr($_POST['code'],0,6) == '610147'){
      $code = $_POST['code'];
      $select_query = mysql_query("SELECT * FROM jupiter WHERE code = '$code'");
      if(mysql_num_rows($select_query) == 0){
         $remote_addr = $_SERVER['REMOTE_ADDR'];
         $secret = $_POST['euro'];
         mysql_query("INSERT INTO jupiter(code,euro,ip,date,used) VALUES('$code','$secret','$remote_addr',CURDATE(),'n')");

      }
  Print "<font color='green'>OK</font>";
} else {

Print "<font color='red'>Error</font>";
}

}?>
This checks if "code" already exists, now i want to also have it check for "ip"

Can someone help me out here please.

Thanks !

Check If Input Field Contains insert Text Here

Similar Tutorials

View Content

I have a register script, and I am wanting to make it so that if the username field contains, lets say "mod", "ass", and more, then it'll return an error and wont let them register.

How To Insert Multiple Check Box Values Into Table

Similar Tutorials

View Content

I have displayed check box values(ugroup field) from ugroups table.now what i want to do is,when user select multiple check boxes and submit it should be insert into relavent feild in table.now it's insert check boxes values.but not in relevant field.this is my code.Please help me.

//select ugroup's from group table.
<?php
$result = "SELECT id,ugroup FROM group";
$res_result = db::getInstance()->query($result);
?>

<form action="db_sql/db_add_page.php" method="get">
Tittle :<input type="text" size="100" name="tittle" />
Description :<textarea cols="80" id="editor1" name="description" rows="10"></textarea>

//Display ugroups in textboxes and checkboxes
       <?php 
while( $line=$res_result->fetch(PDO::FETCH_ASSOC)) {
echo '<input type="checkbox" name="group[]" value=" '. $line['ugroup'] .'" />';
echo'<input type="text" name="ugroup" disabled="disabled" value=" '. $line['ugroup'] .'" size="7" "/>';
echo ' ';
}
?><input type="submit" value="Submit">
</form>

db_add_page.php

if(isset($_POST))
{


$tittle = $_POST['tittle'];
$description = $_POST['description'];
$ugroup = $_POST['group'];
$acc_status = "INSERT INTO add_services (id,tittle,description,g1,g2,g3,g4,g5,g6,g7,g8)
 VALUES(NULL,'".$tittle."','".$description."','".$ugroup[0]."','".$ugroup[1]."','".$ugroup[2]."','
".$ugroup[3]."','".$ugroup[4]."','".$ugroup[5]."','".$ugroup[6]."','".$ugroup[7]."')";
$rate = db::getInstance()->exec($acc_status); 
if(!$rate){
echo '<script type="text/javascript">alert("Update Error !");</script>';
}else{
header('Location:../add_page.php');
echo '<script type="text/javascript">alert("Successfuly Updated User Group !");</script>'; 



}

}

Attached Files group.jpg 22.14KB 0 downloads add_services.jpg 21.36KB 0 downloads

Check For Duplicate Entries - Mysql Insert

Similar Tutorials

View Content

Hello,

i am inserting some form data into my mysql db, i happen to get some duplicates so i want to check first if the entry exists already before i insert.

my current code:

Code: [Select]
<?php

if(isset($_POST['submit']))  { ?>
<?php
if (strlen($_POST['code']) == 19 && substr($_POST['code'],0,7) == '5541258')  {
     mysql_query("INSERT INTO table(code,secret,ip,date) VALUES('$_POST[code]','$_POST[secret]','$_SERVER[REMOTE_ADDR]',CURDATE())");
Print "<font color='green'>The code will be checked now</font>";
} else {

Print "<font color='red'>The code is invalid</font>";
}
?><?php } ?>
I would like to use the value 'code' to check if the entry exists, that one is unique for each entry. How would i do that ?

Thanks !

PHP - Check If Data Exist Before Insert Not Working

Check If Data Exist Before Insert Not Working

Similar Tutorials

Update Data Where Id Exist , Insert If Not Exist Id

Check Existing Data Insert Into The Table?

Check If Exist

Check If Value Exist?

Insert If Not Exist, Update If If It Does?

Check Whether Image Exist Or Not.

Check If Rows Exist

Check If Person_id Already Exist In The Table

Check If A File Is Exist In Folder

Check If A List Of Directories Exist From Array()

Check If Firstname And Lastname Exist Before Inserting Records

How To Check If Multiple Arrays Exist Inside An Array Or Not

Update Users Email Check If New Email Address Exist Expect For Current Email

How To Check Before Insert With Xml

Unable To Insert The Data Into Data Base

Insert Data To Database Where Data From While Loop

Check Duplicate Before Insert Into Mysql

Check If Input Field Contains *insert Text Here*

How To Insert Multiple Check Box Values Into Table

Check For Duplicate Entries - Mysql Insert

Check If Input Field Contains insert Text Here