Phpdb Programming Examples

How to use MySQL SELECT Statement in PHP

phpdb

<?php
$driver = 'mysql';
$database = "dbname=CODINGGROUND";
$dsn = "$driver:host=localhost;$database";

$username = 'root';
$password = 'root';

try {
   $conn = new PDO($dsn, $username, $password);
   echo "Database CODINGGROUND Connected\n";
}catch(PDOException $e){
   echo $e->getMessage();
}
$sql = 'SELECT  * FROM users';
$stmt = $conn->prepare($sql);
$stmt->execute();

while($row = $stmt->fetch(PDO::FETCH_ASSOC)){
  foreach($row as $value)
  {
    echo sprintf("%s, ", $value);
  }
  echo "\n";
}
?>

test

phpdb

<?php
$driver = 'mysql';
$database = "dbname=CODINGGROUND";
$dsn = "$driver:host=localhost;$database";

$username = 'root';
$password = 'root';

try {
   $conn = new PDO($dsn, $username, $password);
   echo "Database CODINGGROUND Connected\n";
}catch(PDOException $e){
   echo $e->getMessage();
}
$sql = 'SELECT  * FROM users';
$stmt = $conn->prepare($sql);
$stmt->execute();

while($row = $stmt->fetch(PDO::FETCH_ASSOC)){
  foreach($row as $value)
  {
    echo sprintf("%s, ", $value);
  }
  echo "\n";
}
?>

create db and tables

phpdb

<?php
class Car {
    private $color;
    public function getColor() {
        $col_car = $this->color = 'red';
        print_r($this);
        return $col_car;
    }
}
$car = new Car();
echo "Car1 is " . $car->getColor();
//echo "<br>";

differenze public-private

phpdb

Unable to open file!