-
Notifications
You must be signed in to change notification settings - Fork 0
/
Copy pathsample.php
66 lines (35 loc) · 861 Bytes
/
sample.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
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
<?php
include "oocrud.php";
$host="localhost"; // MySQL HOST Name or IP
$name="testing"; // Database Name
$user="user"; // MySQL User
$pass="pass"; // MySQL User's pass
function retmysql ($int_ret, $type) {
$utype=strtoupper($type);
switch ($int_ret) {
case -1:
echo "MYSQL FAIL";
break;
case 0:
echo "FAIL ON ".$utype;
break;
case 1:
echo "OK";
break;
}
}
$crud= new Crud($host, $name, $user, $pass);
echo "CREATE ";
$res=$crud->create("t1","ID","2");
retmysql($res, "create");
echo "\n";
echo "READ\n";
var_dump($crud->read("*","t1"));
echo "UPDATE ";
$res=$crud->update("t1","ID=10","ID=0");
retmysql($res, "update");
echo "\n";
var_dump($crud->read("*","t1"));
echo "DELETE ";
$crud->delete("t1","ID=2");
var_dump($crud->read("*","t1"));