<?PHP
//sql file. Include for all SQL projects.

$host = "mysql2.000webhost.com";
$table = "entries";
$database = "a7799063_test";
$dbusername = "a7799063_admin";
$dbpassword = "nathan51095n";



function test($data)
    {
     $num = 0;
     $str = array();
     $str = explode("---",$data);
     $num2 = count($str);
     $new_arr = array($num2,$str);
     return ($new_arr);
    }
function get_mysql_query($values1,$values2,$table)
    {
     $num = 0;
     $test2 = array();
     $test = test($values1);
     $num18 = $test[0];
     $test2 = $test[1];

     $num1 = 0;
     $test3 = array();
     $test1 = test($values2);
     $num17 = $test1[0];
     $test3 = $test1[1];

     $helper = "";
     $helper2 = "";
     do
        {
         $helper = $helper . $test2[$num] . "---";
         $num = $num + 1;
        }while($num < $num18);
        do
        {
         $helper2 = $helper2 . $test3[$num1] . "---";
         $num1 = $num1 + 1;
        }while($num1 < $num17);

        $newest_num = 0;
        $new_arr1 = array();
        $new_arr1 = explode("---",$helper);
        $new_arr2 = array();
        $new_arr2 = explode("---",$helper2);
        $new_new2 = count($new_arr2);
        $new_new = count($new_arr1);
        $returnstr = "";
        do
        {
        if($newest_num == $new_new - 2)
        {
        $returnstr = $returnstr . "'" . $new_arr2[$newest_num] . "'";
        }
        else
        {
         $returnstr = $returnstr . "'" . $new_arr2[$newest_num] . "',";
         }
         $newest_num = $newest_num +1;
        }while($newest_num < $new_new - 1);

        $str4 = "insert into " . $table .  " values(''," . $returnstr . ")";
        return($str4);
    }
function sql_return_outers($values1,$values2)
    {
     $num = 0;
     $test2 = array();
     $test = test($values1);
     $num18 = $test[0];
     $test2 = $test[1];

     $num1 = 0;
     $test3 = array();
     $test1 = test($values2);
     $num17 = $test1[0];
     $test3 = $test1[1];

     $helper = "";
     $helper2 = "";
     do
        {
         $helper = $helper . $test2[$num] . "---";
         $num = $num + 1;
        }while($num < $num18);
        do
        {
         $helper2 = $helper2 . $test3[$num1] . "---";
         $num1 = $num1 + 1;
        }while($num1 < $num17);

        $newest_num = 0;
        $new_arr1 = array();
        $new_arr1 = explode("---",$helper);
        $new_arr2 = array();
        $new_arr2 = explode("---",$helper2);
        $new_new2 = count($new_arr2);
        $new_new = count($new_arr1);
        $returnstr = '$entries = array(); ';
        do
        {
        $returnstr = $returnstr . '$entries["' . $new_arr2[$newest_num] . '"] = "' . $new_arr1[$newest_num] . '"; ';
         $newest_num = $newest_num +1;
        }while($newest_num < $new_new - 1);

        return ($returnstr);
    }
function sql_write($dbname,$dbusername,$dbpassword,$data,$values)
    {
global $host;
global $table;
$sql_code = get_mysql_query($data,$values,$table);
$connect = @mysql_connect($host,$dbusername,$dbpassword) or die("Could Not Connect");
@mysql_select_db ($dbname) or die("Could not find DataBase");
$query = mysql_query($sql_code);
if ($connect)
{
return 1;
}
else
{
return 0;
}
}
function exists($username,$dbname,$dbusername,$dbpassword,$row)
    {
global $host;
global $table;
$connect = @mysql_connect($host,$dbusername,$dbpassword) or die("Could Not Connect");
@mysql_select_db ($dbname) or die("Could not find DataBase");



$result = mysql_query("SELECT COUNT(*) FROM `" . $table . "` WHERE `" . $row ."` = '$username'");
if ($result)
{
    $row = mysql_fetch_array($result);
    $NumberOfRowsFound = $row[0];

    if ($NumberOfRowsFound > 0)
    {
        return true;
    }
    else
    {
        return false;
    }
}
else
{
    print "Query error " . mysql_error();
}
}
function sql_read($dbname,$dbusername,$dbpassword)
    {
global $host;
global $table;

$connect = @mysql_connect($host,$dbusername,$dbpassword) or die("Could Not Connect");
@mysql_select_db ($dbname) or die("Could not find DataBase");

$query = mysql_query("select * from " . $table);
$query2 = mysql_query("select * from " . $table);
$numrows = mysql_num_rows($query2);
$row1 =  mysql_fetch_assoc($query);
$arr =  array();
foreach ($row1 as $new1)
{
$arr[] = $new1;
}
$num = count($arr);
$num7 = $num;

if ($numrows > 0){




$str1 = "";
$str2 = "";
$str3 = "<table style='width:100%;' height='10' border='1' cellspacing='1'><tr>";

while ($row = mysql_fetch_assoc($query2)) {


foreach ($row as $new)
{
if($num == 0)
{
$str1 = $str1 . "</tr><tr><td align='center'>" .  $new . "</td>";
$num = $num7 - 1;
}
else
{
$str1 = $str1 . "<td align='center'>" .  $new . "</td>";
$num = $num - 1;
}
}

foreach($row as $key => $row)
{
if(strpos($str2,$key))
{
}
else
{
$str2 = $str2 . "<th height='23' scope='col'>" . $key . "</th>";
}
}
}






$new_str = $str3 . $str2 . "</tr>" .  $str1 . "</table>";
return($new_str);


}else{
$return = ("");
}
}


function sql_search($dbname,$dbusername,$dbpassword,$search)
    {
global $host;
global $table;

$connect = @mysql_connect($host,$dbusername,$dbpassword) or die("Could Not Connect");
@mysql_select_db ($dbname) or die("Could not find DataBase");

$query = mysql_query("select * from " . $table);
$query2 = mysql_query("select * from " . $table);
$numrows = mysql_num_rows($query2);
$row1 =  mysql_fetch_assoc($query);
$arr =  array();
foreach ($row1 as $new1)
{
$arr[] = $new1;
}

$num = count($arr);
$num7 = $num;

if ($numrows > 0){




$str1 = "";
$str2 = "";
$str3 = "<table style='width:100%;' height='10' border='1' cellspacing='1'><tr>";

while ($row = mysql_fetch_assoc($query2)) {
$s1 = $row["Name"];
$pos = stripos($s1, $search);
if($pos !== false)
{
foreach ($row as $new)
{
if($num == 0)
{
$str1 = $str1 . "</tr><tr><td align='center'>" .  $new . "</td>";
$num = $num7 - 1;
}
else
{
$str1 = $str1 . "<td align='center'>" .  $new . "</td>";
$num = $num - 1;
}
}
}
foreach($row as $key => $row)
{
if(strpos($str2,$key))
{
}
else
{
$str2 = $str2 . "<th height='23' scope='col'>" . $key . "</th>";
}
}
}






$new_str = $str3 . $str2 . "</tr>" .  $str1 . "</table>";
return($new_str);


}else{
$return = ("");
}
}

?>