Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- mysql php error - quote system
- <?php
- $DB_SERVER = "localhost";
- $DB_USER = "root";
- $DB_PASS = "";
- $DB_NAME = "test";
- $con = mysql_connect($DB_SERVER, $DB_USER, $DB_PASS);
- mysql_select_db($DB_NAME);
- $sql = mysql_query("SELECT * FROM quotes WHERE id = ".$_GET['id'], $con);
- $row = mysql_fetch_row($sql);
- $sql = mysql_query("SELECT * FROM author where aid = " . $row[1], $con);
- $row = mysql_fetch_row($sql);
- var_dump($row);
- Array
- (
- [0] => id
- [1] => quote
- [2] => aid
- )
- $sql = mysql_query("SELECT * FROM author where aid = " . $row[1], $con);
- <?php
- $_GET['id'] = 1;
- $DB_SERVER = "localhost";
- $DB_USER = "root";
- $DB_PASS = "";
- $DB_NAME = "test";
- $con = mysql_connect($DB_SERVER, $DB_USER, $DB_PASS);
- mysql_select_db($DB_NAME);
- $sql = mysql_query("SELECT * FROM quotes WHERE id = " . (int)$_GET['id'], $con); // or you can use the mysql_real_escape_string
- if(!$sql) {
- echo mysql_error($con);
- }
- $row = mysql_fetch_assoc($sql);
- mysql_free_result($sql);
- $sql = mysql_query("SELECT * FROM author where id = " . (int)$row['aid'], $con);
- if(!$sql) {
- echo mysql_error($con);
- }
- $row = mysql_fetch_assoc($sql);
- mysql_free_result($sql);
- print_r($row);
- mysql_close($con);
- $sql = mysql_query("SELECT * FROM author where aid = " . $row[1], $con);
- if ( $sql ) {
- $row = mysql_fetch_row($sql);
- }
- else {
- //error
- }
Add Comment
Please, Sign In to add comment