Search the Community
Showing results for tags 'select query'.
-
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'm getting and Error 500 from my server. I'm not sure why... I think it might be my code. Can someone take a look please. localhost is currently unable to handle this request. HTTP ERROR 500 <?php include("common/common.php"); include("../common/db_connector.php"); $email_sent = $_POST["inputEmail"]; $password_sent = md5($_POST["inputPassword"]); // Check database for user credentials... $sql = "SELECT * FROM users WHERE email = '$email_sent'"; $result = $conn->query($sql); if ($result->num_rows > 0) { // output data of each row while($row = $result->fetch_assoc()) { //checks for true conditions if password and meail match database...... if($email_sent == $row["email"] AND $password_sent == $row["password"]) { $_SESSION["username"] = $email_sent; echo "<script>window.location = 'dashboard/index.php';</script>"; } else { echo "<script>alert('access denied'); window.location = 'index.php';</script>"; } } } ////////////////////////////////////////////// ?>
- 5 replies
-
- error 500
- select query
-
(and 3 more)
Tagged with: