Search the Community

I need to convert the following select statement to a pdo->query but have no idea how to get it working: SELECT t.id FROM ( SELECT g.* FROM location AS g WHERE g.start <= 16785408 ORDER BY g.start DESC, g.end DESC LIMIT 1 ) AS t WHERE t.end >= 16785408; Here's the code I'm trying: <?php $php_scripts = '../../php/'; require $php_scripts . 'PDO_Connection_Select.php'; require $php_scripts . 'GetUserIpAddr.php'; function mydloader($l_filename=NULL) { $ip = GetUserIpAddr(); if (!$pdo = PDOConnect("foxclone_data")) { exit; } if( isset( $l_filename ) ) { $ext = pathinfo($l_filename, PATHINFO_EXTENSION); $stmt = $pdo->prepare("INSERT INTO download (address, filename,ip_address) VALUES (?, ?, inet_aton('$ip'))"); $stmt->execute([$ip, $ext]) ; $test = $pdo->prepare("SELECT t.id FROM ( SELECT g.id FROM lookup AS g WHERE g.start <= inet_aton($ip) ORDER BY g.start DESC, g.end DESC ) AS t WHERE t.end >=inet_aton($ip)"); $test ->execute() ; $ref = $test->fetchColumn(); $ref = intval($ref); $stmt = $pdo->prepare("UPDATE download SET ref = '$ref' WHERE address = '$ip'"); $stmt->execute() ; header('Content-Type: octet-stream'); header("Content-Disposition: attachment; filename={$l_filename}"); header('Pragma: no-cache'); header('Expires: 0'); readfile($l_filename); } else { echo "isset failed"; } } mydloader($_GET["f"]); exit; It gives the following error: How do I fix this?

I am trying to run the following: $sqlErrors = ""; $query = "SELECT `name` FROM company WHERE id=".$_POST['companyID']; $result = $mysqli->query($query); $row = $result->fetch_assoc(); $company = $row['name']; $sqlErrors = $mysqli->error ? "Selecting company, id: ".$_POST['companyID'].". Error: ".$mysqli->error : ""; And am getting the following output: Fatal error: Call to undefined method mysqli::SELECT `name` FROM company WHERE id=3() I have no idea where the trailing brackets are coming from, and even tried $result = $mysqli->query("SELECT `name` FROM company WHERE id=3"); ... but get the same result. The questionable piece of code is contained within the following, in the "what company are we regestering the agent to?" section. $all_query_ok = true; $sqlErrors = ""; /* connect to the db */ $mysqli = new mysqli('localhost','riski296_dbuser','7FJTCJyMARer90oCKmyek5Cw36wXYG1etWJcOGjYONn53liYEHkTb0v74WqpVV3O', 'riski296_taxi_pim') or die('Cannot select the DB'); /* * what company are we regestering the agent to? */ $query = "SELECT `name` FROM company WHERE id=".$_POST['companyID']; $result = $mysqli->query($query); $row = $result->fetch_assoc(); $company = $row['name']; $sqlErrors = $mysqli->error ? "Selecting company, id: ".$_POST['companyID'].". Error: ".$mysqli->error : ""; /* grab the first available agnet for that company */ $agentID = -1; if ($result = $mysqli->query("SELECT id FROM agent WHERE is_active=0 AND companyID=".$_POST['companyID']." LIMIT 1")) { if($result->num_rows == 1){ /* fetch object array */ $row = $result->fetch_assoc(); $agentID = $row['id']; } else { echo "There is no agents currently entered for ".$company; exit(); } $sqlErrors .= $mysqli->error ? ". Getting agent, company id: ".$_POST['companyID'].". Error: ".$mysqli->error : ""; } /* determine what kind of connection device is being used */ $connectionDeviceID = -1; switch($_POST['connectionDeviceType']) { case "Cellular": $connectionDeviceID = $_POST['cellularConnectionDeviceID']; break; case "LAN": $connectionDeviceID = $_POST['lanConnectionDeviceID']; break; } $mysqli->autocommit(FALSE); /* * INSERT connection device being used with this PIM */ $mysqli->$query(" INSERT INTO connection_device (idDevices, device_type, idPlan) VALUES (".$connectionDeviceID.", ".$_POST['connectionDeviceType'].", ".$_POST['planID'].")") ? null : $all_query_ok = false; $sqlErrors .= $mysqli->error ? ". Inserting connection_device, connection device id: ".$connectionDeviceID.", Connection device type: ".$_POST['connectionDeviceType'].", and Plan ID: ".$_POST['planID'].". Error: ".$mysqli->error : ""; /* * INSERT PIM and associate the connection device with the PIM */ $mysqli->$query(" INSERT INTO device (idDevices, idAgent, idConnectionDevice) VALUES (".$_POST['pimID'].", NULL, ".$mysqli->insert_id.")") ? null : $all_query_ok = false; $sqlErrors .= $mysqli->error ? ". Inserting PIM, PIM id: ".$_POST['pimID'].", agent ID: NULL, and Plan ID: ".$_POST['planID'].". Error: ".$mysqli->error : ""; /* * associate the device with the company. make note of install date */ $install_date = date("Y-m-d H:i:s"); $mysqli->$query(" INSERT INTO compay_device_relation (idCompany, idDevice, install_date, location, removal_date) VALUES (".$_POST['companyID'].", ".$mysqli->insert_id.", ".$install_date.", NULL, NULL)") ? null : $all_query_ok = false; $sqlErrors .= $mysqli->error ? ". Inserting company_device_relation, idCompany: ".$_POST['companyID'].", idDevice: ".$mysqli->insert_id.", install_date: ".$install_date.", location: NULL, and removal_date: NULL. Error: ".$mysqli->error : ""; /* * check for any pre-existing errors */ if($sqlErrors != "") { echo $sqlErrors; exit(); } /* * update agent - this makes sure that the agent is still available */ $mysqli->query("UPDATE agent SET is_active=1 WHERE id=".$agentID) ? null : $all_query_ok = false; $mysqli->affected_rows == 1 ? null : $all_query_ok = false; $all_query_ok ? $mysqli->commit() : $mysqli->rollback(); $mysqli->autocommit(TRUE); $mysqli->close(); echo $all_query_ok ? "Agent added to ".$company : "failure:"; Any help is most appreciated! Thanks, Dave.