Linux and UNIX Man Pages

Test Your Knowledge in Computers #951
Difficulty: Medium
The first known description of a self-reproducing computer program in science fiction was in a short story written in 1970.
True or False?
Linux & Unix Commands - Search Man Pages

maxdb_query(3) [php man page]

MAXDB_QUERY(3)								 1							    MAXDB_QUERY(3)

maxdb_query - Performs a query on the database

       Procedural style

SYNOPSIS
mixed maxdb_query (resource $link, string $query, [int $resultmode]) DESCRIPTION
Object oriented style mixed maxdb::query (string $query) The maxdb_query(3) function is used to simplify the act of performing a query against the database represented by the $link parameter. RETURN VALUES
Returns TRUE on success or FALSE on failure. For SELECT, SHOW, DESCRIBE or EXPLAINmaxdb_query(3) will return a result resource. EXAMPLES
Example #1 Object oriented style <?php $maxdb = new maxdb("localhost", "MONA", "RED", "DEMODB"); /* check connection */ if (maxdb_connect_errno()) { printf("Connect failed: %s ", maxdb_connect_error()); exit(); } /* Create table doesn't return a resultset */ if ($maxdb->query("CREATE TABLE temp.mycity LIKE hotel.city") === TRUE) { printf("Table mycity successfully created. "); } /* Select queries return a resultset */ if ($result = $maxdb->query("SELECT name FROM hotel.city")) { printf("Select returned %d rows. ", $result->num_rows); /* free result set */ $result->close(); } /* If we have to retrieve large amount of data we use MAXDB_USE_RESULT */ if ($result = $maxdb->query("SELECT * FROM hotel.city", MAXDB_USE_RESULT)) { $result->close(); } $maxdb->close(); ?> Example #2 Procedural style <?php $link = maxdb_connect("localhost", "MONA", "RED", "DEMODB"); /* check connection */ if (maxdb_connect_errno()) { printf("Connect failed: %s ", maxdb_connect_error()); exit(); } /* Create table doesn't return a resultset */ if (maxdb_query($link, "CREATE TABLE temp.mycity LIKE hotel.city") === TRUE) { printf("Table mycity successfully created. "); } /* Select queries return a resultset */ if ($result = maxdb_query($link, "SELECT name FROM hotel.city")) { printf("Select returned %d rows. ", maxdb_num_rows($result)); /* free result set */ maxdb_free_result($result); } /* If we have to retrieve large amount of data we use MAXDB_USE_RESULT */ if ($result = maxdb_query($link, "SELECT * FROM hotel.city", MAXDB_USE_RESULT)) { maxdb_free_result($result); } maxdb_close($link); ?> The above example will output something similar to: Table mycity successfully created. Select returned 25 rows. SEE ALSO
maxdb_real_query(3), maxdb_multi_query(3), maxdb_free_result(3). PHP Documentation Group MAXDB_QUERY(3)

Check Out this Related Man Page

MAXDB_REAL_ESCAPE_STRING(3)						 1					       MAXDB_REAL_ESCAPE_STRING(3)

maxdb_real_escape_string - Escapes special characters in a string for use in an SQL statement, taking into account the current charset of the con-
nection

       Procedural style

SYNOPSIS
string maxdb_real_escape_string (resource $link, string $escapestr) DESCRIPTION
Object oriented style string maxdb::real_escape_string (string $escapestr) This function is used to create a legal SQL string that you can use in an SQL statement. The string escapestr is encoded to an escaped SQL string, taking into account the current character set of the connection. Characters encoded are ', ". RETURN VALUES
Returns an escaped string. EXAMPLES
Example #1 Object oriented style <?php $maxdb = new maxdb("localhost", "MONA", "RED", "DEMODB"); /* check connection */ if (maxdb_connect_errno()) { printf("Connect failed: %s ", maxdb_connect_error()); exit(); } $maxdb->query("CREATE TABLE temp.mycity LIKE hotel.city"); $city = "'s Hertogenbosch"; /* this query will fail, cause we didn't escape $city */ if (!$maxdb->query("INSERT into temp.mycity VALUES ('11111','$city','NY')")) { printf("Error: %s ", $maxdb->sqlstate); } $city = $maxdb->real_escape_string($city); /* this query with escaped $city will work */ if ($maxdb->query("INSERT into temp.mycity VALUES ('22222','$city','NY')")) { printf("%d Row inserted. ", $maxdb->affected_rows); } $maxdb->close(); ?> Example #2 Procedural style <?php $link = maxdb_connect("localhost", "MONA", "RED", "DEMODB"); /* check connection */ if (maxdb_connect_errno()) { printf("Connect failed: %s ", maxdb_connect_error()); exit(); } maxdb_query($link, "CREATE TABLE temp.mycity LIKE hotel.city"); $city = "'s Hertogenbosch"; /* this query will fail, cause we didn't escape $city */ if (!maxdb_query($link, "INSERT into temp.mycity VALUES ('11111','$city','NY')")) { printf("Error: %s ", maxdb_sqlstate($link)); } $city = maxdb_real_escape_string($link, $city); /* this query with escaped $city will work */ if (maxdb_query($link, "INSERT into temp.mycity VALUES ('22222','$city','NY')")) { printf("%d Row inserted. ", maxdb_affected_rows($link)); } maxdb_close($link); ?> The above example will output something similar to: Warning: maxdb_query(): -5016 POS(43) Missing delimiter: ) <...> Error: 42000 1 Row inserted. SEE ALSO
maxdb_character_set_name(3). PHP Documentation Group MAXDB_REAL_ESCAPE_STRING(3)

Featured Tech Videos