<?php $link = maxdb_connect("localhost", "MONA", "RED", "DEMODB");
if (!$link) { printf("Can't connect to localhost. Error: %s\n", maxdb_connect_error()); exit(); }
maxdb_report (MAXDB_REPORT_OFF); maxdb_query($link,"DROP TABLE mycustomer"); maxdb_report (MAXDB_REPORT_ERROR);
/* Insert rows */ maxdb_query($link, "CREATE TABLE mycustomer AS SELECT * from hotel.customer"); printf("Affected rows (INSERT): %d\n", maxdb_affected_rows($link));
maxdb_query($link, "ALTER TABLE mycustomer ADD Status int default 0");
/* update rows */ maxdb_query($link, "UPDATE mycustomer SET Status=1 WHERE cno > 50"); printf("Affected rows (UPDATE): %d\n", maxdb_affected_rows($link));
/* delete rows */ maxdb_query($link, "DELETE FROM mycustomer WHERE cno < 50"); printf("Affected rows (DELETE): %d\n", maxdb_affected_rows($link));
/* select all rows */ $result = maxdb_query($link, "SELECT title FROM mycustomer"); printf("Affected rows (SELECT): %d\n", maxdb_affected_rows($link));
maxdb_free_result($result);
/* Delete table Language */ maxdb_query($link, "DROP TABLE mycustomer");
/* close connection */ maxdb_close($link); ?>
|