ConnectDatabase
Aus Programmers Guide
(Unterschied zwischen Versionen)
Roy (Diskussion | Beiträge) K |
Roy (Diskussion | Beiträge) K |
||
(Der Versionsvergleich bezieht 3 dazwischenliegende Versionen mit ein.) | |||
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 == | ||
- | '''MysqlConnector.php''' | + | <source lang="php"> |
+ | 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(); | ||
+ | |||
+ | </source> | ||
+ | |||
+ | <br> '''MysqlConnector.php''' | ||
<source lang="php"> | <source lang="php"> | ||
<?php | <?php | ||
- | class | + | class MysqlConnector |
{ | { | ||
var $db_connection = null; // Database connection string | var $db_connection = null; // Database connection string | ||
Zeile 51: | Zeile 63: | ||
/** NewConnection Method | /** NewConnection Method | ||
* This method establishes a new connection to the database. */ | * This method establishes a new connection to the database. */ | ||
- | public function | + | public function PushData($server, $database, $username, $password) |
{ | { | ||
// Assign variables | // Assign variables | ||
Zeile 59: | Zeile 71: | ||
$db_username = $username; | $db_username = $username; | ||
$db_password = $password; | $db_password = $password; | ||
- | |||
- | |||
- | |||
- | |||
- | |||
- | |||
- | |||
- | |||
- | |||
- | |||
- | |||
- | |||
- | |||
- | |||
- | |||
- | |||
- | |||
- | |||
- | |||
- | |||
- | |||
} | } | ||
Zeile 130: | Zeile 121: | ||
/** Query Method | /** Query Method | ||
- | * This method | + | * This method queries the Database with a given MySQL-String*/ |
public function Query($query) | public function Query($query) | ||
{ | { | ||
Zeile 140: | Zeile 131: | ||
echo 'Could not run query: '.$query ."<br>\n". mysql_error(); | echo 'Could not run query: '.$query ."<br>\n". mysql_error(); | ||
exit; | exit; | ||
+ | }else{ | ||
+ | return $result; | ||
} | } | ||
}else | }else | ||
Zeile 145: | Zeile 138: | ||
return "Error: No connection has been established to the database. Cannot query."; | return "Error: No connection has been established to the database. Cannot query."; | ||
} | } | ||
+ | |||
} | } | ||
+ | } | ||
+ | ?> | ||
+ | </source> | ||
+ | |||
+ | == Iteration über das Ergebnis == | ||
+ | |||
+ | <source lang="php"> | ||
+ | <?php | ||
+ | while($row = mysql_fetch_row($result)){ | ||
+ | echo row[0]; | ||
} | } | ||
?> | ?> | ||
</source> | </source> | ||
+ | |||
+ | [[Category:Snippet]] [[Category:Klassen]] [[Category:PHP]] |
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]; } ?>