/* Create table doesn't return a resultset */ if ($maxdb->query("CREATE TABLE temp.mycity LIKE hotel.city") ===TRUE) { printf("Table mycity successfully created.\n");
}
/* Select queries return a resultset */ if ($result=$maxdb->query("SELECT name FROM hotel.city")) { printf("Select returned %d rows.\n",$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();
}
/* Create table doesn't return a resultset */ if (maxdb_query($link,"CREATE TABLE temp.mycity LIKE hotel.city") ===TRUE) { printf("Table mycity successfully created.\n");
}
/* Select queries return a resultset */ if ($result=maxdb_query($link,"SELECT name FROM hotel.city")) { printf("Select returned %d rows.\n",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 examples would produce the following output:
Table mycity successfully created.
Select returned 25 rows.