Morgen.
Also
PHP-Code:
var_dump($result);
wirft nichts aus. Rein garnichts. Meine Klasse zur Verbindung zur Datenbank sieht wie folgt aus:
PHP-Code:
<?php
////////////////////////////////////////////////////////////////////////////////////////
// Class: DbConnector
// Purpose: Connect to a database, MySQL version
///////////////////////////////////////////////////////////////////////////////////////
require_once 'SystemComponent.php';
class DbConnector extends SystemComponent {
var $theQuery;
var $link;
//*** Function: DbConnector, Purpose: Connect to the database ***
function DbConnector(){
// Load settings from parent class
$settings = SystemComponent::getSettings();
// Get the main settings from the array we just loaded
$host = $settings['dbhost'];
$db = $settings['dbname'];
$user = $settings['dbusername'];
$pass = $settings['dbpassword'];
// Connect to the database
$this->link = mysql_connect($host, $user, $pass);
mysql_select_db($db);
register_shutdown_function(array(&$this, 'close'));
}
//*** Function: query, Purpose: Execute a database query ***
function query($query) {
$this->theQuery = $query;
return mysql_query($query, $this->link);
}
//*** Function: getQuery, Purpose: Returns the last database query, for debugging ***
function getQuery() {
return $this->theQuery;
}
//*** Function: getNumRows, Purpose: Return row count, MySQL version ***
function getNumRows($result){
return mysql_num_rows($result);
}
//*** Function: fetchArray, Purpose: Get array of query results ***
function fetchArray($result) {
return mysql_fetch_array($result);
}
//*** Function: close, Purpose: Close the connection ***
function close() {
mysql_close($this->link);
}
}
?>
Nun habt ihr eine grobe vorstellung womit ich eigentlich hier die ganze Zeit arbeite.
Ich habe grade die Lösung gefunden. Einfach wenn man sie kennt. Funktioniert einwandfrei man muss nur die SQL Befehle aufsplitten.
PHP-Code:
function remove_tree($ID) {
$result = $GLOBALS['connector']->query('DELETE FROM cmssections WHERE ID = '.$ID);
$result = $GLOBALS['connector']->query('SELECT ID FROM cmssections WHERE parentid=' . $ID);
while ($section = mysql_fetch_array($result)) {
remove_tree($section[ID]);
}
}
remove_tree($sectionID);
Trotzdem vielen Dank für eure Hilfe.
MfG, Andy