server-side processing doesn't work
server-side processing doesn't work
ralberl
Posts: 1Questions: 0Answers: 0
In my server
wamp server, php v.5.3.0
mysql 5.1.36
Windows XP
but it runs fine other php's displaying the ajax table and http://localhost/phpmyadmin/index.php , too.
I changed
$gaSql['user'] = "root";
$gaSql['password'] = "";
$gaSql['db'] = "mydb";
$gaSql['server'] = "localhost";
$gaSql['type'] = "mysql";
in server_side.html
Also, doesn't run in
http://www.theskinnyscoop.com/assets/js/theskinny/dataTables-1.5/examples/data_sources/server_side.html
but runs fine in:
http://www.datatables.net/examples/data_sources/server_side.html
A big question (for me)
It seems that needs a mysql.php in this server_processing.php that doesn't come with the download.
Where can I get it?
Thank in advance.
wamp server, php v.5.3.0
mysql 5.1.36
Windows XP
but it runs fine other php's displaying the ajax table and http://localhost/phpmyadmin/index.php , too.
I changed
$gaSql['user'] = "root";
$gaSql['password'] = "";
$gaSql['db'] = "mydb";
$gaSql['server'] = "localhost";
$gaSql['type'] = "mysql";
in server_side.html
Also, doesn't run in
http://www.theskinnyscoop.com/assets/js/theskinny/dataTables-1.5/examples/data_sources/server_side.html
but runs fine in:
http://www.datatables.net/examples/data_sources/server_side.html
A big question (for me)
It seems that needs a mysql.php in this server_processing.php that doesn't come with the download.
Where can I get it?
Thank in advance.
This discussion has been closed.
Replies
The mysql.php file simply contains:
[code]
<?php
$gaSql['user'] = "";
$gaSql['password'] = "";
$gaSql['db'] = "";
$gaSql['server'] = "localhost";
$gaSql['type'] = "mysql";
?>
[/code]
The reason I've done this is so that I can have this file outside the directly that I use for DataTables, so I can simply ZIP that when making a release and not worry about giving my SQL user/pass out to the world! It's just a security precaution on my part basically.
So the obvious questions are, is the mysql_connect() working on your installation (i.e. is the user correctly set up on the server with the correct permissions etc), is there a database it can read, it is correctly reading the database? etc.
Regards,
Allan