Skip to content

pdo-join

Directory actions

More options

Directory actions

More options

Latest commit

 

History

History
 
 

pdo-join

Folders and files

NameName
Last commit message
Last commit date

parent directory

..
figures
figures
 
 
readme.md
readme.md
 
 

readme.md

PDO JOIN

img.png

INNER JOIN
$sql = "SELECT page_category, ptc.page_title FROM page 
        INNER JOIN page_to_content ptc on page.page_id = ptc.page_id
        WHERE page_type = 'service'";


$query = $db->query($sql);

if ( $query->rowCount() ){
    print_r($query->fetchAll(PDO::FETCH_ASSOC));
}
LEFT JOIN
$sql = "SELECT page_category, ptc.page_title FROM page 
        LEFT JOIN page_to_content ptc on page.page_id = ptc.page_id
        WHERE page_type = 'service'";


$query = $db->query($sql);

if ( $query->rowCount() ){
    print_r($query->fetchAll(PDO::FETCH_ASSOC));
}
RIGHT JOIN
$sql = "SELECT page_category, ptc.page_title FROM page 
        RIGHT JOIN page_to_content ptc on page.page_id = ptc.page_id
        WHERE page_type = 'service'";


$query = $db->query($sql);

if ( $query->rowCount() ){
    print_r($query->fetchAll(PDO::FETCH_ASSOC));
}

Derste Kullanılan Tabloyu Eklemek İçin SQL Komutunu Kullanın

CREATE TABLE IF NOT EXISTS groups (
	gorup_id INT(1) AUTO_INCREMENT,
  group_name VARCHAR(50),
	PRIMARY KEY (gorup_id)
);

INSERT INTO groups (group_name) VALUES ('PHP Developer'),('Javascript Developer'),('C# Developer'),('Java Developer'),('React Developer');