• Howdy! Welcome to our community of more than 130.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
managed wordpress hosting

PHP Table Manager script

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.
 
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?
 
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>
 
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.
 
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.
 
Back
Top