Login   Register  
PHP Classes
elePHPant
Icontem

File: example.php

Recommend this page to a friend!
Stumble It! Stumble It! Bookmark in del.icio.us Bookmark in del.icio.us
  Classes of zandor  >  MySQL Babel  >  example.php  >  Download  
File: example.php
Role: Example script
Content type: text/plain
Description: input form example
Class: MySQL Babel
Turn native language sentences into MySql queries
Author: By
Last change: no
Date: 8 years ago
Size: 2,855 bytes
 

Contents

Class file image Download
<html>
<head>
<link rel="stylesheet" type="text/css" href="style.css" />
<style type="text/css">
input
{
    font-family:tahoma;
    font-size:9pt;
}
body
{
    font-family:tahoma;
    font-size:9pt;
}
</style>
</head>
<body bgcolor="white">
<div style="border:1pt solid black; padding:4pt; background: #00e300; width: 400pt;">

    <div style="border:1pt solid #00c300; background:#00d300; text-align:center; color:yellow; font-weight:bold; font-family:arial;font-size:9pt;">
        MySQL Translator example
    </div>

    <div style="height:15pt;">
    </div>

<form method="post" action="example.php" name="exampleform">

      Insert below the query and choose the language<br/>      
      <input size="60" name="queryINPUT" value="">
      
      <select name="langCOMBO">
<?php

$native_lang 
$_POST['langCOMBO'] ;

if ( 
strcmp$native_lang"fr" ) == ) echo "<option selected value=\"fr\">French";
else echo 
"<option value=\"fr\">French"

if ( 
strcmp$native_lang"en" ) == ) echo "<option selected value=\"en\">English";
else echo 
"<option value=\"en\">English"

if ( 
strcmp$native_lang"de" ) == ) echo "<option selected value=\"de\">German";
else echo 
"<option value=\"de\">German"

if ( 
strcmp$native_lang"it" ) == ) echo "<option selected value=\"it\">Italian";
else echo 
"<option value=\"it\">Italian"

if ( 
strcmp$native_lang"mx" ) == ) echo "<option selected value=\"mx\">Mexican";
else echo 
"<option value=\"mx\">Mexican"

if ( 
strcmp$native_lang"pl" ) == ) echo "<option selected value=\"pl\">Portuguese";
else echo 
"<option value=\"pl\">Portuguese"

?>

      </select>

      <input type="submit" value="Submit">
</form>

<?php

$query 
$_POST['queryINPUT'] ;
$native_lang $_POST['langCOMBO'] ;

if ( 
strlen$query ) == ) return ;

////////////// Embedding MySQL translator class into this code //////////
require_once('mysql_babel.php');

$tr = new mysql_babel"localhost""sample""root""f1r5t3d" );
$lang = new languages$native_lang );

if ( !( 
$lang->isClassOperative() ) )
{
    echo 
"<font color=\"red\"><b>".$lang->getErrMsg()."</b></font>" ;
    return ;
}

$tr->insert_language_code$native_lang );

$tr->native_dictionary_array $lang->get_native_dictionary() ;
$tr->mysql_dictionary_array $lang->get_mysql_dictionary() ;
$tr->errors_messages_array $lang->get_errors_array() ;

$tr->insert_mysql_source_cmdline$query );

$tr->translate();

$sqlQRY $tr->get_mysql_translated_cmdline() ;
$query $tr->get_mysql_source_cmdline() ;

echo 
"NATIVE LANGUAGE FILE : <b>$native_lang.php</b><br/>\n" ;
echo 
"ORIGINAL QUERY FORM : <b>$query</b><br/>\n" ;
echo 
"MYSQL QUERY FORM : <b>$sqlQRY</b><br/><br/>\n" ;

$tr->run_querytrue );

?>

</div>
</body>
</html>