PHP DATABASE::init Examples

Programming Language: PHP

Class/Type: DATABASE

Method/Function: init

Examples at hotexamples.com: 3

PHP database initialization involves connecting to the database and selecting a specific table to work with. It is essential for any PHP application that involves the use of a database.

Here are some code examples:

1. Initializing a connection to the MySQL database using mysqli:

// Replace parameters with your own connection details
$servername = "localhost";
$username = "your_username";
$password = "your_password";
$dbname = "your_database";

// Create connection
$conn = mysqli_connect($servername, $username, $password, $dbname);

// Check connection
if (!$conn) {
    die("Connection failed: " . mysqli_connect_error());
}

2. Selecting a specific table from the database:

$table_name = "users";

// Select all data from the "users" table
$sql = "SELECT * FROM $table_name";
$result = mysqli_query($conn, $sql);

// Output the results
while ($row = mysqli_fetch_assoc($result)) {
    echo $row["name"] . ", " . $row["email"] . "
";
}

These examples use the mysqli package, which is a PHP extension for connecting to MySQL databases.

PHP DATABASE::init - 3 examples found. These are the top rated real world PHP examples of DATABASE::init extracted from open source projects. You can rate examples to help us improve the quality of examples.

Frequently Used Methods

Show Hide

getInstance(7)

select(5)

f(5)

insert(4)

DB(3)

connect(3)

init(3)

startswith(1)

records(1)

record(1)

query(1)

lastquerytime(1)

lastquery(1)

instance(1)

CONNECTION(1)

CreateDatabase(1)

delete(1)

close(1)

Query(1)

PDO(1)

INSTANCE(1)

INIT(1)

FETCHMODE(1)

update(1)

Example #1

Show file

File: db_insert_class.php Project: supertorti/FRAMEWORK

 public static function doCall($table, $data, $debug = false)
 {
     $DBobject = parent::init();
     foreach ($data as $key => $value) {
         $key = self::escape($key);
         $value = self::escape($value);
         $keys .= $key . ", ";
         if ($value == null) {
             $values .= "null, ";
         } else {
             $values .= "'" . $value . "', ";
         }
     }
     $keys = rtrim($keys, ', ');
     $values = rtrim($values, ', ');
     $sql = "INSERT INTO {$table} (" . $keys . ") VALUES (" . $values . ")";
     if ($debug == true) {
         $_SESSION['debug'][] = __FUNCTION__ . ': $sql is <strong>' . $sql . '</strong>';
     }
     $DBobject->query($sql);
     if ($DBobject->errno) {
         $_SESSION['errors'][] = '<p>' . __FUNCTION__ . ' failed: ' . $DBobject->error . '<br> statement was: <strong> ' . $sql . '</strong></p>';
     }
     //self::$insertID = self::$db->insert_id;
 }

Example #2

Show file

File: db_everything_class.php Project: supertorti/FRAMEWORK

 public static function doCall($sql, $return = true, $debug = false)
 {
     $DBobject = parent::init();
     //call the database
     $result = $DBobject->query($sql);
     if ($DBobject->errno) {
         $_SESSION['errors'][] = '<p>select failed: ' . $DBobject->error . '<br> statement was: <strong>' . $sql . '</strong></p>';
         return array();
     } elseif ($return == true) {
         $ret = array();
         while ($row = $result->fetch_assoc()) {
             $ret[] = $row;
         }
         return $ret;
     }
     if ($debug == true) {
         logfile::doLog(__FUNCTION__ . ' : $sql is ' . $sql);
     }
 }

Example #3

Show file

File: db_update_class.php Project: supertorti/FRAMEWORK

 public static function doCall($table, $primary, $wnummer, $data, $debug = false)
 {
     $DBobject = parent::init();
     $sql = "UPDATE {$table} SET ";
     foreach ($data as $key => $value) {
         if ($value == null) {
             $sql .= "{$key} = null, ";
         } else {
             $sql .= "{$key} = '{$value}', ";
         }
     }
     $sql = rtrim($sql, ", ");
     $sql .= " WHERE " . $primary . " = '" . $wnummer . "'";
     if ($debug == true) {
         logfile::doLog(__FUNCTION__ . ' : $sql is ' . $sql);
     }
     $DBobject->query($sql);
     if ($DBobject->errno) {
     }
 }