<div id="toast-container" class="toast-top-full-width DeleteMSG" aria-live="polite" role="alert" style="display:none"><div class="toast toast-info"><div class="toast-message">Sucssesfully Record Deleted!</div></div></div> <div id="toast-container" class="toast-top-full-width UpdateMSG" aria-live="polite" role="alert" style="display:none"><div class="toast toast-info"><div class="toast-message">Sucssesfully Records Updated!</div></div></div> <div id="toast-container" class="toast-top-full-width SubmitMSG" aria-live="polite" role="alert" style="display:none"><div class="toast toast-info"><div class="toast-message">Sucssesfully Records Submited!</div></div></div> <div id="main-wrapper"> <?php if (isset($_GET['tablename'])) { //get the table name $table = $_GET['tablename']; $tableinfo = GetCoulmsInfo($table); //var_dump($tableinfo['columnnumber']); echo "<div class='col-md-12'>\n <div class='panel panel-white'>\n <div class='panel-heading clearfix'>\n <h4 class='panel-title'><a onclick=\"window.open('authentication/addnewrecord.php?tablename={$table}&newrecord','Update Records','scrollbars=1,resizable=1,width=600,height=640')\" style=\"cursor: pointer;\">Add New Record</a></h4>\n </div>\n <div class='panel-body'>\n <div class='table-responsive'>\n <table class='table table-bordered'>\n <thead>\n <tr>\n <th> Display </th>"; GetCloumName($table); echo "<th>Edit</th>\n <th>Delete</th></tr>\n </thead>\n <tbody>"; GetcolumnValue($table, @$Forgien_Key_Display_Field); echo "\n \n </tbody>\n </table>\n </div>\n </div>\n </div>\n </div>"; } else { //check statistics table @($statistics = mysql_query("SELECT * FROM statistics_settings_genericadmin")); @($statisticstable = mysql_num_rows(mysql_query("SELECT * FROM statistics_settings_genericadmin"))); if (@$statisticstable != 0) { echo "<div class='row'>"; while ($statrow = mysql_fetch_array($statistics)) { $statmethod = $statrow['methodname']; $tablename = $statrow['tablename']; $fieldname = $statrow['fieldname']; if ($statmethod == 'count') { //get count for the field from the table $statfortablesum = mysql_query("SELECT count({$fieldname}) FROM {$tablename} "); $count = mysql_result($statfortablesum, 0);
<div id="toast-container" class="toast-top-full-width SubmitMSG" aria-live="polite" role="alert" style="display:none"><div class="toast toast-info"><div class="toast-message">Sucssesfully Records Submited!</div></div></div> <div id="main-wrapper"> <?php if (isset($_GET['tablename'])) { //get the table name $table = mysql_real_escape_string($_GET['relatedinfo']); $tableinfo = GetCoulmsInfo($table); $primry = mysql_real_escape_string($_GET['relatedid']); $primaryname = mysql_real_escape_string($_GET['fkfieldname']); //var_dump($tableinfo['columnnumber']); echo "<div class='col-md-12'>\n <div class='panel panel-white'>\n <div class='panel-heading clearfix'>\n <h4 class='panel-title'><a onclick=\"window.open('ineraddnewrecord.php?tablename={$table}&relatedinfo={$table}&relatedid={$primry}&fkfieldname={$primaryname}&newrecord','Update Records','scrollbars=1,resizable=1,width=600,height=640')\" style=\"cursor: pointer;\">Add New Record</a></h4>\n </div>\n <div class='panel-body'>\n <div class='table-responsive'>\n <table class='table table-bordered'>\n <thead>\n <tr>\n <th> Display </th>"; GetCloumName($table); echo "<th>Edit</th>\n <th>Delete</th></tr>\n </thead>\n <tbody>"; GetcolumnValue($table, @$Forgien_Key_Display_Field, $primaryname, $primry); echo "\n \n </tbody>\n </table>\n </div>\n </div>\n </div>\n </div>"; } else { echo " <div class='row'>\n <div class='col-lg-3 col-md-6'>\n <div class='panel info-box panel-white'>\n <div class='panel-body'>\n <div class='info-box-stats'>\n <p class='counter'>107,200</p>\n <span class='info-box-title'>User activity this month</span>\n </div>\n <div class='info-box-icon'>\n <i class='icon-users'></i>\n </div>\n <div class='info-box-progress'>\n <div class='progress progress-xs progress-squared bs-n'>\n <div class='progress-bar progress-bar-success' role='progressbar' aria-valuenow='40' aria-valuemin='0' aria-valuemax='100' style='width: 40%'>\n </div>\n </div>\n </div>\n </div>\n </div>\n </div>\n <div class='col-lg-3 col-md-6'>\n <div class='panel info-box panel-white'>\n <div class='panel-body'>\n <div class='info-box-stats'>\n <p class='counter'>340,230</p>\n <span class='info-box-title'>Page views</span>\n </div>\n <div class='info-box-icon'>\n <i class='icon-eye'></i>\n </div>\n <div class='info-box-progress'>\n <div class='progress progress-xs progress-squared bs-n'>\n <div class='progress-bar progress-bar-info' role='progressbar' aria-valuenow='80' aria-valuemin='0' aria-valuemax='100' style='width: 80%'>\n </div>\n </div>\n </div>\n </div>\n </div>\n </div>\n <div class='col-lg-3 col-md-6'>\n <div class='panel info-box panel-white'>\n <div class='panel-body'>\n <div class='info-box-stats'>\n <p>\$<span class='counter'>653,000</span></p>\n <span class='info-box-title'>Monthly revenue goal</span>\n </div>\n <div class='info-box-icon'>\n <i class='icon-basket'></i>\n </div>\n <div class='info-box-progress'>\n <div class='progress progress-xs progress-squared bs-n'>\n <div class='progress-bar progress-bar-warning' role='progressbar' aria-valuenow='60' aria-valuemin='0' aria-valuemax='100' style='width: 60%'>\n </div>\n </div>\n </div>\n </div>\n </div>\n </div>\n <div class='col-lg-3 col-md-6'>\n <div class='panel info-box panel-white'>\n <div class='panel-body'>\n <div class='info-box-stats'>\n <p class='counter'>47,500</p>\n <span class='info-box-title'>New emails recieved</span>\n </div>\n <div class='info-box-icon'>\n <i class='icon-envelope'></i>\n </div>\n <div class='info-box-progress'>\n <div class='progress progress-xs progress-squared bs-n'>\n <div class='progress-bar progress-bar-danger' role='progressbar' aria-valuenow='50' aria-valuemin='0' aria-valuemax='100' style='width: 50%'>\n </div>\n </div>\n </div>\n </div>\n </div>\n </div>\n </div><!-- Row -->\n <div class='row'>\n <div class='col-lg-9 col-md-12'>\n <div class='panel panel-white'>\n <div class='row'>\n <div class='col-sm-8'>\n <div class='visitors-chart'>\n <div class='panel-heading'>\n <h4 class='panel-title'>Visitors</h4>\n </div>\n <div class='panel-body'>\n <div id='flotchart1'></div>\n </div>\n </div>\n </div>\n <div class='col-sm-4'>\n <div class='stats-info'>\n <div class='panel-heading'>\n <h4 class='panel-title'>Browser Stats</h4>\n </div>\n <div class='panel-body'>\n <ul class='list-unstyled'>\n <li>Google Chrome<div class='text-success pull-right'>32%<i class='fa fa-level-up'></i></div></li>\n <li>Firefox<div class='text-success pull-right'>25%<i class='fa fa-level-up'></i></div></li>\n <li>Internet Explorer<div class='text-success pull-right'>16%<i class='fa fa-level-up'></i></div></li>\n <li>Safari<div class='text-danger pull-right'>13%<i class='fa fa-level-down'></i></div></li>\n <li>Opera<div class='text-danger pull-right'>7%<i class='fa fa-level-down'></i></div></li>\n <li>Mobile & tablet<div class='text-success pull-right'>4%<i class='fa fa-level-up'></i></div></li>\n <li>Others<div class='text-success pull-right'>3%<i class='fa fa-level-up'></i></div></li>\n </ul>\n </div>\n </div>\n </div>\n </div>\n </div>\n </div>\n <div class='col-lg-3 col-md-6'>\n <div class='panel panel-white' style='height: 100%;'>\n <div class='panel-heading'>\n <h4 class='panel-title'>Server Load</h4>\n <div class='panel-control'>\n <a href='javascript:void(0);' data-toggle='tooltip' data-placement='top' title='Expand/Collapse' class='panel-collapse'><i class='icon-arrow-down'></i></a>\n <a href='javascript:void(0);' data-toggle='tooltip' data-placement='top' title='Reload' class='panel-reload'><i class='icon-reload'></i></a>\n </div>\n </div>\n <div class='panel-body'>\n <div class='server-load'>\n <div class='server-stat'>\n <span>Total Usage</span>\n <p>67GB</p>\n </div>\n <div class='server-stat'>\n <span>Total Space</span>\n <p>320GB</p>\n </div>\n <div class='server-stat'>\n <span>CPU</span>\n <p>57%</p>\n </div>\n </div>\n <div id='flotchart2'></div>\n </div>\n </div>\n </div>\n <div class='col-lg-5 col-md-6'>\n <div class='panel panel-white'>\n <div class='panel-heading'>\n <h4 class='panel-title'>Weather</h4>\n <div class='panel-control'>\n <a href='javascript:void(0);' data-toggle='tooltip' data-placement='top' title='Reload' class='panel-reload'><i class='icon-reload'></i></a>\n </div>\n </div>\n <div class='panel-body'>\n <div class='weather-widget'>\n <div class='row'>\n <div class='col-md-12'>\n <div class='weather-top'>\n <div class='weather-current pull-left'>\n <i class='wi wi-day-cloudy weather-icon'></i>\n <p><span>83<sup>°F</sup></span></p>\n </div>\n <h2 class='weather-day pull-right'>Miami, FL<br><small><b>13th April, 2015</b></small></h2>\n </div>\n </div>\n <div class='col-md-6'>\n <ul class='list-unstyled weather-info'>\n <li>Wind <span class='pull-right'><b>ESE 16 mph</b></span></li>\n <li>Humidity <span class='pull-right'><b>64%</b></span></li>\n <li>Pressure <span class='pull-right'><b>30.15 in</b></span></li>\n <li>UV Index <span class='pull-right'><b>6</b></span></li>\n </ul>\n </div>\n <div class='col-md-6'>\n <ul class='list-unstyled weather-info'>\n <li>Cloud Cover <span class='pull-right'><b>60%</b></span></li>\n <li>Ceiling <span class='pull-right'><b>17800 ft</b></span></li>\n <li>Dew Point <span class='pull-right'><b>70° F</b></span></li>\n <li>Visibility <span class='pull-right'><b>10 mi</b></span></li>\n </ul>\n </div>\n <div class='col-md-12'>\n <ul class='list-unstyled weather-days row'>\n <li class='col-xs-4 col-sm-2'><span>12:00</span><i class='wi wi-day-cloudy'></i><span>82<sup>°F</sup></span></li>\n <li class='col-xs-4 col-sm-2'><span>13:00</span><i class='wi wi-day-cloudy'></i><span>82<sup>°F</sup></span></li>\n <li class='col-xs-4 col-sm-2'><span>14:00</span><i class='wi wi-day-cloudy'></i><span>82<sup>°F</sup></span></li>\n <li class='col-xs-4 col-sm-2'><span>15:00</span><i class='wi wi-day-cloudy'></i><span>83<sup>°F</sup></span></li>\n <li class='col-xs-4 col-sm-2'><span>16:00</span><i class='wi wi-day-cloudy'></i><span>82<sup>°F</sup></span></li>\n <li class='col-xs-4 col-sm-2'><span>17:00</span><i class='wi wi-day-sunny-overcast'></i><span>82<sup>°F</sup></span></li>\n </ul>\n </div>\n </div>\n </div>\n </div>\n </div>\n </div>\n <div class='col-lg-4 col-md-6'>\n <div class='panel panel-white'>\n <div class='panel-heading'>\n <h4 class='panel-title'>Inbox</h4>\n <div class='panel-control'>\n <a href='javascript:void(0);' data-toggle='tooltip' data-placement='top' title='Reload' class='panel-reload'><i class='icon-reload'></i></a>\n </div>\n </div>\n <div class='panel-body'>\n <div class='inbox-widget slimscroll'>\n <a href='#'>\n <div class='inbox-item'>\n <div class='inbox-item-img'><img src='assets/images/avatar2.png' class='img-circle' alt=''></div>\n <p class='inbox-item-author'>Sandra Smith</p>\n <p class='inbox-item-text'>Hey! I'm working on your...</p>\n <p class='inbox-item-date'>13:40 PM</p>\n </div>\n </a>\n <a href='#'>\n <div class='inbox-item'>\n <div class='inbox-item-img'><img src='assets/images/avatar3.png' class='img-circle' alt=''></div>\n <p class='inbox-item-author'>Christopher</p>\n <p class='inbox-item-text'>I've finished it! See you so...</p>\n <p class='inbox-item-date'>13:34 PM</p>\n </div>\n </a>\n <a href='#'>\n <div class='inbox-item'>\n <div class='inbox-item-img'><img src='assets/images/avatar4.png' class='img-circle' alt=''></div>\n <p class='inbox-item-author'>Amily Lee</p>\n <p class='inbox-item-text'>This theme is awesome!</p>\n <p class='inbox-item-date'>13:17 PM</p>\n </div>\n </a>\n <a href='#'>\n <div class='inbox-item'>\n <div class='inbox-item-img'><img src='assets/images/avatar5.png' class='img-circle' alt=''></div>\n <p class='inbox-item-author'>Nick Doe</p>\n <p class='inbox-item-text'>Nice to meet you</p>\n <p class='inbox-item-date'>12:20 PM</p>\n </div>\n </a>\n <a href='#'>\n <div class='inbox-item'>\n <div class='inbox-item-img'><img src='assets/images/avatar2.png' class='img-circle' alt=''></div>\n <p class='inbox-item-author'>Sandra Smith</p>\n <p class='inbox-item-text'>Hey! I'm working on your...</p>\n <p class='inbox-item-date'>10:15 AM</p>\n </div>\n </a>\n <a href='#'>\n <div class='inbox-item'>\n <div class='inbox-item-img'><img src='assets/images/avatar4.png' class='img-circle' alt=''></div>\n <p class='inbox-item-author'>Amily Lee</p>\n <p class='inbox-item-text'>This theme is awesome!</p>\n <p class='inbox-item-date'>9:56 AM</p>\n </div>\n </a>\n </div>\n </div>\n </div>\n </div>\n <div class='col-lg-3 col-md-6'>\n <div class='panel twitter-box'>\n <div class='panel-body'>\n <div class='live-tile' data-mode='flip' data-speed='750' data-delay='3000'>\n <span class='tile-title pull-right'>New Tweets</span>\n <i class='fa fa-twitter'></i>\n <div><h2 class='no-m'>It’s kind of fun to do the impossible...</h2><span class='tile-date'>10 April, 2015</span></div>\n <div><h2 class='no-m'>Sometimes by losing a battle you find a new way to win the war...</h2><span class='tile-date'>6 April, 2015</span></div>\n </div>\n </div>\n </div>\n <div class='panel facebook-box'>\n <div class='panel-body'>\n <div class='live-tile' data-mode='carousel' data-direction='horizontal' data-speed='750' data-delay='4500'>\n <span class='tile-title pull-right'>Facebook Feed</span>\n <i class='fa fa-facebook'></i>\n <div><h2 class='no-m'>If you're going through hell, keep going...</h2><span class='tile-date'>23 March, 2015</span></div>\n <div><h2 class='no-m'>To improve is to change; to be perfect is to change often...</h2><span class='tile-date'>15 March, 2015</span></div>\n </div>\n </div>\n </div>\n </div>\n <div class='col-lg-12 col-md-12'>\n <div class='panel panel-white'>\n <div class='panel-heading'>\n <h4 class='panel-title'>Project Stats</h4>\n </div>\n <div class='panel-body'>\n <div class='table-responsive project-stats'> \n <table class='table'>\n <thead>\n <tr>\n <th>#</th>\n <th>Project</th>\n <th>Status</th>\n <th>Manager</th>\n <th>Progress</th>\n </tr>\n </thead>\n <tbody>\n <tr>\n <th scope='row'>452</th>\n <td>Mailbox Template</td>\n <td><span class='label label-info'>Pending</span></td>\n <td>David Green</td>\n <td>\n <div class='btn-group'>\n <button type='button' class='btn btn-primary btn-xs dropdown-toggle' data-toggle='dropdown' aria-expanded='false'>\n Action <span class='caret'></span>\n </button>\n <ul class='dropdown-menu' role='menu'>\n <li><a href='#'>Action</a></li>\n <li><a href='#'>Another action</a></li>\n <li class='divider'></li>\n <li><a href='#'>Separated link</a></li>\n </ul>\n </div>\n </td>\n </tr>\n <tr>\n <th scope='row'>327</th>\n <td>Wordpress Theme</td>\n <td><span class='label label-primary'>In Progress</span></td>\n <td>Sandra Smith</td>\n <td>\n <div class='progress progress-sm'>\n <div class='progress-bar progress-bar-primary' role='progressbar' aria-valuenow='60' aria-valuemin='0' aria-valuemax='100' style='width: 60%'>\n </div>\n </div>\n </td>\n </tr>\n <tr>\n <th scope='row'>226</th>\n <td>Modern Admin Template</td>\n <td><span class='label label-success'>Finished</span></td>\n <td>Chritopher Palmer</td>\n <td>\n <div class='progress progress-sm'>\n <div class='progress-bar progress-bar-success' role='progressbar' aria-valuenow='100' aria-valuemin='0' aria-valuemax='100' style='width: 100%'>\n </div>\n </div>\n </td>\n </tr>\n <tr>\n <th scope='row'>178</th>\n <td>eCommerce template</td>\n <td><span class='label label-danger'>Canceled</span></td>\n <td>Amily Lee</td>\n <td>\n <div class='progress progress-sm'>\n <div class='progress-bar progress-bar-danger' role='progressbar' aria-valuenow='20' aria-valuemin='0' aria-valuemax='100' style='width: 20%'>\n </div>\n </div>\n </td>\n </tr>\n <tr>\n <th scope='row'>157</th>\n <td>Website PSD</td>\n <td><span class='label label-info'>Testing</span></td>\n <td>Nick Doe</td>\n <td>\n <div class='progress progress-sm'>\n <div class='progress-bar progress-bar-info' role='progressbar' aria-valuenow='50' aria-valuemin='0' aria-valuemax='100' style='width: 50%'>\n </div>\n </div>\n </td>\n </tr>\n <tr>\n <th scope='row'>157</th>\n <td>Fronted Theme</td>\n <td><span class='label label-warning'>Waiting</span></td>\n <td>David Green</td>\n <td>\n <div class='progress progress-sm'>\n <div class='progress-bar progress-bar-warning' role='progressbar' aria-valuenow='70' aria-valuemin='0' aria-valuemax='100' style='width: 70%'>\n </div>\n </div>\n </td>\n </tr>\n </tbody>\n </table>\n </div>\n </div>\n </div>\n </div>\n </div>"; } //end of exsist of query string tablename ?> </div><!-- Main Wrapper --> <div class="page-footer"> <p class="no-s">2015 © Modern by Steelcoders.</p> </div> </div><!-- Page Inner --> </main><!-- Page Content --> <nav class="cd-nav-container" id="cd-nav"> <header>