ConnectDatabase
Aus Programmers Guide
(Unterschied zwischen Versionen)
Roy (Diskussion | Beiträge) K |
Roy (Diskussion | Beiträge) K |
||
Zeile 16: | Zeile 16: | ||
<br> '''Query-Function''' <source lang="php"> | <br> '''Query-Function''' <source lang="php"> | ||
<?php | <?php | ||
+ | //ich zähle gerne die abfragen | ||
+ | $db_queries=0; | ||
+ | |||
function db_query($query){ | function db_query($query){ | ||
global $db_queries, $db_conn; | global $db_queries, $db_conn; | ||
Zeile 30: | Zeile 33: | ||
} | } | ||
?> | ?> | ||
- | </source> | + | </source> |
== Connection als Klasse == | == Connection als Klasse == |
Aktuelle Version vom 06:54, 6. Apr. 2010
Standard-Connection
<?php $host="localhost"; $user=""; $password=""; $db=""; $verbindung = mysql_connect ($host,$user, $password) or die ("keine Verbindung zur Datenbank moeglich."); mysql_select_db($db) or die ("Die Datenbank existiert nicht."); ?>
Query-Function
<?php //ich zähle gerne die abfragen $db_queries=0; function db_query($query){ global $db_queries, $db_conn; $result=mysql_query($query); $db_queries++; if(mysql_error()){ echo "<b>".$query."</b><br>\n".mysql_error(); $result=null; } return $result; } ?>
Connection als Klasse
require_once('MysqlConnector.php'); $mysqlConnector = new MysqlConnector(); $mysqlConnector->PushData($server, $database, $username, $password); $mysqlConnector->Open(); $result=$mysqlConnector->Query("SELECT * FROM Tabellenname WHERE irgendwas IS NULL;"); $mysqlConnector->Close();
MysqlConnector.php
<?php class MysqlConnector { var $db_connection = null; // Database connection string var $db_server = null; // Database server var $db_database = null; // The database being connected to var $db_username = null; // The database username var $db_password = null; // The database password var $CONNECTED = false; // Determines if connection is established /** NewConnection Method * This method establishes a new connection to the database. */ public function PushData($server, $database, $username, $password) { // Assign variables global $db_connection, $db_server, $db_database, $db_username, $db_password; $db_server = $server; $db_database = $database; $db_username = $username; $db_password = $password; } /** Open Method * This method opens the database connection (only call if closed!) */ public function Open() { global $db_connection, $db_server, $db_database, $db_username, $db_password, $CONNECTED; if (!$CONNECTED) { try { $db_connection = mysql_connect ($db_server, $db_username, $db_password); mysql_select_db ($db_database); if (!$db_connection) { throw new Exception('MySQL Connection Database Error: ' . mysql_error()); } else { $CONNECTED = true; } } catch (Exception $e) { echo $e->GetMessage(); } } else { return "Error: No connection has been established to the database. Cannot open connection."; } } /** Close Method * This method closes the connection to the MySQL Database */ public function Close() { global $db_connection, $CONNECTED; if ($CONNECTED) { mysql_close($db_connection); $CONNECTED = false; } else { return "Error: No connection has been established to the database. Cannot close connection."; } } /** Query Method * This method queries the Database with a given MySQL-String*/ public function Query($query) { global $CONNECTED; if ($CONNECTED) { $result = mysql_query($query); if (!$result) { echo 'Could not run query: '.$query ."<br>\n". mysql_error(); exit; }else{ return $result; } }else { return "Error: No connection has been established to the database. Cannot query."; } } } ?>
Iteration über das Ergebnis
<?php while($row = mysql_fetch_row($result)){ echo row[0]; } ?>