$row = array(); if (isset($_GET['ID'])) { $connection = mysql_connect("exampleDBaddress", "exampleDBuseranme", "exampleDBpassword"); mysql_select_db("project") or die("No such database"); $result = mysql_query("SELECT * FROM `customers` WHERE `custID` = '{$_GET['ID']}'"); mysql_close($connection); if (!(mysql_num_rows($result) == 0)) { $row = mysql_fetch_assoc($result); $c1 = new customer(); $c1->setCustID($row['custID']); $c1->setCustName($row['custName']); $c1->setCustAddress($row['custAddress']); $c1->setcustPostCode($row['custPostCode']); $c1->setcustTel($row['custTel']); $c1->setcustMob($row['custMob']); $c1->setcustType($row['custType']); $c1->setReceiverIP(long2ip($row['receiverIP'])); $c1->setReceiverType($row['receiverType']); $c1->setRouterIP(long2ip($row['routerIP'])); } else { die; } } $currentPath = "http://" . $_SERVER['SERVER_NAME'] . dirname($_SERVER['PHP_SELF']); if ($_SERVER["REQUEST_METHOD"] == "POST") { $valid = false; if (!($_POST['customerIDInput'] == null || $_POST['customerNameInput'] == null || $_POST['customerAddressInput'] == null || $_POST['customerPostcodeInput'] == null || $_POST['customerTypeInput'] == null || $_POST['receiverAddressInput'] == null || $_POST['routerAddressInput'] == null)) { $valid = true; } $errors = array('customerIDInput' => '', 'customerNameInput' => '', 'customerAddressInput' => '', 'customerPostcodeInput' => '', 'customerTelInput' => '', 'customerMobInput' => '', 'customerTypeInput' => '', 'receiverTypeInput' => '', 'receiverAddressInput' => '', 'routerAddressInput' => ''); $expressions = array('customerIDInput' => '/\\b\\d{5}\\b/', 'customerNameInput' => '/^[a-zA-Z ]*$/', 'customerAddressInput' => '/^[0-9a-zA-Z\\,\\. ]*$/m', 'customerPostcodeInput' => '/^[A-Z]{1,2}[0-9][0-9A-Z]? ?[0-9][A-Z]{2}$/', 'customerTelInput' => '/\\b\\d{11}\\b/', 'customerMobInput' => '/\\b\\d{11}\\b/', 'customerTypeInput' => '/^[a-zA-Z\\,\\. ]*$/', 'receiverTypeInput' => '/^[0-9a-zA-Z\\,\\. ]*$/', 'receiverAddressInput' => '/^\\d{1,3}\\.\\d{1,3}\\.\\d{1,3}\\.\\d{1,3}\\z/', 'routerAddressInput' => '/^\\d{1,3}\\.\\d{1,3}\\.\\d{1,3}\\.\\d{1,3}\\z/');