php man page for maxdb_query

Query: maxdb_query

OS: php

Section: 3

Format: Original Unix Latex Style Formatted with HTML and a Horizontal Scroll Bar

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)
Related Man Pages
maxdb_info(3) - php
maxdb_stmt_affected_rows(3) - php
maxdb_stmt_error(3) - php
maxdb_query(3) - php
maxdb_num_rows(3) - php
Similar Topics in the Unix Linux Community
city wide connection
Linux rides pillion on Mumbai city buses
divide the file into multiple files based on the city name
Implementation of a hotel registrations system
Generating file from sqlplus