$connection = new Mysqltcs($db['host'], $db['user'] . "wrong", $db['psw'], $db['db']);
} catch (MysqltcsException $e) {
print "Error on connection caught<br/>\n";
print $e->getMessage() . "<br/>\n";
}
print "<h3>Correct data</h3>\n";
//correct connection
try {
$connection = new Mysqltcs($db['host'], $db['user'], $db['psw'], $db['db']);
print "No error<br/>\n";
} catch (MysqltcsException $e) {
}
print "<h2>Simple query</h2>\n";
print "<h3>Correct query(show tables)</h3>\n";
//simple query
$results = $connection->executeQuery("show tables");
while ($row = $results->fetch_array()) {
print $row[0] . "<br/>\n";
}
print "<h3>Error on query</h3>\n";
//if an error is occurred mysqltcs throw an exception
try {
$results = $connection->executeQuery("No sql");
} catch (MysqltcsException $e) {
print "Error on query caught<br/>\n";
print $e->getMessage() . "<br/>\n";
}
print "<h1>Simple operations</h1>\n";
//now we use MysqltcsOperations that allows to make common operations immediately in a specified table
$operations = new MysqltcsOperations($connection, $db['tables']['test1']);
print "<h2>Insert</h2>\n";
* GNU General Public License for more details.
* You should have received a copy of the GNU General Public License
* along with this program; if not, write to the Free Software
* Foundation, Inc., 51 Franklin Street, Fifth Floor, Boston, MA 02110-1301, USA.
*/
use it\thecsea\mysqltcs\Mysqltcs;
use it\thecsea\mysqltcs\SimpleLogger;
use it\thecsea\mysqltcs\MysqltcsException;
require_once __DIR__ . "/../vendor/autoload.php";
$db = (require __DIR__ . "/config.php");
$connection = new Mysqltcs($db['host'], $db['user'], $db['psw'], $db['db'], false);
print "create logger<br>\n";
//you can create your logger that implements MysqltcsLogger
$logger = new SimpleLogger();
$connection->setLogger($logger);
//you can als do in the following way: $connection->setSimpleLogger() and get logger with $connection->getLogger();
print "Simple correct query<br/>\n";
$connection->executeQuery("show tables");
print "Query with error<br/>\n";
try {
$connection->executeQuery("no sql");
} catch (MysqltcsException $e) {
}
print "Log data<br/>\n";
$data = $logger->getLogArray();
foreach ($data as $ele) {
print $ele . "<br/>\n";
}
print "if you use simpleLogger, you can also print the log when the query is performed<br/>\n";
$logger->setPrint(true);
$connection->executeQuery("show tables");
