Breaking News: Grepper is joining You.com. Read the official announcement!

how to connect database in php

Add Answer

Md Munnaf answered on November 10, 2019 Popularity 10/10 Helpfulness 10/10

answer how to connect database in php

related how to connect to a database in php

related how to connect my php code to database

related php connect to db

related connect sql server php

related connect php with mysql

related connect php in sql server

related connect php to db

how to connect database in php

Comment

<?php
 $hostName = "localhost";
 $userName = "root";
 $password = "";
 $dbName = "database name";
 $conn= new mysqli($hostName,$userName,$password,$dbName);
 if($conn){
    echo "connected";
 }else{
    echo "not connected";
 }

  ?>

Popularity 10/10 Helpfulness 10/10 Language php

Source: Grepper

Tags: connect database php

Link to this answer
Share Copy Link

Contributed on Jun 24 2022

Md Munnaf

0 Answers Avg Quality 2/10

Closely Related Answers

how to connect to a database in php

Comment

<?php
$servername = "localhost";
$username = "username";
$password = "password";

// Create connection
$conn = new mysqli($servername, $username, $password);

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

Popularity 10/10 Helpfulness 9/10 Language php

Source: Grepper

Tags: connect

Link to this answer
Share Copy Link

Contributed on Nov 10 2019

AlikeIATS

0 Answers Avg Quality 2/10

how to connect my php code to database

Comment

<?php
 $hostName = "localhost";
 $userName = "root";
 $password = "";
 $dbName = "database name";
 $conn= new mysqli($hostName,$userName,$password,$dbName);
 if($conn){
    echo "connected";
 }else{
    echo "not connected";
 }

  ?>

Popularity 9/10 Helpfulness 5/10 Language php

Source: Grepper

Tags: connect

Link to this answer
Share Copy Link

Contributed on Mar 13 2023

Different Dugong

0 Answers Avg Quality 2/10

php connect to db

Comment

<?php
$servername = "localhost";
$username = "username";
$password = "password";

// Create connection
$conn = new mysqli($servername, $username, $password);

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

Popularity 9/10 Helpfulness 4/10 Language php

Source: Grepper

Tags: connect

Link to this answer
Share Copy Link

Contributed on May 28 2023

DB ms

0 Answers Avg Quality 2/10

connect sql server php

Comment

//Connect MSSQL
$serverName = '192.xxx.xxx.xx';
$userName = 'usertest';
$userPassword = 'pwdtest';
$dbName = 'dbtest';
 
try{
	$conn = new PDO("sqlsrv:server=$serverName ; Database = $dbName", $userName, $userPassword);
	$conn->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
}
catch(Exception $e){
	die(print_r($e->getMessage()));
}
 
//การ query และแสดงข้อมูล จัดเรียงตามฟิวด์ field1 แบบมากไปน้อย เริ่มที่เรคคอร์ดที่ 0-100
$query = " SELECT * FROM tbl 
ORDER BY field1 DESC
OFFSET 0 ROWS
FETCH NEXT 100 ROWS ONLY ";
$getRes = $conn->prepare($query);
$getRes->execute();
 
while($row = $getRes->fetch( PDO::FETCH_ASSOC ))
{
echo $row['field1']."<br />";
echo $row['field2']."<br />";
}

Popularity 10/10 Helpfulness 4/10 Language php

Source: seenual.com

Tags: connect

Link to this answer
Share Copy Link

Contributed on Jan 15 2022

Cruel Chimpanzee

0 Answers Avg Quality 2/10

connect php with mysql

Comment

<?php
$servername = "localhost"; // Change this to your MySQL server hostname or IP address
$username = "your_username"; // Change this to your MySQL username
$password = "your_password"; // Change this to your MySQL password
$database = "your_database"; // Change this to your MySQL database name

// Create a connection
$conn = new mysqli($servername, $username, $password, $database);

// Check the connection
if ($conn->connect_error) {
    die("Connection failed: " . $conn->connect_error);
}

echo "Connected successfully!";
?>

Popularity 9/10 Helpfulness 4/10 Language php

Source: chat.openai.com

Tags: connect

Link to this answer
Share Copy Link

Contributed on Sep 09 2023

Combative Cow

0 Answers Avg Quality 2/10

connect php in sql server

Comment

SQL SERVER 2012 conexion in PHP
<?php
    $serverName = "SERVER"; //serverName\instanceName
    $connectionInfo = array( "Database"=>"base", "UID"=>"ex", "PWD"=>"******");
    $conn = sqlsrv_connect( $serverName, $connectionInfo);
;

        if( $conn ) {
             echo "Conexión establecida.<br />";
        }else{
            echo "Conexión no se pudo establecer.<br />";
            die( print_r( sqlsrv_errors(), true));
        }

    $sql = "SELECT name FROM [base].[dbo].[table]";
    $params = array();
    $options =  array( "Scrollable" => SQLSRV_CURSOR_KEYSET );
    $stmt = sqlsrv_query( $conn, $sql , $params, $options );

    $row_count = sqlsrv_num_rows( $stmt );
  

        if ($row_count === false)
           echo "Error al obtener datos.";
        else
           echo "bien";
        //echo $row_count;

        while( $row = sqlsrv_fetch_array( $stmt) ) {
              print json_encode($row);
        }

    sqlsrv_close($conn);
?>

Popularity 10/10 Helpfulness 3/10 Language php

Source: www.php.net

Tags: connect

Link to this answer
Share Copy Link

Contributed on Jan 16 2022

Cruel Chimpanzee

0 Answers Avg Quality 2/10

connect php to db

Comment

This is an update to a note I wrote earlier concerning how to set multiple attributes when you create you PDO connection string.

You can put all the attributes you want in an associative array and pass that array as the fourth parameter in your connection string. So it goes like this:
<?php
$options = [
    PDO::ATTR_ERRMODE => PDO::ERRMODE_EXCEPTION,
    PDO::ATTR_CASE => PDO::CASE_NATURAL,
    PDO::ATTR_ORACLE_NULLS => PDO::NULL_EMPTY_STRING
];

// Now you create your connection string
try {
    // Then pass the options as the last parameter in the connection string
    $connection = new PDO("mysql:host=$host; dbname=$dbname", $user, $password, $options);

    // That's how you can set multiple attributes
} catch(PDOException $e) {
    die("Database connection failed: " . $e->getMessage());
}
?>

Popularity 10/10 Helpfulness 2/10 Language php

Source: www.php.net

Tags: connect

Link to this answer
Share Copy Link

Contributed on Dec 26 2021

msaber

0 Answers Avg Quality 2/10

how to connect database in php

Contents

More Related Answers

how to connect database in php

Closely Related Answers

how to connect to a database in php

how to connect my php code to database

php connect to db

connect sql server php

connect php with mysql

connect php in sql server

connect php to db

Grepper

Documentation

Social

Legal

Contact

Oops, You will need to install Grepper and log-in to perform this action.