01.<?php
02.class Tutorial{
03.
04. function __construct(){
05.
06. $db_host = '';
07. $db_user = '';
08. $db_pass = '';
09. $db_name = '';
10. $ipaddress = $_SERVER["REMOTE_ADDR"];
11.
12. $con = mysql_connect($db_host, $db_user, $db_pass);
13.
14.
15. mysql_select_db($db_name, $con);
16. }
17.
18. function get_rows($id = ''){
19. if($id != ''){
20.
21. $query = mysql_query("SELECT * FROM lamas WHERE id = $id");
22. #$query = mysql_query("SELECT * FROM lamas,files_lamas WHERE lamas.id = files_lamas.id and lamas.id = 0000000001");
23. $data = mysql_fetch_assoc($query);
24.
25.
26. }else{
27.
28. $query = mysql_query("SELECT * FROM lamas WHERE Pak = '4' ORDER BY like_num DESC limit 3");
29. while($row = mysql_fetch_assoc($query)){
30. $data[] = $row;
31.
32.
33. }
34. }
35. return $data;
36. }
37.
38.
39. function insert($data = array()){
40. $data_array_num = count($data);
41. $columns = "";
42. $values = "";
43. $i=0;
44. foreach($data as $key=>$val){
45. $i++;
46. $sep = ($i == $data_array_num)?"":", ";
47. $columns .= $key.$sep;
48. $values .= $val.$sep;
49. }
50. $insert = mysql_query("INSERT INTO lamas ($columns) VALUES ($values)");
51. return $insert?TRUE:FALSE;
52. }
53.
54. function update($data = array(), $conditions = array()){
55. $data_array_num = count($data);
56. $cols_vals = "";
57. $condition_str = "";
58. $i=0;
59. foreach($data as $key=>$val){
60. $i++;
61. $sep = ($i == $data_array_num)?'':', ';
62. $cols_vals .= $key."='".$val."'".$sep;
63. }
64. foreach($conditions as $key=>$val){
65. $i++;
66. $sep = ($i == $data_array_num)?"":" AND ";
67. $condition_str .= $key."='".$val."'";
68. }
69.
70. $update = mysql_query("UPDATE lamas SET $cols_vals WHERE $condition_str");
71. return $update?TRUE:FALSE;
72. }
73.}
74.?>
Load balance : Server 03
