Class DB_MySQLi

Description
Description | Vars (details) | Methods (details)

Class to make a connection to a MySQL database with the mysqli extension

Located in /DB_MySQLi.class.php (line 34) 


	
			






	
	

		
Variable Summary

		

			Description |
						Vars (details)
							| 
									Methods (details)
							
								

		

			

																																

					 
					string
					$_database
				

																

					 
					obj
					$_db_connection
				

											

		

	


	
	

		
Method Summary

		

			Description |
																		Vars (details)
				 
				|
						Methods (details)
		

		
			
			

																																																								

					 
											DB_MySQLi
										__construct
											(string $db, string $host, string $user, string $pass)
									

																

					 
											int
										change
											(string $sql, array $params)
									

																

					 
											bool
										connected
										()
									

																

					 
											array
										fetch
											(string $sql, [array $params = array()])
									

																

					 
											obj
										_mysqli_stmt_prepare_execute
											(string $sql, array $params)
									

											

		

	
		

	
	

		
Variables

		

			Description |
										Vars (details)
						
			
										| 
									Methods (details)
							
					

		

			




	

		
		
			string
			$_database
						(line 43)
		
	


	
	
    
				
  • var: name of the weblog database
    • 
				
  • access: private
    • 
			

	
	
		
		







	

		
		
			obj
			$_db_connection
			 =  FALSE			(line 39)
		
	


	
	
    
				
  • var: database connection object
    • 
				
  • access: private
    • 
			

	
	
		
		




						
		

	

	
	
	

		
Methods

		

			Description |
															Vars (details)
														Methods (details)
						
		

		

			



	
	

		
		Constructor __construct (line 53)
	
 
	
	

Constructor

	
    
				
  • access: public
    • 
			

	
	

		DB_MySQLi
		
			__construct
		
					(string $db, string $host, string $user, string $pass)
			

	
			
    
					
  • 
				string
				$db: name of weblog database			
    • 
					
  • 
				string
				$host: host of weblog database			
    • 
					
  • 
				string
				$user: username for weblog database			
    • 
					
  • 
				string
				$pass: password for weblog database			
    • 
				

		
			
	




	
	

		
		change (line 131)
	
 
	
	

Method to perform queries that change the database (INSERT, UPDATE, DELETE)

	
    
				
  • return: number of affected rows
    • 
				
  • access: public
    • 
			

	
	

		int
		
			change
		
					(string $sql, array $params)
			

	
			
    
					
  • 
				string
				$sql: SQL query with placeholders			
    • 
					
  • 
				array
				$params: array with values for placeholders			
    • 
				

		
			
	




	
	

		
		connected (line 179)
	
 
	
	

Method to test if connection to database is established

	
    
				
  • return: FALSE if not connected, TRUE otherwise
    • 
				
  • access: public
    • 
			

	
	

		bool
		
			connected
		
				()
			

	
		
			
	




	
	

		
		fetch (line 75)
	
 
	
	

Method to perform queries to SELECT from the database

	
    
				
  • return: numeric array of found associative rows from the database
    • 
				
  • access: public
    • 
			

	
	

		array
		
			fetch
		
					(string $sql, [array $params = array()])
			

	
			
    
					
  • 
				string
				$sql: SQL query with placeholders if needed			
    • 
					
  • 
				array
				$params: array with values for placeholders			
    • 
				

		
			
	




	
	

		
		_mysqli_stmt_prepare_execute (line 150)
	
 
	
	

Private method to prepare and execute a mysqli prepared statement

	
    
				
  • return: mysqli_stmt object
    • 
				
  • access: private
    • 
			

	
	

		obj
		
			_mysqli_stmt_prepare_execute
		
					(string $sql, array $params)
			

	
			
    
					
  • 
				string
				$sql: SQL query with placeholders			
    • 
					
  • 
				array
				$params: array with values for placeholders			
    • 
				

		
			
	

						
		

	


	
	

		Documentation generated on Sun, 17 Jun 2007 19:20:35 +0200 by phpDocumentor 1.3.2