how to connect to a database in php
<?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"; ?>
$conn php
<?php $user = "username"; $pass = "password"; $host = "host"; $dbdb = "database"; $conn = new mysqli($host, $user, $pass, $dbdb); if ($conn->connect_error) { die("Connection failed: " . $conn->connect_error); } ?>
PHP Connect to MySQL
<?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"; ?>
connect sql server php
//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 />"; }
Source: seenual.com
connect php in sql server
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); ?>
Source: www.php.net