How to Connect Database to PHP using MySQL and XAMPP

Make MYSQL DATABASE IN PHPMYADMIN AT THE LOCALHOST

PHPMyAdmin is a control panel from where you can manage the database that you have created. Open your browser and type localhost/ then xampp page will open then click PHPMyAdmin after that PHPMyAdmin will open now then Click Database or New on Left Side phpMyadmin Page.

Creating a Database at phpMyAdmin

Name your database as per your needs. I am naming it ‘test’ database. To enter the name of the database in the text box then click create and your database will be made.

Creating a Folder in Server ( XAMPP, Hosting Server, Wamp )

First Create a Folder in your according sever. in the event that you use xampp, at that point go to C:/xampp/htdocs/or on the off chance that you use wamp, at that point go to C:/wamp/www . on the off chance that you use web facilitating server as Cpanel, GoDaddy, big rock, etc, at that point your main directory or folder is public_html or www or htdocs or your domain directory . After that then create a folder and name it as per your need. I name it to ‘site’ . in folder create or save a PHP file and name it to ‘config.php’, ‘db.php’, ‘connect.php’, ‘database.php’ according to you need. I name it to index.php.Write the following code in your PHP file.

Example

Download

 <?php
$error = "";
$success = "";
if($_SERVER["REQUEST_METHOD"] == "POST"){

   if(isset($_POST['connect'])){
	   
$db_hostname = "localhost"; // Server Name Localhost 
$db_user = "root";          // Database Username or Host
$db_pass =  "";             // Password of Database Username or Host - 
$db = "test";

//Connecting to Database or Mysql Server
$conn = mysqli_connect($db_hostname,$db_user,$db_pass) or die ("could not connect");
mysqli_select_db($conn,$db) or die ("could not find database");
if($conn)
{
  $sql = "CREATE TABLE user ( name VARCHAR(111) NOT NULL , username VARCHAR(111) NOT NULL UNIQUE , password VARCHAR(111) NOT NULL ) ENGINE = InnoDB";
	
	if(mysqli_query($conn,$sql))
	{
	$success = "Table user is Created";
	  }
else
{
	$error = "Table Already Exist or Another Problem";

}
}
else
{
	$error = "connection error";
}
}
}
?>
<html>
<head>
<link rel="stylesheet" type="text/css" href="style.css">
<head>
<body>
<div class="wrapper">
      <h2 class="form-signin">SQL Connection Test</h2>
     <form  method="post" action="" enctype="multipart/form-data">       
        <center><input type="submit" value="Connect to MySQL Database" name="connect"/></center> </form>
   <span style="color:#6C0; font-size:25px;"><?php echo $success; ?></span>
    <span style="color:#930; font-size:25px;"><?php echo $error; ?></span>
   </div>
  </body>
  </html>

Example CSS

Download

 @charset "utf-8";
/* CSS Document */
/* Style.css */
h2 {
  text-align: center;
  font-size:30px;
  display:block;
  text-transform: uppercase;
  margin: 0 auto; 
  font-family: inherit;
  font-weight: 500;
  line-height: 1.1;
  color: inherit;
}
.h2 {
  text-align: center;
  font-size:16px;
  display:inline-block;
  text-transform: uppercase;
   font-family: inherit;
  top:1px;
  font-weight: 500;
  line-height: 1.1;
  color: inherit;
}


.wrapper {
	width:420px;
	height:400px;
	position:relative;
	margin: 60px 0px 0px 30%;
	background:url(back.jpg) ;
	text-align: center;
	border: 4px solid #B0C4DE;
	border-bottom: none;
	border-radius: 10px 10px 0px 10px;
    padding: 21px;
  }

.form-signin {
	display:block;
	width:400px;
  border: 1px solid rgba(0,0,0,0.1);  
  padding: 5px;
  margin-left:3px;
  border: 1px solid #B0C4DE;
 background:#333;
  color:#fff;
  
}
  .
	.checkbox {
		
	  margin-bottom: 28px;
	  	  font-weight: normal;}
 
input[type=button], input[type=submit], input[type=reset]  {
  background-color: #56baed;
  border: none;
  color: white;
  display:inline-block;
  padding: 15px 80px;
  text-align: center;
  text-decoration: none;
  display: inline-block;
  text-transform: uppercase;
  font-size: 14px;
  -webkit-box-shadow: 0 10px 30px 0 rgba(95,186,233,0.4);
  box-shadow: 0 10px 30px 0 rgba(95,186,233,0.4);
  -webkit-border-radius: 5px 5px 5px 5px;
  border-radius: 5px 5px 5px 5px;
  margin: 140px 20px 40px 20px;
  -webkit-transition: all 0.3s ease-in-out;
  -moz-transition: all 0.3s ease-in-out;
  -ms-transition: all 0.3s ease-in-out;
  -o-transition: all 0.3s ease-in-out;
  transition: all 0.3s ease-in-out;
}

input[type=button]:hover, input[type=submit]:hover, input[type=reset]:hover  {
  background-color: #39ace7;
}

input[type=button]:active, input[type=submit]:active, input[type=reset]:active  {
  -moz-transform: scale(0.95);
  -webkit-transform: scale(0.95);
  -o-transform: scale(0.95);
  -ms-transform: scale(0.95);
  transform: scale(0.95);
}

How to Connect PHP to Database using MySql & XAMPP

Make MYSQL DATABASE IN PHPMYADMIN AT THE LOCALHOST

Rajindera Comp

Leave a ReplyCancel Reply

Learn Python in 21 Days: From Beginner to Pro

ChatGPT Explained: Complete Guide to OpenAI's Model

How to Download & Install XAMPP on Windows 10/11

What is Python Automation & 7 Best Automation Modules

How to Create Complete User Login System in PHP & MySQL

Rajindera Comp

Leave a ReplyCancel Reply

Related Posts

What is Moltbook? The Secret Social Network Where Only AI Agents Talk to Each Other

Learn Python in 21 Days: From Beginner to Pro

ChatGPT Explained: Guide to OpenAI’s Powerful Language Model