server-side processing doesn't work

server-side processing doesn't work

ralberlralberl Posts: 1Questions: 0Answers: 0
edited November 2009 in Bug reports
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.

Replies

  • allanallan Posts: 62,205Questions: 1Answers: 10,205 Site admin
    Hi ralberl,

    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
This discussion has been closed.