PHP filetojson Examples

Example #1

File: mysql.php Project: WakeLee/mCDatabase.php

?>

<?php 
$title = "PHP / MySQL";
?>
<title><?php 
echo $title;
?>
</title>
<?php 
echo $title;
?>
<table border="1" cellspacing="5" cellpadding="5">
<?php 
$db = new mCDatabase();
$db->OpenDb(filetojson("_mysql.json"));
$rs = $db->OpenRs();
$rs->SetInt("m_tinyint", 127);
$rs->SetInt("m_smallint", 32767);
$rs->SetInt("m_int", 2147483647);
$rs->SetInt("m_bigint", 2147483647);
$rs->SetDouble("m_double", 21474.83647);
$rs->SetString("m_char5", "12345");
$rs->SetString("m_varchar5", "12345");
$rs->SetString("m_text", $title);
$rs->SetDateTime("m_datetime", "");
$rs->Insert("mctable");
$db->CloseRs($rs);
$rs = $db->OpenRs();
$rs->SetWhere("ID >= 77 and ID <= 85");
$rs->Delete("mctable");

Example #2

File: sqlserver.php Project: WakeLee/mCDatabase.php

?>

<?php 
$title = "PHP / SQLServer";
?>
<title><?php 
echo $title;
?>
</title>
<?php 
echo $title;
?>
<table border="1" cellspacing="5" cellpadding="5">
<?php 
$db = new mCDatabase();
$db->OpenDb(filetojson("_sqlserver.json"));
$rs = $db->OpenRs();
$rs->SetInt("m_tinyint", 127);
$rs->SetInt("m_smallint", 32767);
$rs->SetInt("m_int", 2147483647);
$rs->SetInt("m_bigint", 2147483647);
$rs->SetDouble("m_double", 21474.83647);
$rs->SetString("m_char5", "12345");
$rs->SetString("m_varchar5", "12345");
$rs->SetString("m_text", $title);
$rs->SetDateTime("m_datetime", "");
$rs->Insert("mctable");
$db->CloseRs($rs);
$rs = $db->OpenRs();
$rs->SetWhere("ID >= 77 and ID <= 85");
$rs->Delete("mctable");