Use pdo with mysql – php | あんまり長いことは書けないブログ

Connect to db

try {
$user = "root";
$pass = "pass";
$dbh = new PDO('mysql:host=localhost;dbname=db', $user, $pass);
} catch (PDOException $e) {
print "Error!: " . $e-&gt;getMessage() . "&lt;br/&gt;";
die();
};

try {

$user = "root";

$pass = "pass";

$dbh = new PDO('mysql:host=localhost;dbname=db', $user, $pass);

} catch (PDOException $e) {

print "Error!: " . $e->getMessage() . "<br/>";

die();

};

SELECT

$stmt = $dbh-&gt;prepare(" SELECT count(*) FROM `tb` WHERE name = :i ");

$stmt-&gt;execute(array("i"=&gt;"$v"));
//Value exists?
$number_of_rows = $stmt-&gt;fetchColumn(); 

if ($number_of_rows == 0) {
echo "Value does not exist
";
}else{
echo "Value exists";
};

$stmt = $dbh->prepare(" SELECT count(*) FROM `tb` WHERE name = :i ");

$stmt->execute(array("i"=>"$v"));

//Value exists?

$number_of_rows = $stmt->fetchColumn();

if ($number_of_rows == 0) {

echo "Value does not exist

}else{

echo "Value exists";

};

SELECT2

$q = $dbh-&gt;prepare("SELECT * tb WHERE name = :i");
$q-&gt;bindValue(':i', 'something');
$q-&gt;execute();

if ($q-&gt;rowCount() &gt; 0){
    $check = $q-&gt;fetch(PDO::FETCH_ASSOC);
    $row_id = $check['id'];
    echo $row_id;
    // do something
}

//or

$q = $db-&gt;prepare("SELECT id FROM table WHERE forename = :forename and surname = :surname LIMIT 1");
$q-&gt;bindValue(':forename', 'Joe');
$q-&gt;bindValue(':surname',  'Bloggs');
$q-&gt;execute();

if ($q-&gt;rowCount() &gt; 0){
    $check = $q-&gt;fetch(PDO::FETCH_ASSOC);
    $row_id = $check['id'];
    // do something
}

$q = $dbh->prepare("SELECT * tb WHERE name = :i");

$q->bindValue(':i', 'something');

$q->execute();

if ($q->rowCount() > 0){

$check = $q->fetch(PDO::FETCH_ASSOC);

$row_id = $check['id'];

echo $row_id;

// do something

}

//or

$q = $db->prepare("SELECT id FROM table WHERE forename = :forename and surname = :surname LIMIT 1");

$q->bindValue(':forename', 'Joe');

$q->bindValue(':surname', 'Bloggs');

$q->execute();

if ($q->rowCount() > 0){

$check = $q->fetch(PDO::FETCH_ASSOC);

$row_id = $check['id'];

// do something

}

UPDATA

$sql = 'update tb set set_column =:set_name where where_column = :where_value';
$stmt = $dbh -&gt; prepare($sql);
$stmt-&gt;bindParam(':set_name', $update_set_name, PDO::PARAM_STR);
$stmt-&gt;bindParam(':where_value', $update_where_value, PDO::PARAM_STR);
$stmt-&gt;execute();

$sql = 'update tb set set_column =:set_name where where_column = :where_value';

$stmt = $dbh -> prepare($sql);

$stmt->bindParam(':set_name', $update_set_name, PDO::PARAM_STR);

$stmt->bindParam(':where_value', $update_where_value, PDO::PARAM_STR);

$stmt->execute();

INSERT

$stmt = $dbh -&gt; prepare("INSERT INTO tb (column_one, column_tow) 
	                     VALUES(:value_one, :value_tow)");
$stmt-&gt;bindParam(':value_one', $value_one, PDO::PARAM_STR);
$stmt-&gt;bindParam(':value_tow', $value_tow, PDO::PARAM_STR);
$stmt-&gt;execute();

$stmt = $dbh -> prepare("INSERT INTO tb (column_one, column_tow)

VALUES(:value_one, :value_tow)");

$stmt->bindParam(':value_one', $value_one, PDO::PARAM_STR);

$stmt->bindParam(':value_tow', $value_tow, PDO::PARAM_STR);

$stmt->execute();

あんまり長いことは書けないブログ

プログラマーです。主にコードの話し。たまに私生活の話し。完全に只の個人ブログです。

Menu

Use pdo with mysql – php