function GetCoulmsInfo($table)
{
$tableObject = array();
$tablename = $table;
//get coulms number
$columname = QueryResult("SHOW COLUMNS FROM {$tablename}");
$columnnumber = mysql_num_rows($columname);
//end of get coulms number
//get coulm type and name
$columinfo = QueryResult("SELECT * FROM {$tablename} ");
for ($i = 0; $i < $columnnumber; $i++) {
$orginalfieldtype[] = mysql_field_type($columinfo, $i);
$fieldsname[] = mysql_field_name($columinfo, $i);
}
//this query to get the orginal data_type where in the above query the data type return blob for both (blob,text);
$OrginalDataType = QueryResult("SELECT * FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = '{$tablename}' ");
while ($row = mysql_fetch_array($OrginalDataType)) {
$fieldtype[] = $row['DATA_TYPE'];
}
//define varibal to get the ids for each tables columns and store it in session
$primrykeyname = mysql_field_name($columinfo, 0);
$tableObject['FieldType'] = $fieldtype;
$tableObject['OrginalFieldType'] = $orginalfieldtype;
$tableObject['FieldsName'] = $fieldsname;
$tableObject['primrykeyname'] = $primrykeyname;
$tableObject['columnnumber'] = $columnnumber;
return $tableObject;
}
?>
</div>
<div id="main-wrapper">
<?php
if (isset($_GET['config'])) {
$DB = $_SESSION['DataBase_Name'];
$AllFKInfo = GetAllForeginKey_Info($DB);
$Tables = Tables();
echo "<div class='col-md-12'>\n <div class='panel panel-white'>\n <div class='panel-body'>\n <div id='rootwizard'>\n <ul class='nav nav-tabs' role='tablist'>\n <li role='presentation'><a href='#tab1' data-toggle='tab'><i class='fa fa-truck m-r-xs'></i>Forgien Key Settings</a></li>\n <li role='presentation'><a href='#tab2' data-toggle='tab'><i class='fa fa-truck m-r-xs'></i>Media Settings</a></li>\n <li role='presentation'><a href='#tab3' data-toggle='tab'><i class='fa fa-truck m-r-xs'></i>Statistics Settings</a></li>\n <li role='presentation'><a href='#tab4' data-toggle='tab'><i class='fa fa-truck m-r-xs'></i>Login Settings</a></li>\n <li role='presentation'><a href='#tab5' data-toggle='tab'><i class='fa fa-truck m-r-xs'></i>Project Name Settings</a></li>\n <li role='presentation'><a href='#tab6' data-toggle='tab'><i class='fa fa-check m-r-xs'></i>Finish</a></li>\n \n </ul>\n \n \n <div class='progress progress-sm m-t-sm'>\n <div class='progress-bar progress-bar-primary' role='progressbar' aria-valuenow='20' aria-valuemin='0' aria-valuemax='100' style='width: 25%;'>\n </div>\n </div>\n <form id='wizardForm' novalidate='novalidate' action='wrtieconfigsettings.php' method='POST' >\n <div class='tab-content'>\n \n <div class='tab-pane fade' id='tab1'>\n <div class='row'><div class='col-md-8'>\n <h3>Forgien Key Display Settings</h3>\n <p>Forgien key relation is most important settings , by selecting the tablename, that has primary key as forgien key in other table , then select the display name you want insteade of this primary key </p>\n <p><label style='color:red;font-weight:bold;'>Note If you didn't choice any , then the default value will display (Primary Key).</label></p>\n </div>\n \n <div class='col-md-12'>";
foreach ($AllFKInfo as $key => $value) {
$All_FK_TableName = array_pop(explode('.', $value));
$All_FK_PrimaryID = substr($value, 0, strrpos($value, '.'));
$All_FK_DisplayFields = QueryResult("SHOW COLUMNS FROM {$All_FK_TableName}");
echo "<div class='form-group col-md-4'>\n <label for='fktablename'>Forgien Key Table</label>\n <select class='form-control' name='fktablename_" . $key . "' id='fktablename'>\n <option>Select Table</option>\n <option value='" . $All_FK_TableName . "_" . $key . "' >{$All_FK_TableName}</option>\n </select>\n </div>\n <div class='form-group col-md-4'>\n <label for='fkname'>Forgien Key </label>\n <select class='form-control' name='fkname_{$key}' id='fkname'>\n <option>Select Table</option>\n <option value='" . $All_FK_PrimaryID . "_" . $key . "' >{$All_FK_PrimaryID}</option>\n </select>\n </div>\n <div class='form-group col-md-4'>\n <label for='fkallfieldsname'>Display Field </label>\n <select class='form-control' name='fkallfieldsname_{$key}' id='fkallfieldsname'>\n <option>Select Table</option>";
while ($row = mysql_fetch_array($All_FK_DisplayFields)) {
if ($row[0] != $All_FK_PrimaryID) {
echo "<option value='" . $row[0] . "_" . $key . "'>{$row['0']}</option>";
}
}
echo "</select>\n\n </div>";
}
if (count($AllFKInfo) == 0) {
echo "<h3 style='color:red;font-weight:bold;'>You Dont have any relationship between your database tables . !</h3>";
}
echo "</div>\n \n </div>\n </div>\n <div class='tab-pane fade' id='tab2'>\n <div class='row'>\n <div class='col-md-12'>\n <p><label style='color:red;font-weight:bold;'>Note: If you didn't choice any , then the default value will be handled.</label></p>\n\n <h3>Images Settings</h3>\n <p>Images has default settings .<br/>\n 1- blob datatype (varchar and text are consider as blob , make sure the image field is not type of text ) is handeled as images upload (image link isn't physical exsist).<br/>\n 2- fieldname_Image is default value to handled images upload (physical exsist in default path (uploads/) folder ).<br/>\n 3- if you want to change the default (uploads/) directory please define it down.<br/>\n </p>\n </div>\n <div class='col-md-12'>\n <div class='form-group col-md-12'>\n <label for='fieldname_image'>Fieldname _Value</label>\n <div class='row'>\n <div class='col-md-4'>\n <input type='text' class='form-control' name='fieldname_image' id='fieldname_image' placeholder='define your image field (Optional)'>\n </div>\n \n </div>\n </div> \n <div class='form-group col-md-12'>\n <label for='uploaddirectory'>Upload Directory</label>\n <div class='row'>\n <div class='col-md-4'>\n <input type='text' class='form-control' name='uploaddirectory' id='uploaddirectory' placeholder='uploads/ (Optional)'>\n </div>\n \n </div>\n </div> \n </div>\n </div>\n\n <div class='row'>\n <div class='col-md-12'>\n <p><label style='color:red;font-weight:bold;'>Note: If you didn't choice any , then the default value will be handled.</label></p>\n\n <h3>Viedos Settings</h3>\n <p>Viedos has default settings .<br/>\n 1- fieldname_Youtube or fieldname_youtube are handled as youtube embedded (physical are not exsist on your own media server).<br/>\n 2- fieldname_Viedo or fieldname_viedo are handled as media server , that you upload at (default define as fieldname_Viedo or fieldname_Viedo) .<br/>\n 3- if you want to change the default fieldname_Viedo please define it down.<br/>\n </p>\n\n <div class='form-group col-md-12'>\n <label for='youtubefieldname'>YouTube Field Name</label>\n <div class='row'>\n <div class='col-md-4'>\n <input type='text' class='form-control' name='youtubefieldname' id='youtubefieldname' placeholder='define your YouTube field (Optional)'>\n </div>\n \n </div>\n </div> \n <div class='form-group col-md-12'>\n <label for='viedofieldname'>Viedo Field Name</label>\n <div class='row'>\n <div class='col-md-4'>\n <input type='text' class='form-control' name='viedofieldname' id='viedofieldname' placeholder='define your Viedo field (Optional)'>\n </div>\n \n </div>\n </div> \n </div>\n <div class='col-md-12'>\n\n <h3>Password Field Settings</h3>\n <p>Password has default settings .<br/>\n 1- fieldname_Password or Password Field Name are handled as type Password .\n </p>\n\n <div class='form-group col-md-12'>\n <label for='passwordfieldname'>Password Field Name</label>\n <div class='row'>\n <div class='col-md-4'>\n <input type='text' class='form-control' name='passwordfieldname' id='passwordfieldname' placeholder='define your Password field (Optional)'>\n </div>\n \n </div>\n </div> \n\n </div>\n \n </div>\n </div>\n <div class='tab-pane fade' id='tab3'>\n <div class='row'>\n <div class='col-md-8' style='margin-left:10px;'>\n <h3>Statistics Settings</h3>\n <p> You should select the table name , method , field name that you want to have a statistics information . <br/> <label style='color:red;'> Note : You can Select more than one table </label> </p>\n </div>\n \n <div class='col-md-12'>";
$AllTables = Tables();
foreach ($AllTables as $key => $value) {
echo "<div class='form-group col-md-4'>\n <label for='fktablename'>Table Name</label>\n <select class='form-control' name='statisticstablename_" . $key . "' id='sttablename'>\n <option>Select Table</option>\n <option value='{$value}' >{$value}</option>\n </select>\n </div>\n <div class='form-group col-md-4'>\n <label for='fkname'>Statistics Method </label>\n <select class='form-control' name='statisticsmethod_" . $key . "' id='stmethodname'>\n <option>Select Method</option>\n <option value='sum' >Sum</option>\n <option value='count' >Count</option>\n </select>\n </div>\n <div class='form-group col-md-4'>\n <label for='fkname'>Tables Fields </label>\n <select class='form-control' name='statisticstablefield_" . $key . "' id='tablefield'>\n <option>Select Field</option>";
