Jump to content

i got some error

dean012

By dean012
in PHP Coding Help

 Share

Recommended Posts

dean012 Member

dean012

Posted
Posted
when i open this in chrome/browser it cam out this at the bottom

alert('Please enter your Username')"; exit(); } if($users_pass==''){ echo ""; exit(); } if($users_email==''){ echo ""; exit(); } $check_email="select*from users where users_email='$users_email'"; $run = mysql_query($check_email) or die(mysql_error()); if(mysql_num_rows($run)>0){ echo""; exit(); } $query = "insert into users (users_name,users_pass,users_email) values(' $users_name','$users_pass','$users_email')"; { $result = mysql_query($query) or die(mysql_error()); } echo""; } ?>

 

 

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Strict//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-strict.dtd">

<!--

 

 

-->


<head>

 

<meta name="keywords" content="" />

<meta name="description" content="" />

<meta http-equiv="content-type" content="text/html; charset=utf-8" />

<title>Yakity Yak</title>

<link href='http://fonts.googleapis.com/css?family=Oswald:400,300' rel='stylesheet' type='text/css'>

<link href='http://fonts.googleapis.com/css?family=Abel|Satisfy' rel='stylesheet' type='text/css'>

<link href="style.css" rel="stylesheet" type="text/css" media="screen" />

</head>

<body>

<div id="wrapper">

 

  <p><!-- end #header --></p>

  <div id="header" class="container">

    <div id="logo">

      <h1><a href="#">Yakity Yak</a></h1>

    </div>

    <div id="menu">

      <ul>

        <li class="current_page_item"><a href="file:///D:/blackpolish/index.html">Homepage</a></li>

        <li><a href="file:///D:/blackpolish/trip.html">Destinations</a></li>

        <li><a href="file:///D:/blackpolish/Contact.html">contact </a></li>

        <li><a href="file:///D:/blackpolish/login.html">Login</a></li>

<li><a href="#">Leader</a></li>

        <li></li>

        <li></li>

      </ul>

    </div>

  </div>

  <blockquote>

    <blockquote>

      <p> <center><img src="sd.jpg" width="999" height="300"  alt=""/></center>  </p>

    </blockquote>

  </blockquote>

  <div id="page">

    <div class="post">

      <h2 class="title"><a href="#">Welcome to Yakity yak club</a></h2>

 <form method='post' action='login.php'>

<table width='400' border='5' align='CENTER'>

 

<tr>

<td><h1>Login</h1></td>

 

</tr>

 

<tr>

<td>User Name:</td>

<td><input type='text' name='name'/></td>

</tr>

 

<tr>

<td>Password:</td>

<td><input type='password' name='pass'/></td>

</tr>

<tr>

<td>Email:</td>

<td><input type='text' name='email'/></td>

</tr>

<tr>

<td><input type='submit' name='login' value='login'/></td>

 

</tr>

 

</table>

</form>

 

</body>

</html>

 

<div class="entry">

 

</div>

    </div>

  </div>

 

</body>

</html>

 

 

<?php

$connect=mysql_connect("localhost","root","");

$db_selected = mysql_select_db("users_db", $connect); 

