1. Howdy! Welcome to our community of more than 125.000 members devoted to web hosting. This is a great place to get special offers from web hosts and post your own requests or ads. To start posting sign up here. Cheers! /Peo, FreeWebSpace.net
    Dismiss Notice
  2. Add your web host to our brand new web hosting directory (beta).
    Dismiss Notice

PHP Table Manager script

Discussion in 'Programming Help' started by darkcurves, Jul 24, 2015.

  1. darkcurves

    darkcurves Well-Known Member NLC

    Hi guys, hope someone can give me some suggestions. I am looking for an alternative of XQTO Table Manager. It looks like an awesome script but doesn't seem to work for me. I can add records but it does not display them. I need something simple like it where i can add/edit/remove/view/search entries. Any help will be really appreciated.

    Perhaps someone can give me some pointers on how solve the issues instead, here is the script:
    http://www.keretapi.com/lineclear/tm_customer.php . When i check the database through PHPMYADMIN, the records are there but the script wont display them. Thanks.
     
  2. wswd

    wswd Premium Premium Member

    Without seeing the code, it's going to be pretty impossible to determine why the records aren't being displayed. Any chance you can post the code?
     
  3. darkcurves

    darkcurves Well-Known Member NLC

    Woops, sorry. Here is the code:

    Code:
    <?php
    
    $CONFIG['debug'] = 'on'; // on or off, if it is on all mysql errors will be reported
    
    $CONFIG['dbhostname'] = 'localhost';
    $CONFIG['dbusername'] = 'keretapi_lc';
    $CONFIG['dbpassword'] = 'erased';
    $CONFIG['dbname'] = 'keretapi_lineclearexpress';
    
    // connect to the database
    $db = mysql_connect($CONFIG['dbhostname'],$CONFIG['dbusername'],$CONFIG['dbpassword'])
    
    or displayerror('could not connect');
    mysql_select_db($CONFIG['dbname'],$db);
    
    // the name of the mysql database table
    $CONFIG['tablename'] = 'customer';
    
    // a descriptive name given to a single record table, e.g Product, Customer, News
    
    Article etc
    $CONFIG['recordname'] = 'Consignments';
    
    // the field name of the primary key in the database table
    $CONFIG['primarykey'] = 'customer_id';
    
    // the field name of the field which will be used to search for records
    $CONFIG['searchfield'] = 'company_name';
    
    $CONFIG['title'] = 'Consignments';
    
    $CONFIG['pagesize'] = 100; // how many records per page?
    
    
    $FIELDS['customer_id']['description'] = 'Customer ID';
    $FIELDS['customer_id']['listdisplay'] = 1;
    $FIELDS['customer_id']['editdisplay'] = 1;
    $FIELDS['customer_id']['editable'] = 1;
    $FIELDS['customer_id']['type'] = 'input';
    $FIELDS['customer_id']['length'] = 10;
    $FIELDS['customer_id']['required'] = 1;
    $FIELDS['customer_id']['explanation'] = '';
    
    $FIELDS['company_name']['description'] = 'Company Name';
    $FIELDS['company_name']['listdisplay'] = 1;
    $FIELDS['company_name']['editdisplay'] = 1;
    $FIELDS['company_name']['editable'] = 1;
    $FIELDS['company_name']['type'] = 'input';
    $FIELDS['company_name']['length'] = 60;
    $FIELDS['company_name']['required'] = 1;
    $FIELDS['company_name']['explanation'] = '';
    
    $FIELDS['web_address']['description'] = 'Web Address';
    $FIELDS['web_address']['listdisplay'] = 1;
    $FIELDS['web_address']['editdisplay'] = 1;
    $FIELDS['web_address']['editable'] = 1;
    $FIELDS['web_address']['type'] = 'text';
    $FIELDS['web_address']['length'] = 200;
    $FIELDS['web_address']['required'] = 1;
    $FIELDS['web_address']['explanation'] = '';
    $FIELDS['web_address']['listdisplaysize'] = '20';
    
    $FIELDS['email_address']['description'] = 'Email Address';
    $FIELDS['email_address']['listdisplay'] = 1;
    $FIELDS['email_address']['editdisplay'] = 1;
    $FIELDS['email_address']['editable'] = 1;
    $FIELDS['email_address']['type'] = 'input';
    $FIELDS['email_address']['length'] = 100;
    $FIELDS['email_address']['required'] = 1;
    $FIELDS['email_address']['explanation'] = '';
    
    $FIELDS['image1']['description'] = 'Image';
    $FIELDS['image1']['listdisplay'] = 0;
    $FIELDS['image1']['editdisplay'] = 1;
    $FIELDS['image1']['editable'] = 1;
    $FIELDS['image1']['type'] = 'directoryimage';
    $FIELDS['image1']['required'] = 0;
    $FIELDS['image1']['explanation'] = '';
    $FIELDS['image1']['imagesizes'] = array('150x150','300x300');
    $FIELDS['image1']['imagedirectory'] = 'images';
    $FIELDS['image1']['maxuploadsize'] = 1000000;
    
    
    
    ?>
    
    <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN"
    
    "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
    <html xmlns="http://www.w3.org/1999/xhtml">
    <head>
    <meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1" />
    <title><?php echo $CONFIG['title']; ?></title>
    </head>
    
    <body>
    
    <?php include('tm_files/tablemanager.php'); ?>
    
    </body>
    </html>
     
  4. darkcurves

    darkcurves Well-Known Member NLC

  5. wswd

    wswd Premium Premium Member

    Sorry for the delay. All the code sure looks good to me. I'm guessing you need to be able to do all the things you want from a webpage, just using PHPMYADMIN won't work for what you are trying to do?

    I've honestly never used any software like that. I don't know how good you are with PHP, but it might be worth the time coding something on your own.

    It's weird that you don't get any errors on the page.
     
  6. darkcurves

    darkcurves Well-Known Member NLC

    Thanks for the reply wsrd.

    I know little to none when comes to PHP. Nevertheless, it seems to work now but doesn't display all the information. Gotta fix that with trial and error. I suspect i need to edit the CSS file.

    PHPMYADMIN is just too complicated. Would like it to enter information and display them. Just something temporary till I can pay someone to write a better script for me.
     

Share This Page