i need some real help here guys, i cannot get this code to work and im at my wits end, ive looked it over and over and it just doesnt wanna work, even though at one poin ti did have it working suddenly it just doesnt wanna work and i cant see why, i think maybe i have been working on this too long and im just not able to see my error but i needed a second opinion on it.
[php]
<?php $con = mysqli_connect("localhost", "root", "", "numbers") or die(mysqli_error($con)); $k = NULL; if(isset($_GET['submit'])) { $k = $_GET['k']; } ?> nav { width: 100%; float: left; margin: 0 0 1em 0; padding: 0; background-color: #f2f2f2; border-bottom: 1px solid #ccc; } ul { list-style: none; width: 800px; margin: 0 auto; padding: 0; } li { float: left; } li a { display: block; padding: 8px 15px; text-decoration: none; font-weight: bold; color: #069; border-right: 1px solid #ccc; } li:first-child a { border-left: 1px solid #ccc; } li a:hover { color: #c00; background-color: #fff; }<link href="style.css" rel="stylesheet" type="text/css" />
<!-- script that will only allow numbers to be entered into a text box, also limits them to 10 numbers-->
<script type="application/javascript">
function isNumberKey(evt)
{
var charCode = (evt.which) ? evt.which : event.keyCode
if (charCode > 31 && (charCode < 48 || charCode > 57))
return false;
return true;
}
Personal Searchables
Example: 1112223333
| Phone Number |
| Registered Number: CANNOT CALL!! |
| Unregistered Number: CALLING PERMITTED |
".$length."
";
}
?>
<?php
//submission code, inserting data into mysql database
$newnum = NULL;
$mySqlDate = date('Y-m-d');
$mySqlTime = date('g:i a');
if(isset($_GET['add']))
{
$empname = $_GET['empname'];
$newnum = $_GET['newnum'];
$firstname = $_GET['firstname'];
$lastname = $_GET['lastname'];
$email = $_GET['email'];
}
if(strlen($newnum) == $min_length)
{
//filter out non numeric and special characters
$empname = mysqli_real_escape_string($con, $_GET['empname']);
$newnum = mysqli_real_escape_string($con, $_GET['newnum']);
$firstname = mysqli_real_escape_string($con, $_GET['firstname']);
$lastname = mysqli_real_escape_string($con, $_GET['lastname']);
$email = mysqli_real_escape_string($con, $_GET['email']);
$check = mysqli_query($con, "SELECT count(*) FROM usernumdata WHERE numb = '".$newnum."'") or die();
$row = mysqli_fetch_row($check);
if ($row[0] == 0)
{
$sql="INSERT INTO usernumdata (empname, numb, firstname, lastname, email, date, time) VALUES ('".$empname."','".$newnum."','".$firstname."','".$lastname."','".$email."','".$mySqlDate."','".$mySqlTime."')";
if (!mysqli_query($con,$sql)) {
die('Error: ' . mysqli_error($con));
}
echo "
| Employee Name: | |
| Customer First Name: | |
| Customer Last Name: | |
| Customer Email: | |
| Phone Number: | |
Successfully Added New Entry
";
}
else
{
echo "
Number Already Exists In Do Not Call List
";
}
}
else{
$length = "Remember Phone Number Must be ".$min_length. " Digits Long and Contain all Numeric Characters";
echo "
".$length."
";
}
?>
[/php]
any help at all is greatly appreciated guys