if(isset($_POST['submit'])){

 

$users_name = $_POST['name'];

$users_pass = $_POST['pass'];

$users_email = $_POST['email'];

 

if($users_name==''){

echo "<script>alert('Please enter your Username')</script>";

    exit();

}

 

if($users_pass==''){

echo "<script>alert('Please enter your password')</script>";

    exit();

}

 

if($users_email==''){

echo "<script>alert('Please enter your email')</script>";

    exit();

}

 

$check_email="select*from 

users where 

users_email='$users_email'";

 

$run = 

mysql_query($check_email) or

die(mysql_error());

 

 

 

if(mysql_num_rows($run)>0){

 

echo"<script>alert('Email $users_email 

is already exist in our databse, please try another 

one')</script>";  exit();

}

 

 

$query = "insert into users 

(users_name,users_pass,users_email) values('

$users_name','$users_pass','$users_email')";

 

 

{ 

$result = mysql_query($query) 

or die(mysql_error());

 

    

}

echo"<script>alert

window.open('','_self')</script>";

 

    

}

 

?>

 

Link to comment
Share on other sites
fastsol Regular Member

fastsol

Posted
Posted

Well you had a number of html errors that I fixed.  I did not experience the issue you are having, even loading your code as it was.  One issue in the php for sure was that you were trying to check for submit even though you didn't have a form field named "submit", you had the submit button named "login".  So I changed that too.  At this moment I don't get any specific errors with this fixed code, although it's not really coded very well, but I'm not going to recode the whole thing.

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Strict//EN" "http://www.w3.org/TR...l1-strict.dtd">
<!--
 
 
-->
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
 
<meta name="keywords" content="" />
<meta name="description" content="" />
<meta http-equiv="content-type" content="text/html; charset=utf-8" />
<title>Yakity Yak</title>
<link href='http://fonts.googlea...=Oswald:400,300' rel='stylesheet' type='text/css'/>
<link href='http://fonts.googlea...css?family=Abel|Satisfy' rel='stylesheet' type='text/css'/>
<link href="style.css" rel="stylesheet" type="text/css" media="screen" />
</head>
<body>
<div id="wrapper">
 
  <p><!-- end #header --></p>
  <div id="header" class="container">
    <div id="logo">
      <h1><a href="#">Yakity Yak</a></h1>
    </div>
    <div id="menu">
      <ul>
        <li class="current_page_item"><a href="file:///D:/blackpolish/index.html">Homepage</a></li>
        <li><a href="file:///D:/blackpolish/trip.html">Destinations</a></li>
        <li><a href="file:///D:/blackpolish/Contact.html">contact </a></li>
        <li><a href="file:///D:/blackpolish/login.html">Login</a></li>
<li><a href="#">Leader</a></li>
        <li></li>
        <li></li>
      </ul>
    </div>
  </div>
  <blockquote>
    <blockquote>
      <p> <center><img src="sd.jpg" width="999" height="300"  alt=""/></center>  </p>
    </blockquote>
  </blockquote>
  <div id="page">
    <div class="post">
      <h2 class="title"><a href="#">Welcome to Yakity yak club</a></h2>
 <form method='post' action='login.php'>
<table width='400' border='5' align='CENTER'>
 
<tr>
<td><h1>Login</h1></td>
 
</tr>
 
<tr>
<td>User Name:</td>
<td><input type='text' name='name'/></td>
</tr>
 
<tr>
<td>Password:</td>
<td><input type='password' name='pass'/></td>
</tr>
<tr>
<td>Email:</td>
<td><input type='text' name='email'/></td>
</tr>
<tr>
<td><input type='submit' name='login' value='login'/></td>
 
</tr>
 
</table>
</form>
  
<div class="entry">
 
</div>
    </div>
  </div>
</div>
</body>
</html>
 
 
<?php
$connect=mysql_connect("localhost","root","");
$db_selected = mysql_select_db("users_db", $connect); 
if(isset($_POST['login'])){
 
$users_name = $_POST['name'];
$users_pass = $_POST['pass'];
$users_email = $_POST['email'];
 
if($users_name==''){
echo "<script>alert('Please enter your Username')</script>";
    exit();
}
 
if($users_pass==''){
echo "<script>alert('Please enter your password')</script>";
    exit();
}
 
if($users_email==''){
echo "<script>alert('Please enter your email')</script>";
    exit();
}
 
$check_email="select*from users where users_email='$users_email'";
 
$run = mysql_query($check_email) or die(mysql_error());
 
 
 
if(mysql_num_rows($run)>0){
 
echo"<script>alert('Email $users_email is already exist in our databse, please try another one')</script>";  exit();
}
 
 
$query = "insert into users (users_name,users_pass,users_email) values('$users_name','$users_pass','$users_email')";
 
 
{ 
$result = mysql_query($query) 
or die(mysql_error());
 
    
}
echo"<script>alert window.open('','_self')</script>";
 
    
}
 
?>
Link to comment
Share on other sites
This thread is more than a year old. Please don't revive it unless you have something important to add.

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Reply to this topic...

×   Pasted as rich text.   Restore formatting

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

×
 Share
Go to topic listing
×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.