Yadda ake Gwada Haɗin Database Database na PHP ta Amfani da Rubutu

MySQL sanannen tsarin sarrafa bayanai ne yayin da PHP harshe ne na rubutun sabar da ya dace da ci gaban yanar gizo; tare da Apache ko Nginx HTTP sabobin, sune sassa daban-daban na LAMP (Linux Apache MySQL/MariaDB PHP) ko LEMP (Linux Nginx MySQL/MariaDB PHP) tari cikin karɓa.

Idan kai mai haɓaka gidan yanar gizo ne to ƙila ka shigar da waɗannan fakitin software ko amfani da su don saita sabar gidan yanar gizo a cikin tsarin ku. Domin gidan yanar gizonku ko aikace-aikacen yanar gizon ku don adana bayanai, yana buƙatar bayanan bayanai kamar MySQL/MariaDB.

Domin masu amfani da aikace-aikacen yanar gizo suyi hulɗa tare da bayanan da aka adana a cikin ma'ajin bayanai, dole ne a sami wani shiri da ke gudana akan uwar garken don karɓar buƙatun daga abokin ciniki kuma ya wuce zuwa uwar garken.

A cikin wannan jagorar, za mu bayyana yadda ake gwada haɗin bayanan MySQL ta amfani da fayil ɗin PHP. Kafin ci gaba, tabbatar cewa dole ne a sanya LAMP ko LEMP akan tsarin, idan ba a bi waɗannan koyawa don saitawa ba.

  1. Saka LAMP (Linux, Apache, MariaDB ko MySQL da PHP) Tari akan Debian 9
    2. Yadda ake Sanya LAMP tare da PHP 7 da MariaDB 10 akan Ubuntu 16.10
  2. Shigar da LAMP (Linux, Apache, MariaDB, PHP/PhpMyAdmin) a cikin RHEL/CentOS 7.0

    Yadda ake Sanya LEMP (Linux, Nginx, MariaDB, PHP-FPM) akan Debian 9 Stretch Yadda Ake Sanya Nginx, MariaDB 10, PHP 7 (LEMP Stack) a cikin 16.10/16.04
  1. Saka Sabon Nginx 1.10.1, MariaDB 10 da PHP 5.5/5.6 akan RHEL/CentOS 7/6 & Fedora 20-26

Gwajin Haɗin Database Mai Sauri ta MySQL Amfani da Rubutun PHP

Don yin gwajin haɗin haɗin PHP MySQL DB mai sauri, za mu yi amfani da rubutun hannu mai zuwa azaman fayil db-connect-test.php.

<?php
# Fill our vars and run on cli
# $ php -f db-connect-test.php

$dbname = 'name';
$dbuser = 'user';
$dbpass = 'pass';
$dbhost = 'host';

$link = mysqli_connect($dbhost, $dbuser, $dbpass) or die("Unable to Connect to '$dbhost'");
mysqli_select_db($link, $dbname) or die("Could not open the db '$dbname'");

$test_query = "SHOW TABLES FROM $dbname";
$result = mysqli_query($link, $test_query);

$tblCnt = 0;
while($tbl = mysqli_fetch_array($result)) {
  $tblCnt++;
  #echo $tbl[0]."<br />\n";
}

if (!$tblCnt) {
  echo "There are no tables<br />\n";
} else {
  echo "There are $tblCnt tables<br />\n";
} 
?>

Yanzu canza sunan ma'ajin bayanai, mai amfani da bayanai da kalmar wucewar mai amfani da kuma mai watsa shiri zuwa ƙimar gida.

$dbname = 'name';
$dbuser = 'user';
$dbpass = 'pass';
$dbhost = 'host';

Ajiye kuma rufe fayil ɗin. Yanzu gudanar da shi kamar haka; ya kamata ya buga jimlar adadin tebur a cikin ƙayyadaddun bayanai.

$ php -f db-connect-test.php

Kuna iya haye rajistan shiga da hannu ta haɗa zuwa uwar garken bayanan bayanai da jera jimlar adadin teburi a cikin takamaiman bayanan bayanai.

Hakanan kuna iya son duba waɗannan labarai masu alaƙa.

  1. Yadda ake Nemo MySQL, PHP da Fayilolin Kanfigareshan Apache
  2. 12 Amfanin Layin Rukunin Rukunin PHP Mai Amfani Kowane Mai Amfani da Linux Dole ne ya sani
  3. Yadda ake Ɓoye lambar Sigar PHP a cikin Header HTTP

Kuna da wata hanya ko rubutun don gwada haɗin MySQL DB? Idan eh, to, yi amfani da fom ɗin martani na ƙasa don yin hakan.