File manager - Edit - /home/autoph/public_html/voc/home/user_check_if_exist.php
Back
<?php include 'core/init.php'; $apicode="TR-MARJO331334_NN66J"; //$connect_error = 'Sorry, we\'re experiencing connection problem. Please try again later... Thank you!'; //mysql_connect('localhost','root','aee1024') or die ($connect_error); //mysql_select_db('db_vts') or die($connect_error); //error_reporting(1); $dealID= $user_data['dealer']; $compID= $user_data['company']; //if submit/ save to databasevar if(isset($_POST['done'])){ exit(); } //display from database if(isset($_POST['display'])){ $uName = mysql_escape_string($_POST['uName']); $checkIfExist = mysql_result(mysql_query("SELECT COUNT('u_id') FROM `vts_users` WHERE `u_name`='$uName'"),0); if($checkIfExist != 0){ echo "<p style='padding:5px;font-family:Calibri;font-size:16px;color:red;font-weight:bold;background:yellow;border:1px solid orange;border-radius:5px;text-align:center'> Sorry, username already inused.:".$uNam."</p>"; }else{ echo "<p style='padding:5px;font-family:Calibri;font-size:16px;color:red;font-weight:bold;background:#a4fd88;border:1px solid #41f507;border-radius:5px;text-align:center'>New Record has been Saved.</p>"; $uName = mysql_escape_string($_POST['uName']); $uTitle = mysql_escape_string($_POST['uTitle']); $sCompID = mysql_escape_string($_POST['sCompID']); $sDealID = mysql_escape_string($_POST['sDealID']); $svDate = mysql_escape_string($_POST['svDate']); $svTime = mysql_escape_string($_POST['svTime']); $svUserID = mysql_escape_string($_POST['svUserID']); $uFname = mysql_escape_string($_POST['uFname']); $uLname = mysql_escape_string($_POST['uLname']); $uMobile = mysql_escape_string($_POST['uMobile']); $uEmail = mysql_escape_string($_POST['uEmail']); $uPassB = md5(mysql_escape_string($_POST['uPassB'])); $uPassA = md5(mysql_escape_string($_POST['uPassA'])); $uRole = mysql_escape_string($_POST['uRole']); $uEmpID = mysql_escape_string($_POST['uEmpID']); mysql_query("INSERT INTO vts_users (`employee_id`,`company`,`dealer`,`u_name`,`u_fname`,`u_lname`,`u_position`,`email`,`u_password`,`u_password2`,`access_right`,`date`,`time`,`usr_mobile`) VALUES('{$uEmpID}','{$sCompID}','{$sDealID}','{$uName}','{$uFname}','{$uLname}','{$uTitle}','{$uEmail}','{$uPassA}','{$uPassB}', '{$uRole}','{$svDate}','{$svTime}','{$uMobile}')"); itexmo($uMobile, $uName, $apicode); } exit(); } ?>
| ver. 1.4 |
.
| PHP 7.3.33 | Generation time: 0 |
proxy
|
phpinfo
|
Settings