Phalcon Microsoft SQL Connect

Phalcon-Microsoft-SQL-Connect

Hubungkan kerangka phalcon dengan mssql

=========================================================================

File berfungsi

• Phalcon Versi 3.x
• PHP 7.0
• Ubuntu 16.4

==========================================================KAN

Untuk lebih lanjut bergabung: http://www.phoenixpeth.com/

Instalasi sebelum mengunggah file ke server

Langkah 1

sudo su curl https://packages.microsoft.com/keys/microsoft.asc | Tambah APT-Key-Curl https://packages.microsoft.com/config/ubuntu/16.04/mssql-server.list> /etc/apt/sources.list.d/mssql-server.list Exit

=========================================================================

Langkah 2

sudo apt-get update sudo apt-get install mssql-server

=========================================================================

Langkah 3

SUDO/OPT/MSSQL/BIN/MSSQL-CONF SETUP

=========================================================================

Langkah 4

sudo su curl https://packages.microsoft.com/config/ubuntu/16.04/prod.list> /etc/apt/sources.list.d/mssql-tools.list keluar sudo app-get sudo accept_eula = y apt-get mssql-dools Path = "$ path:/opt/mssql-tools/bin" '>> ~/.bash_profile echo' path ekspor = "$ path:/opt/mssql-tools/bin" '>> ~/.bashrc sumber ~/.bashrc

=========================================================================

Langkah 5 - Memeriksa

sqlcmd -s localhost -u sa -p yourpassword -q "pilih @@ versi"

=========================================================================

Langkah 6 - Instal Driver ODBC

sudo su curl https://packages.microsoft.com/keys/microsoft.asc | APT-Key ADD-Curl https://packages.microsoft.com/config/ubuntu/16.04/prod.list> /etc/apt/sources.list.d/mssql-get msodbc.list exit sudo apt-get sudo sudo accept_eula = y apt-get msodbc Build-esensial sudo pecl instal sqlsrv pdo_sqlsrv sudo echo "extension = pdo_sqlsrv.so" >> php --ini | grep "Loaded Configuration" | sed -e "s|.*:s*||" sudo echo "ekstensi = sqlsrv.so" >> php --ini | grep "Loaded Configuration" | sed -e "s|.*:s*||"

+++++++ Perbarui file php.ini jika tidak dimuat ekstensi ++++++++

Tambahkan baris di bawah dalam ekstensi

ekstensi = pdo_sqlsrv.so extension = sqlsrv.so

=========================================================================

Langkah 7 - Pembuatan Database

sqlcmd -s localhost -u sa -p your_password -q "Buat database phalcon_test;" ATAU

sqlcmd -s localhost -u sa -p your_password -q "Gunakan phalcon_test; buat tabel [personas] (id identitas int (1,1) kunci primer, [nombre] varchar (255) bukan nol, [estado] varchar (255));"

sqlcmd -s localhost -u sa -p your_password -q "Gunakan phalcon_test; buat pengguna tabel (id id identitas (1,1) kunci utama, nama varchar (200), email varchar (200));"

=========================================================================

Kode File PHP -Untuk memeriksa sqlsrv pdotype

php-connect.php

"SampledB", "uid" => "sa", "pwd" => "your_password"); // Menetapkan koneksi $ conn = sqlsrv_connect ($ servername, $ connectionOptions); if ($ conn) echo "terhubung!" ?>

=========================================================================

Untuk lebih lanjut bergabung: http://www.phoenixpeth.com/