mysql.php

mysql.php Source
0  <?
1  
2  Class MySQL
3  {
4  	var $CONN = "";
5  	var $DBASE = "phpHoo";
6  	var $USER = "joe";
7  	var $PASS = "tl0c112";
8  	var $SERVER = "localhost";
9  
10  	var $TRAIL = array();
11  	var $HITS = array();
12  
13  	var $AUTOAPPROVE = true;
14  
15  	function error($text)
16  	{
17  		$no = mysql_errno();
18  		$msg = mysql_error();
19  		echo "[$text] ( $no : $msg )<BR>\n";
20  		exit;
21  	}
22  
23  	function init ()
24  	{
25  		$user = $this->USER;
26  		$pass = $this->PASS;
27  		$server = $this->SERVER;
28  		$dbase = $this->DBASE;
29  
30  		$conn = mysql_connect($server,$user,$pass);
31  		if(!$conn) {
32  			$this->error("Connection attempt failed");
33  		}
34  		if(!mysql_select_db($dbase,$conn)) {
35  			$this->error("Dbase Select failed");
36  		}
37  		$this->CONN = $conn;
38  		return true;
39  	}
40  
41  //	*****************************************************************
42  //						MySQL Specific methods
43  //	*****************************************************************
44  
45  
46  	function select ($sql="", $column="")
47  	{
48  		if(empty($sql)) { return false; }
49  		if(!eregi("^select",$sql))
50  		{
51  			echo "<H2>Wrong function silly!</H2>\n";
52  			return false;
53  		}
54  		if(empty($this->CONN)) { return false; }
55  		$conn = $this->CONN;
56  		$results = mysql_query($sql,$conn);
57  		if( (!$results) or (empty($results)) ) {
58  			mysql_free_result($results);
59  			return false;
60  		}
61  		$count = 0;
62  		$data = array();
63  		while ( $row = mysql_fetch_array($results))
64  		{
65  			$data[$count] = $row;
66  			$count++;
67  		}
68  		mysql_free_result($results);
69  		return $data;
70  	}
71  
72  	function insert ($sql="")
73  	{
74  		if(empty($sql)) { return false; }
75  		if(!eregi("^insert",$sql))
76  		{
77  			echo "<H2>Wrong function silly!</H2>\n";
78  			return false;
79  		}
80  		if(empty($this->CONN)) { return false; }
81  		$conn = $this->CONN;
82  		$results = mysql_query($sql,$conn);
83  		if(!$results) { return false; }
84  		$results = mysql_insert_id();
85  		return $results;
86  	}
87  
88  //	*****************************************************************
89  //						phpHoo Specific Methods
90  //	*****************************************************************
91  
92  	function get_Cats ($CatParent= "")
93  	{
94  		if(empty($CatParent))
95  		{
96  			$CatParent = "IS NULL";
97  		} else {
98  			$CatParent = "= $CatParent";
99  		}
100  		$sql = "SELECT CatID,CatName FROM Categories WHERE CatParent $CatParent ORDER BY CatName";
101  		$results = $this->select($sql);
102  		return $results;
103  	}
104  
105  //	The primer for a recursive query
106  	function get_ParentsInt($CatID="")
107  	{
108  		if(empty($CatID)) { return false; }
109  		unset($this->TRAIL);
110  		$this->TRAIL = array();
111  		$this->get_Parents($CatID);
112  	}
113  
114  //	Use get_ParentsInt(), NOT this one!
115  //	The power of recursive queries
116  
117  	function get_Parents ($CatID="")
118  	{
119  		if( (empty($CatID)) or ("$CatID" == "NULL")) { return false; }
120  		$sql = "SELECT CatID,CatParent,CatName from Categories where CatID = $CatID";
121  
122  		$conn = $this->CONN;
123  		$results = mysql_query($sql,$conn);
124  		if( (!$results) or (empty($results)) ) {
125  			mysql_free_result($results);
126  			return false;
127  		}
128  
129  		while ( $row = mysql_fetch_array($results))
130  		{
131  			$trail = $this->TRAIL;
132  			$count = count($trail);
133  			$trail[$count] = $row;
134  			$this->TRAIL = $trail;
135  			$id = $row["CatParent"];
136  			$this->get_Parents($id);
137  		}
138  		return true;
139  	}
140  
141  	function get_CatIDFromName($CatName="")
142  	{
143  		if(empty($CatName)) { return false; }
144  		$sql = "SELECT CatID from Categories where CatName = '$CatName'";
145  		$results = $this->select($sql);
146  		if(!empty($results))
147  		{
148  			$results = $results[0]["CatID"];
149  		}
150  		return $results;
151  	}
152  
153  	function get_CatNames( $CatID="")
154  	{
155  		if($CatID == 0) { return "Top"; }
156  		$single = false;
157  		if(!empty($CatID))
158  		{
159  			$single = true;
160  			$CatID = "WHERE CatID = $CatID";
161  		}
162  		$sql = "SELECT CatName from Categories $CatID";
163  		$results = $this->select($sql);
164  		if($single)
165  		{
166  			if(!empty($results))
167  			{
168  				$results = $results[0]["CatName"];
169  			}
170  		}
171  		return $results;
172  	}
173  
174  	function get_Links($CatID = "")
175  	{
176  		if(empty($CatID))
177  		{
178  			$CatID = "= 0";
179  		} else {
180  			$CatID = "= $CatID";
181  		}
182  
183  		$sql = "SELECT Url,LinkName,Description FROM Links WHERE  (Approved != 0) AND CatID $CatID ORDER BY Url";
184  		$results = $this->select($sql);
185  		return $results;
186  	}
187  
188  	function get_CatFromLink($LinkID="")
189  	{
190  		if(empty($LinkID)) { return false; }
191  		$sql = "SELECT CatID FROM Links WHERE LinkID = $LinkID";
192  		$results = $this->select($sql);
193  		if(!empty($results))
194  		{
195  			$results = $results[0]["CatID"];
196  		}
197  		return $results;
198  	}
199  
200  	function search ($keywords = "")
201  	{
202  		if(empty($keywords)) { return false; }
203  
204  		$DEBUG = ""; // set DEBUG == "\n" to see this query
205  
206  		$keywords = trim(urldecode($keywords));
207  		$keywords = ereg_replace("([    ]+)"," ",$keywords);
208  
209  		if(!ereg(" ",$keywords))
210  		{
211  			// Only 1 keyword
212  			$KeyWords[0] = "$keywords";
213  		} else {
214  			$KeyWords = explode(" ",$keywords);
215  		}
216  
217  		$sql = "SELECT DISTINCT LinkID,CatID,Url,LinkName,Description FROM Links WHERE (Approved != 0) AND ( $DEBUG ";
218  		$count = count($KeyWords);
219  
220  		if( $count == 1)
221  		{
222  			$single = $KeyWords[0];
223  			$sql .= " (Description LIKE '%$single%') OR (LinkName LIKE '%$single%') OR (Url LIKE '%$single%') ) ORDER BY LinkName $DEBUG ";
224  		} else {
225  			$ticker = 0;
226  			while ( list ($key,$word) = each ($KeyWords) )
227  			{
228  				$ticker++;
229  				if(!empty($word))
230  				{
231  					if($ticker != $count)
232  					{
233  						$sql .= " ( (Description LIKE '%$word%') OR (LinkName LIKE '%$word%') OR (Url LIKE '%$word%') ) OR $DEBUG ";
234  					} else {
235  						// Last condition, omit the trailing OR
236  						$sql .= " ( (Description LIKE '%$word%') OR (LinkName LIKE '%$word%') OR (Url LIKE '%$word%') ) $DEBUG ";
237  					}
238  				}
239  			}
240  			$sql .= " ) ORDER BY LinkName $DEBUG";
241  		}
242  
243  		if(!empty($DEBUG)) { echo "<PRE>$sql\nTicker [$ticker]\nCount [$count]</PRE>\n"; }
244  
245  		$results = $this->select($sql);
246  		return $results;
247  	}
248  
249  	function suggest ($postData="")
250  	{
251  		if( (empty($postData)) or (!is_array($postData)) ) { return false; }
252  
253  		$CatID = $postData["CatID"];
254  		$Url = $postData["Url"];
255  		$Description = $postData["Description"];
256  		$LinkName = $postData["LinkName"];
257  		$SubmitName = $postData["SubmitName"];
258  		$SubmitEmail = $postData["SubmitEmail"];
259  		$SubmitDate = time();
260  
261  		if(empty($Url)) { return false; }
262  		if(empty($Description)) { return false; }
263  		if(empty($LinkName)) { return false; }
264  		if(empty($SubmitName)) { return false; }
265  		if(empty($SubmitEmail)) { return false; }
266  
267  		$Approved = 0;
268  		if($this->AUTOAPPROVE) { $Approved = 1; }
269  
270  
271  		$sql = "INSERT INTO Links ";
272  		$sql .= "(CatID,Url,LinkName,Description,SubmitName,SubmitEmail,SubmitDate,Approved) ";
273  		$sql .= "values ";
274  		$sql .= "($CatID,'$Url','$LinkName','$Description','$SubmitName','$SubmitEmail',$SubmitDate,$Approved) ";
275  		$results = $this->insert($sql);
276  		return $results;
277  	}
278  
279  }	//	End Class
280  ?>