如何使用PHP将phpmyadmin数据库连接到我的网站 [英] How do I connect phpmyadmin database to my website using PHP

问题描述

我在phpmyadmin中创建了一个数据库但是当我通过php建立与该数据库的连接时，我收到连接错误。我已经重新检查了代码，我认为php中的代码没有任何问题。



我尝试了什么： < br $>

I have created a database in phpmyadmin but when i am making a connection to that database through php, i am getting a connection error. I have rechecked the code and i don't think there is any problem with the code in php.

What I have tried:

<?php 
define('DB_HOST', 'localhost'); 
define('DB_NAME', 'alabdouli_users'); 
define('DB_USER','safeer123'); 
define('DB_PASSWORD','******'); 
$con=mysqli_connect(DB_HOST,DB_USER,DB_PASSWORD) or die("Failed to connect to MySQL: " . mysqli_error()); 
$db=mysqli_select_db(DB_NAME,$con) or die("Failed to connect to database: " . mysqli_error()); 
function NewUser() 
{ 
$fullname = $_POST['name']; 
$userName = $_POST['user']; 
$email = $_POST['email'];
$password = $_POST['pass']; 
$query = "INSERT INTO websiteusers (fullname,userName,email,pass) VALUES ('$fullname','$userName','$email','$password')"; 
$data = mysqli_query ($query)or die(mysqli_error()); 
if($data) 
{ 
echo "YOUR REGISTRATION IS COMPLETED..."; 
} } 
function SignUp() 
{ 
if(!empty($_POST['user'])) //checking the 'user' name which is from Sign-Up.html, is it empty or have some text 
{ 
$query = mysqli_query("SELECT * FROM websiteusers WHERE userName = '$_POST[user]' AND pass = '$_POST[pass]'") or die(mysqli_error()); 
if(!$row = mysqil_fetch_array($query) or die(mysqli_error())) { newuser(); 
} 
else 
{ 
echo "SORRY...YOU ARE ALREADY REGISTERED USER..."; 
} } } 
if(isset($_POST['submit'])) 
{ 
SignUp(); 
} 
?>

推荐答案

con = mysqli_connect（DB_HOST，DB_USER，DB_PASSWORD）或死亡（无法连接到MySQL：。mysqli_error（））;

con=mysqli_connect(DB_HOST,DB_USER,DB_PASSWORD) or die("Failed to connect to MySQL: " . mysqli_error());

db = mysqli_select_db（DB_NAME，

db=mysqli_select_db(DB_NAME,

con）或死亡（连接失败到数据库：。mysqli_error（））;
函数NewUser（）
{

con) or die("Failed to connect to database: " . mysqli_error()); function NewUser() {

这篇关于如何使用PHP将phpmyadmin数据库连接到我的网站的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！