an

help mi dong yang jago php mysql



ane di kasi tugas dari dosen ane

keliatan ny sih mudah banget tpi bagi ane ribut

tugas ny :

membuat form input user menggunakan bahasa php

nah form ny udah ane buad smua ny udah berjalan dgn lancar jaya

skrg masalah ny ada tugas tambahan

di mana ketika kita menambahkan user baru,di situ ade pengecekan untuk user sama email (pengecekan sudah digunakan atau belum)



ane udah searching dan coba masukin syntax yg ane searching sma syntax yg ane punya

dan hasil ny masih gagal

gk bisa melalkukan pengencekan



untuk syntak input user ny ini gan :


<pre lang ="script">
<?php

include "koneksi.php";

$pass=md5($_POST[password]);





//Has the username or email been used?

$checkuser = mysql_query("SELECT id_user FROM user WHERE id_user='$id_user'");

$username_exist = mysql_num_rows($checkuser);



$checkemail = mysql_query("SELECT email FROM user WHERE email='$email'");

$email_exist = mysql_num_rows($checkemail) ;



if(($user_exist > 0) || ($check_mail > 0)) {

echo "Please fix the following errors: <br />";



} if($user_exist > 0) {

echo "<strong>Username is already being use please choose another one.</strong>";



unset($email);



}



if($mail_exist > 0) {

echo "<strong>E-mail is already being used please choose another one.</strong>";

unset($id_user);

exit();

}



mysql_query("INSERT INTO user(id_user,password,nama_lengkap,email)

VALUES('$_POST[id_user]','$pass','$_POST[nama_lengkap]','$_POST[email]')");

$up=mysql_num_rows;



include "tampil_user.php";

?>

</pre>