Oldalak

Showing posts with label DataBasa. Show all posts
Showing posts with label DataBasa. Show all posts

Wednesday, December 14, 2016

Insert into mySQL databasa with php






Create 3 file.

1. File name input.html



<html>

<header></header>

 <body>

 <form action="insert.php" method="post">

Username: <input name="adnam" size="20" /><br />
Password: <input name="adpsw" size="20" /><br />
<input type="submit" value="SEND" />
</form>




</body>


</html>  

2. File name insert.php 


<?php

$username = $_POST["adnam"];
$password = $_POST["adpsw"];

 $conn = mysql_connect('localhost', 'root', '');

  if (!$conn)
  {
    die('Could not connect: ' . mysql_error());
  }
 
  mysql_select_db('users');
 
  $query="INSERT INTO user (username, password)
VALUES ('$username','$password')";

 mysql_query($query);

/*if ($conn->query($sql) === TRUE) {
    echo "New record created successfully";
} else {
    echo "Error: " . $sql . "<br>" . $conn->error;
}*/

header("location:ok.html");

 mysql_close($conn);
?>

3.File name ok.html   


<html>
 <head></head>
<body>

 User inserted to databasa OK . <a href="input.html">New User</a>

</body>
</html>


Wednesday, October 19, 2016

How To Connect MySQL DataBasa









<?php

$db_username="root"; /*Username in localhost is ROOT*/
$db_password="";  /*DataBasa Password*/
$db_hoster="localhost"; /*Just in the LocalHost */



   $conn = mysql_connect($db_hoster, $db_username, $db_password);
   if(! $conn )
   {
     die('DataBasa error: ' . mysql_error());
   }
   echo 'DataBasa READY';
  
  
  
  
  
  
  
  
  
  
   mysql_close($conn);


?>