Bootstrap Studio[PASOK]

[masterito]

try mo to angtagal na, sigurado master mo na ngayon php pero eto padin since wala pa sumasagot haha.

if(isset($_POST['save'])){
$fn = real_escape_string($dbcon,$_POST['name']);
$ln = real_escape_string($dbcon,$_POST['position']);
$sn = real_escape_string($dbcon,$_POST['office']);


$counter="select Name from tbl_employee where Name='$fn'";
$con_counter=mysqli_query($dbcon,$counter);
$check=mysqli_num_rows($con);

if($check==1)
{
echo"Employee already exist!";
}

else{
$emp_table="INSERT INTO tbl_employee (Name,Position,Office) VALUES('$fn','$ln','$sn')";
mysqli_query($dbcon,$emp_table);
echo"successfully recorded!";
}

}

sir yung $con yata dapat $con_counter

 

[jess1993]

try mo to angtagal na, sigurado master mo na ngayon php pero eto padin since wala pa sumasagot haha.

if(isset($_POST['save'])){
$fn = real_escape_string($dbcon,$_POST['name']);
$ln = real_escape_string($dbcon,$_POST['position']);
$sn = real_escape_string($dbcon,$_POST['office']);


$counter="select Name from tbl_employee where Name='$fn'";
$con_counter=mysqli_query($dbcon,$counter);
$check=mysqli_num_rows($con);

if($check==1)
{
echo"Employee already exist!";
}

else{
$emp_table="INSERT INTO tbl_employee (Name,Position,Office) VALUES('$fn','$ln','$sn')";
mysqli_query($dbcon,$emp_table);
echo"successfully recorded!";
}

}

you can use PRIMARY KEY/UNIQUE KEY then use "INSERT IGNORE" para di mag duplicate or you can use also "INSERT .. ON DUPLICATE KEY" if you want to update the record match with new record.

eto lang nman is kung gusto mo i optimize yung speed ng queries mo..pwedi rin nman yung counter checking if existing..
pero in the end kakailanganin mo pa rin mga unique keys for faster query..

 

[batongbato]

hindi ba error yan? mag kaiba ung number ng arguments at params? +1 dun sa taas ko mas malinis mag query ka muna kung existing.

Sir Jays, Do you teach web programming? or can you recommend a school near quezon city?

 

[papaloundo]

Thank you so much! ito hinahanap ko...

 

[badtripp]

salamat dito paps