Hello!
There are also other Admin clients giving web interfaces without using php interface. You may find it from MySQL.com/Contrib or somewhere there. You ofcourse DONOT obviously needs a webinterface! But its practical is you are not a fan
of telnet, like me (Thanks to Alex to bring out more and more web-interfaces).
Sounds like a hot discussion pointing to the manner how the query is done! Very interesting.
Links SQL "IS NOT DATABASE name specific"! However it has restriction on the use of table names and the column names + the main KEY of the table. What you have, I think, could be a problem in the defs top lines.
$db_host = 'Your Server name of MySQL';
$db_driver = 'mysql';
$db_user = 'Your log-in name';
$db_pass = 'A full access password of yours'; with read and write + full access password
$db_key = 'ID'; Let this remain and has to be the column in the table. check here!
$db_table = 'Links'; Name of the table and it has to be the same! # check here!
$db_track = '1';
So if the name of the database did not match the value inserted above then it obviously cannot connect the server. Therefore it will generate a database connection error $e1 from DBSQL.pm as a reason.
From my Fatals in DBSQL.pm as follows ---
'CANTCONNECT' => "Unable to connect to the SQL server. Reason: $e1",
DBSQL.pm is a really nasty one that has done a lot of BARKING at me if things were somewherenot in order. It has also given me a lot of nightmares. Really wild. Only because its a very very rigid solid and strong programming. In other words, its a wealth full of extra-ordinary way of handling many functions and routines. Its the logic and the manner how a concept of the program is concieved to function.
Therefore, After creating the tables, you may be able to load the Admin_HTML.pm, but when it trys to connect for any function to perform through the following
$OBJECT = $DATABASE;
<a href="$SCRIPT_URL?db=Links&do=html_view_search">View</a><br>Further you will find every where the above in this module Admin_HTML.pm. db=Links means the table. Unfortunately db should have been used for database rather than table, but never mind. So the db variable is passed to the module and it cannot find the table Links.
It will check first from the defs what, how and method to work on a MySQL database. If the above defs lines are not correct it will obviously SHOUT, that it cannot! Alex should have defined connection errors resulting out of tables or database connections differently, but I do not know
.
Check the first lines of defs as mentioned above. I however could be completely wrong.
There are also other Admin clients giving web interfaces without using php interface. You may find it from MySQL.com/Contrib or somewhere there. You ofcourse DONOT obviously needs a webinterface! But its practical is you are not a fan
of telnet, like me (Thanks to Alex to bring out more and more web-interfaces).
Sounds like a hot discussion pointing to the manner how the query is done! Very interesting.
Links SQL "IS NOT DATABASE name specific"! However it has restriction on the use of table names and the column names + the main KEY of the table. What you have, I think, could be a problem in the defs top lines.
Code:
$db_name = 'Your database name'; $db_host = 'Your Server name of MySQL';
$db_driver = 'mysql';
$db_user = 'Your log-in name';
$db_pass = 'A full access password of yours'; with read and write + full access password
$db_key = 'ID'; Let this remain and has to be the column in the table. check here!
$db_table = 'Links'; Name of the table and it has to be the same! # check here!
$db_track = '1';
So if the name of the database did not match the value inserted above then it obviously cannot connect the server. Therefore it will generate a database connection error $e1 from DBSQL.pm as a reason.
From my Fatals in DBSQL.pm as follows ---
'CANTCONNECT' => "Unable to connect to the SQL server. Reason: $e1",
DBSQL.pm is a really nasty one that has done a lot of BARKING at me if things were somewherenot in order. It has also given me a lot of nightmares. Really wild. Only because its a very very rigid solid and strong programming. In other words, its a wealth full of extra-ordinary way of handling many functions and routines. Its the logic and the manner how a concept of the program is concieved to function.
Therefore, After creating the tables, you may be able to load the Admin_HTML.pm, but when it trys to connect for any function to perform through the following
Code:
$DATABASE = $in->param('db'); $OBJECT = $DATABASE;
<a href="$SCRIPT_URL?db=Links&do=html_view_search">View</a><br>
It will check first from the defs what, how and method to work on a MySQL database. If the above defs lines are not correct it will obviously SHOUT, that it cannot! Alex should have defined connection errors resulting out of tables or database connections differently, but I do not know
. Check the first lines of defs as mentioned above. I however could be completely wrong.
