-
Notifications
You must be signed in to change notification settings - Fork 1
/
connect.php
39 lines (38 loc) · 1.2 KB
/
connect.php
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
<?php
/**
* Parses and verifies the doc comments for file.
*
* PHP version 5.6
*
* @category PHP
* @package PHPTUT
* @author Teerapuch Kassakul <teerapuch@hotmail.com>
* @copyright 2016 Teerapuch
* @license http://opensource.org/licenses/mit-license.php MIT License
* @link http://teerapuch.com
*/
try {
// connect to database
$db = new PDO('mysql:host=localhost; dbname=zendtut; charset=utf8', 'root', '');
// sql statment
$select = $db->query('SELECT * FROM customer_tbl LIMIT 100');
$customer = $select->fetchAll();
$countrySQL = $db->query('SELECT DISTINCT id,country_name FROM country_tbl');
$country = $countrySQL->fetchAll();
$cus = $db->query('SELECT * FROM customer_tbl LIMIT 100');
$cust = $cus->fetchAll();
foreach ($cust as $key => $c) {
$custo["data"][] = $c;
}
$cj = json_encode($custo);
// $email = $db->query("SELECT email FROM customer_tbl WHERE id = $id ");
// $mail = $email->fetchAll();
/*
$email = $db->prepare("SELECT email FROM customer_tbl WHERE id = $id ");
$email->execute();
$mail = $email->fetch();
*/
} catch (Exception $e) {
echo 'Can not connect to database';
throw new Exception($e);
}