[Plugin: WP-Table Reloaded] Unable to implement Datatable options

Thanks for the fast answer!

Mmmmm… I thought I had a solution with your plugin…

I tried that solution, with some modifications caused by WordPress with this tuturial:

http://datatables.net/forums/discussion/1299/apply-datatables-to-a-table-created-with-php-within-a-worpress-document./p1

But even so I can´t do it…

I do all the steps and when I put the final code, inside a WP page it comes out an error caused by the EXE-Php Plugin…

I just did a quick setup using Hifi, never used it before, but it seams great!

On WP Page Editor of “/?page_id=31” I put on header with HIFI:

<?php
    wp_enqueue_script('jquery');
    wp_enqueue_script('jquery-ui-core');
    wp_head();
 ?>

<script type="text/javascript" src="/script/jquery.dataTables.min.js"></script>

Then in Page content:

Here the courses contacts:

<?php $con = mysql_connect("hostname","username","password");
                if (!$con){die('Could not connect: ' . mysql_error());}

                mysql_select_db("gogolfstats", $con);
                $result = mysql_query("SELECT * FROM clubs ORDER BY Club_Name");
                echo "<table id='table31'>
                <tr>
				<th>Club Name</th>
				<th>Country</th>
				<th>City</th>
                <th>Phone</th>
                </tr>";

                while($row = mysql_fetch_array($result))
                    {
                    echo "<tr align='center'>";
                    echo "<td>" . $row['Club_Name'] . "</td>";
                    echo "<td>" . $row['Country'] . "</td>";
                    echo "<td>" . $row['City'] . "</td>";
					echo "<td>" . "(+" . $row['Code'] . ") " . $row['Phone'] . "</td>";
                    echo "</tr>";
                        }
                    echo "</table>";

                mysql_close($con);
            ?>

<?php
jQuery(document).ready(function($) {
    $("#table31").dataTable();
});

?>

And this error comes up:

Parse error: syntax error, unexpected T_FUNCTION, expecting ‘)’ in /home/content/08/9386108/html/wp-content/plugins/exec-php/includes/runtime.php(42) : eval()’d code on line 31

And now I did exactly the same on page “?33” except the final “magic” part:

<?php
jQuery(document).ready(function($) {
    $("#table31").dataTable();
});

?>

And it comes out ok but without DataTables use…

If you can see anything I would realy apreciate!!!!

OK… i´m so dumb… I wasn´t pointing to the right directories where the datatables scripts were!!!!

Now it´s working with some mistakes, but now I think is just tuning! Part of the script is working at least.

Thanks for the help!!!!!

You are the best Tobias!!!

I read a lot of your posts (trying to solve my problem) before contacting you. Your knowledge clear explanation of the solutions you propose is great.

DataTables is really a great Plugin, How nice would it be to have a simpler form of using the plugin that automatically:

1 – Copied the files to the correct folder.
2 – Generated the code on the header of the page (like HIFI).
3 – Managed the script code of the table with on/off options.

I don´t feel this would be too dificult…

Anyway, many thanks again!!!!

I thought about something like your WP-Table Reloaded but more advanced.

I tried to use your Plugin but imagine that one of the option would be to create a table through PHP code. Using all the same options that your plugin has… this would solve it.

Another thing is having the Datatables script options as on/off options, this could be done in your WP-Table Reloaded… imagine in each table creation page you would have the DataTables on/off options in the lower part.

For a user it would be much simpler to use all the Datatables options.

Just thinking out loud… Cheers!!!

Like I read more than once: Sharing is Caring!!!!

You´ve done a great job on sharing you knowledge and your work in WP-Table Reloaded.

All the best!!!!