PHP : Function Reference : MaxDB PHP Extension : maxdb_stmt_execute PHP Examples Tutorials References

Example 1266. Object oriented style

<?php

$maxdb = new maxdb("localhost", "MONA", "RED", "DEMODB");

/* check connection */
if (maxdb_connect_errno()) {

   printf("Connect failed: %s\n", maxdb_connect_error());

   exit();

}

$maxdb->query("CREATE TABLE temp.mycity LIKE hotel.city");

/* Prepare an insert statement */
$query = "INSERT INTO temp.mycity (zip, name, state) VALUES (?,?,?)";
$stmt = $maxdb->prepare($query);

$stmt->bind_param("sss", $val1, $val2, $val3);

$val1 = '11111';
$val2 = 'Georgetown';
$val3 = 'NY';

/* Execute the statement */
$stmt->execute();

$val1 = '22222';
$val2 = 'Hubbatown';
$val3 = 'CA';

/* Execute the statement */
$stmt->execute();

/* close statement */
$stmt->close();

/* retrieve all rows from myCity */
$query = "SELECT zip, name, state FROM temp.mycity";

if ($result = $maxdb->query($query)) {

   while ($row = $result->fetch_row()) {

       printf("%s (%s,%s)\n", $row[0], $row[1], $row[2]);

   }

   /* free result set */

   $result->close();

}

/* remove table */
$maxdb->query("DROP TABLE temp.mycity");

/* close connection */
$maxdb->close();
?>

Example 1267. Procedural style

copy to clipboard

<?php

$link = maxdb_connect("localhost", "MONA", "RED", "DEMODB");

/* check connection */
if (maxdb_connect_errno()) {

   printf("Connect failed: %s\n", maxdb_connect_error());

   exit();

}

maxdb_query($link, "CREATE TABLE temp.mycity LIKE hotel.city");

/* Prepare an insert statement */
$query = "INSERT INTO temp.mycity (zip, name, state) VALUES (?,?,?)";
$stmt = maxdb_prepare($link, $query);

maxdb_stmt_bind_param($stmt, "sss", $val1, $val2, $val3);

$val1 = '11111';
$val2 = 'Georgetown';
$val3 = 'NY';

/* Execute the statement */
maxdb_stmt_execute($stmt);

$val1 = '22222';
$val2 = 'Hubbatown';
$val3 = 'CA';

/* Execute the statement */
maxdb_stmt_execute($stmt);

/* close statement */
maxdb_stmt_close($stmt);

/* retrieve all rows from myCity */
$query = "SELECT zip, name, state FROM temp.mycity";

if ($result = maxdb_query($link, $query)) {

   while ($row = maxdb_fetch_row($result)) {

       printf("%s (%s,%s)\n", $row[0], $row[1], $row[2]);

   }

   /* free result set */

   maxdb_free_result($result);

}

/* remove table */
maxdb_query($link, "DROP TABLE temp.mycity");

/* close connection */
maxdb_close($link);
?>

maxdb_stmt_execute

Executes a prepared Query (PECL maxdb:1.0-7.6.00.38)
bool maxdb_stmt_execute ( resource stmt )

Example 1266. Object oriented style

Example 1267. Procedural style

Change Language

maxdb_stmt_execute

Executes a prepared Query (PECL maxdb:1.0-7.6.00.38) bool maxdb_stmt_execute ( resource stmt )

Example 1266. Object oriented style

Example 1267. Procedural style

Change Language

Executes a prepared Query (PECL maxdb:1.0-7.6.00.38)
bool maxdb_stmt_execute ( resource stmt )