Advanced Search

PHP Mysql Connection Object

/ Published in: PHP
Save to your folder(s)
A simple PHP object which connects to a mysql database, selects fields, creates users and more..

Expand | Embed | Plain Text

Copy this code and paste it in your HTML 
  1. <?php
  2. class dbCon{
  3. 	public function __construct(){
  4. 		$server = "host";
  5. 		$user = "user";
  6. 		$pass = "pass";
  7. 		$db = "db";
  8. 		mysql_connect($server, $user, $pass) or die("Error connecting to sql server: ".mysql_error());
  9. 		mysql_select_db($db);
  10. 	}
  11.  
  12. 	function getFields($table){
  13. 		$fields = $this->selectFields("*",$table);
  14. 		return $fields;
  15. 	}
  16.  
  17. 	function selectFields($fields,$table){
  18. 		$rs = mysql_query("SHOW columns FROM " . $table) or die ("cannot select table fields");
  19. 		$daFields = explode(",",$fields);
  20. 		$chosenFields = array();
  21. 		while($row = mysql_fetch_assoc($rs)){
  22. 			if($fields != "*"){
  23. 				$intersect = array_intersect($daFields,array($row['Field']));
  24. 				if(count($intersect) > 0)array_push($chosenFields, $row);
  25. 			}
  26. 			else array_push($chosenFields,$row);
  27. 		}
  28. 		array_unshift($chosenFields,$table);
  29. 		return $chosenFields;
  30. 	}
  31.  
  32. 	function createUser($names,$values){
  33. 		$na = explode(",",$names);
  34. 		$va = explode(",",$values);
  35. 		$pass = "";
  36. 		for($i=0; $i<count($na); $i++){
  37. 			if($na[$i] == "password"){
  38. 				$pass = str_replace("'","",$va[$i]);
  39. 				$values = str_replace($pass,crypt($pass),$values);
  40. 			}
  41. 		}
  42. 		$sql = "INSERT INTO users (".$names.") VALUES (".$values.")";
  43. 		mysql_query($sql) or die("Error Creating User");
  44. 		return "Account Successfully Created";
  45. 	}
  46.  
  47. 	function login($username,$password){
  48. 		$sql = "SELECT password FROM users WHERE username='".$username."'";
  49. 		$rs = mysql_query($sql);
  50. 		while($row = mysql_fetch_assoc($rs)) $cryptPass = $row['password'];
  51. 		$rs = mysql_query("SELECT users.id, users.first_name, users.last_name, users.email FROM users WHERE users.username='".$username."' AND users.password='".crypt($password, $cryptPass)."'");
  52. 		$userInfo = array();
  53. 		while($row = mysql_fetch_array($rs)){
  54. 			foreach($row as $name => $value){
  55. 				$userInfo[$name] = $value;
  56. 			}
  57. 		}
  58. 		return $userInfo;
  59. 	}
  60.  
  61. 	function userAvailable($user){
  62. 		$rs = mysql_query("SELECT username FROM users WHERE username='$user'");
  63. 		return mysql_num_rows($rs);
  64. 	}
  65. }
  66. ?>

Report this snippet


Comments

RSS Icon Subscribe to comments

You need to login to post a comment.