$query = $this -> pdo -> prepare(
'INSERT INTO customers (
ap_id,
- name
+ name,
+ ap_contact
) VALUES (
:ap_id,
- :name
+ :name,
+ :ap_contact
);'
);
$query -> bindValue(':ap_id', $customer -> getAPId());
$query -> bindValue(':name', $customer -> getName());
+ $query -> bindValue(':ap_contact', $customer -> getAPContact());
$query -> execute();
}
$query = $this -> pdo -> prepare(
'UPDATE customers
SET ap_id = :ap_id,
- name = :name
+ name = :name,
+ ap_contact = :ap_contact
WHERE id = :id'
);
$query -> bindValue(':id', $customer -> getId());
$query -> bindValue(':ap_id', $customer -> getAPId());
$query -> bindValue(':name', $customer -> getName());
+ $query -> bindValue(':ap_contact', $customer -> getAPContact());
$query -> execute();
}
$query -> execute();
$result = $query -> fetch(PDO::FETCH_ASSOC);
- $customer = new Customer($result['id'], $result['ap_id'], $result['name']);
+ $customer = new Customer($result['id'], $result['ap_id'], $result['name'], $result['ap_contact']);
$query->closeCursor();
$query -> execute();
$result = $query -> fetch(PDO::FETCH_ASSOC);
- $customer = new Customer($result['id'], $result['ap_id'], $result['name']);
+ $customer = new Customer($result['id'], $result['ap_id'], $result['name'], $result['ap_contact']);
$query->closeCursor();
$results = $query -> fetchAll(PDO::FETCH_ASSOC);
$customers = array();
foreach ($results as $result) {
- $customers[] = new Customer($result['id'], $result['ap_id'], $result['name']);
+ $customers[] = new Customer($result['id'], $result['ap_id'], $result['name'], $result['ap_contact']);
}
$query->closeCursor();