Skip to main content

Simple method to connect database using PHP.

 

 


$servername = "localhost"; $username = "root"; $password = ""; $dbname = "jjmtmain";

// Create connection
$conn = mysqli_connect($servername, $username, $password, $dbname);

// Check connection
if ($conn->connect_error) {
    die("Connection failed: " . $conn->connect_error);
} else {
    echo "Connected to database.";
} 


/* In further operations you can use the $conn object for the database connection. 

          For eg.

$q = mysqli_query($conn, "select * from user where email='$userid'");

$r = mysqli_fetch_array($q);

echo $name = $r['name'];

*/

Comments

Post a Comment

Popular posts from this blog

Restoring MySQL on XAMMP

  Follow these steps and save your time and databases:- Go to your  XAMMP  installation, it’s mostly in  C drive . Now inside  mysql  folder rename the folder  data  to  data-old  (or any other name you like) Create a new folder  data  under  mysql  folder Copy the contents of  backup  folder to the new  data  folder Now copy all your  database  folders that are in  data-old  folder to the new  data  folder (skip the mysql, performance_scheme and phpmyadmin folder) And the last, copy the  ibdata1  file from  data-old  folder and replace it inside new  data  folder Restart your  MYSQL  server from  XAMPP control panel . And done!
Post a Comment
Read more

Adding image on text using php (Certificate generation in php)

      <?php header('Content-type: image/jpeg'); //loading custom form $font=realpath('arial.ttf'); //creating pointer from sample image which is being edited $image=imagecreatefromjpeg("format.jpg"); //Adding color $color=imagecolorallocate($image, 51, 51, 102); $date=date('d F, Y'); //Adding date on image imagettftext($image, 18, 0, 880, 188, $color,$font, $date); //Adding name on image $name="Sagar kokare"; imagettftext($image, 48, 0, 120, 520, $color,$font, $name); //Saving edited image on server imagejpeg($image,"$name.jpg"); // you can show this image in browser // imagejpeg($image); imagedestroy($image); ?>
Post a Comment
Read more