Bii o ṣe le Idanwo Asopọ aaye data MySQL PHP Lilo Lilo iwe afọwọkọ

MySQL jẹ eto iṣakoso data olokiki ti o gbajumọ lakoko ti PHP jẹ ede afọwọkọ ẹgbẹ olupin ti o yẹ fun idagbasoke wẹẹbu; papọ pẹlu awọn olupin Apache tabi Nginx HTTP, ni awọn paati oriṣiriṣi ti LAMP (Linux Apache MySQL/MariaDB PHP) tabi LEMP (Linux Nginx MySQL/MariaDB PHP) akopọ ni gbigba.

Ti o ba jẹ olugbala wẹẹbu lẹhinna o le ti fi awọn idii sọfitiwia wọnyi sori ẹrọ tabi lo wọn lati ṣeto olupin wẹẹbu agbegbe kan lori eto rẹ. Ni aṣẹ fun oju opo wẹẹbu rẹ tabi ohun elo wẹẹbu lati tọju data, o nilo ibi ipamọ data bii MySQL/MariaDB.

Fun awọn olumulo ohun elo wẹẹbu lati ṣepọ pẹlu alaye ti o fipamọ sinu ibi ipamọ data, o gbọdọ jẹ eto ti n ṣiṣẹ lori olupin lati mu awọn ibeere lati ọdọ alabara ati kọja si olupin naa.

Ninu itọsọna yii, a yoo ṣalaye bi o ṣe le ṣe idanwo asopọ data MySQL nipa lilo faili PHP kan. Ṣaaju ki o to lọ siwaju, rii daju pe o gbọdọ ni Fitila tabi LEMP ti a fi sori ẹrọ lori eto, ti ko ba tẹle awọn itọnisọna wọnyi si ipilẹ.

  1. Fi atupa sii (Lainos, Apache, MariaDB tabi MySQL ati PHP) Stack lori Debian 9
    2. Bii a ṣe le Fi sii atupa pẹlu PHP 7 ati MariaDB 10 lori Ubuntu 16.10
  2. Fifi atupa (Linux, Apache, MariaDB, PHP/PhpMyAdmin) ni RHEL/CentOS 7.0

    Bii a ṣe le Fi LEMP sii (Linux, Nginx, MariaDB, PHP-FPM) lori Debian 9 Stretch Bawo ni Lati Fi Nginx sii, MariaDB 10, PHP 7 (LEMP Stack) ni 16.10/16.04
  1. Fi Nginx 1.10.1 Tuntun sii, MariaDB 10 ati PHP 5.5/5.6 lori RHEL/CentOS 7/6 & Fedora 20-26

Idanwo Isopọ Iṣura data MySQL Ni iyara Lilo Iwe afọwọkọ PHP

Lati ṣe idanwo isopọ PHP MySQL DB iyara, a yoo lo iwe afọwọkọ ọwọ ti o tẹle bi faili 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";
} 
?>

Bayi yi orukọ ibi ipamọ data pada, olumulo ibi ipamọ data ati ọrọ igbaniwọle olumulo bii olugbalejo si awọn iye agbegbe rẹ.

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

Fipamọ ki o pa faili naa. Bayi ṣiṣe o bi atẹle; o yẹ ki o tẹ nọmba lapapọ ti awọn tabili ninu ibi ipamọ data ti a ṣalaye.

$ php -f db-connect-test.php

O le kọja ayẹwo pẹlu ọwọ nipa sisopọ si olupin data ati kikojọ nọmba lapapọ ti awọn tabili ninu apoti data pato.

O tun le fẹ lati ṣayẹwo awọn nkan wọnyi ti o jọmọ wọnyi.

  1. Bii a ṣe le Wa MySQL, PHP ati Awọn faili iṣeto Apako
  2. Lilo iwulo PHP 12 Lo Gbogbo Olumulo Lainos Gbọdọ Mọ
  3. Bii a ṣe le Tọju Nọmba Ẹya PHP ni HTTP Header

Ṣe o ni ọna miiran tabi iwe afọwọkọ lati ṣe idanwo asopọ MySQL DB kan? Ti o ba bẹẹni, lẹhinna lo fọọmu esi ni isalẹ lati ṣe eyi.