public function delete($id)
{
$ps = new PreparedStatement("DELETE FROM cities WHERE id = ?");
$ps->setInt(1, $id);
if ($this->ds->execute($ps->getSql())) {
$customerDAO = new CustomerDAO($this->ds);
$customerDAO->updateCity($id, 'NULL');
return TRUE;
}
return FALSE;
}
/**
* @return array
*/
public function getCustomer()
{
if (!isset($this->customer)) {
$this->customer = CustomerDAO::getInstance()->getCustomer($this->customerId);
}
return $this->customer;
}
require_once 'main.php';
require_once 'Connection.class.php';
require_once 'CustomerDAO.class.php';
$action = isset($_GET['action']) ? $_GET['action'] : 'new';
$id = isset($_GET['id']) ? $_GET['id'] : -1;
if ($action !== 'update' && $action !== 'new') {
die('opció invalida');
exit;
}
if ($action === 'update') {
/*if ($id <= 0) {
die 'if no valid'; exit;
}*/
$c = new Connection();
$conn = $c->getConnection();
$customerDAO = new CustomerDAO($conn);
$customer = $customerDAO->select($id);
} else {
$customer = array('id' => -1, 'name' => '', 'email' => '', 'phone' => '', 'date_end' => '', 'participants' => '', 'observations' => '');
}
$title = $action === 'new' ? 'Nova família' : 'Modificar família';
include 'head.php';
?>
<br>
<h1 class="text-center"><?php
echo $title;
?>
</h1>
case 'new':
$name = $_POST['name'] or die('nom de client no informat');
$email = isset($_POST['email']) ? $_POST['email'] : '';
$phone = isset($_POST['phone']) ? $_POST['phone'] : '';
$participants = isset($_POST['participants']) ? $_POST['participants'] : '';
$observations = isset($_POST['observations']) ? $_POST['observations'] : '';
$customer = array('id' => $id, 'name' => $name, 'email' => $email, 'phone' => $phone, 'participants' => $participants, 'observations' => $observations);
}
/*
echo 'action: '.$action;
echo '$customer';
print_r($customer);
*/
$c = new Connection();
$conn = $c->getConnection();
$customerDAO = new CustomerDAO($conn);
switch ($action) {
case 'new':
$insert_id = $customerDAO->create($customer);
break;
case 'update':
$customerDAO->update($customer);
break;
case 'delete':
//echo 'delete dao'.$id; exit;
$customerDAO->delete($id);
break;
}
if ($isAjax) {
echo json_encode($response);
exit;
<?php
require_once './header.php';
require_once './customerDAO.php';
// Database connection and function defenition
?>
<div id="content" class="clearfix">
<div class="main" style="width: 660px;">
<?php
try {
$customerDAO = new CustomerDAO();
$customers = $customerDAO->getCustomers();
if ($customers) {
echo "<table class='tableLists'>";
echo '<thead><tr><th>Full Name</th><th>Email</th><th>Username</th><th>Phone</th></tr></thead><tbody>';
foreach ($customers as $customer) {
echo '<tr>';
echo "<td style='width: 200px;'>" . $customer->getFirstName() . ' ' . $customer->getLastName() . '</td>';
echo "<td style='width: 200px;'>" . $customer->getEmailAddress() . '</td>';
echo "<td style='width: 120px;'>" . $customer->getUsername() . '</td>';
echo "<td style='width: 120px;'>" . $customer->getPhoneNumber() . '</td>';
echo '</tr>';
}
echo '</tbody></table>';
}
} catch (Exception $e) {
echo '<h3>Error on page.</h3>';
echo '<p>' . $e->getMessage() . '</p>';
}
?>
</div><!-- End Main -->
public function delete()
{
$customerDAO = new CustomerDAO(DataSource::getInstance());
$customerDAO->delete((int) $_POST['del_cust_id']);
echo '1';
}
$emsg['refer'] = 'You should select one of referrals.';
$error['refer'] = true;
}
// check if there are some errors
$errcount = 0;
foreach ($error as $er) {
if ($er == true) {
$errcount++;
break;
}
}
//if there are no errors, proceed to make a new CustomerDAO object and make insertions and queries
if ($errcount == 0) {
// The abstractDAO and customerDAO will throw exceptions if there is a problem with the database connection.
try {
$customerDAO = new CustomerDAO();
// User can not have same Username.
if (!$customerDAO->getCustomerByUsername($uname)) {
// Customer ID is defined by MySql because it is auto increasement mode.
//updated 18-04-2016: emails are hashed first ($cryptedEmail), and then inserted into the database:
if ($customerDAO->insertCustomer($fname, $lname, $phone, $cryptedEmail, $uname, $refer)) {
echo "<p class='addedCustomer'>You successfully added {$fname} {$lname} to the database</p>";
} else {
echo "<p class='error-text'> An error occured in adding {$fname} {$lname} to the database</p>";
}
} else {
$emsg['uname'] = 'User name has already registered. Please use another user name.';
$error['uname'] = true;
}
$target_file = $_FILES['myfile']['name'];
$target_path = "file/";
