update of Editor-PHP-1.9.0 error Access denied for user 'xxxx'@'localhost' (using password NO

cpshart · April 2019

Hi

I have just transferred the latest version of the Editor software ( upgrade from Editor-PHP-1.8.1 to Editor-PHP-1.9.0 ) to my server and I am trying to view an example table on my server using the address

https://www.ukincomeinvestor.co.uk/Editor-PHP-1.9.0/examples/simple/simple.html

This is generating an error as follows

DataTables warning: table id=example - An error occurred while connecting to the database ''. The error reported by the server was: SQLSTATE[28000] [1045] Access denied for user 'ukincome'@'localhost' (using password: NO)

Do I need to make any changes to any configuration files to access the new directories to avoid this access error.

I know I will need to change my PHP scripts to reflect the new directory, but i need to overcome this error first.

Many Thanks

Colin

cpshart · April 2019

I thought I had worked out the solution, but sadly not, still looking , thanks Colin

cpshart · April 2019

I can see the relative directories are not correct, i will take another approach to integrate into my wordpress set-up, which is working connecting to the database ok.

Thanks Colin

cpshart · April 2019

I have integrated your basic example into my wordpress environment successfully but the issue and reason for looking at the example data was to display the exact layout of the table with no cell border using class="display" as defined here

https://datatables.net/examples/styling/display.html

but it still displays a cell border, i am trying to create a table as in your example, with only a row border given by class="row-border" or class="display"

here is my example code below

<html>
<head>
<title>Test Simple 2</title>
<link rel="stylesheet" type="text/css" href="https://cdn.datatables.net/1.10.19/css/jquery.dataTables.min.css" />
<script type="text/javascript"   src="https://code.jquery.com/jquery-3.3.1.js"></script>
<script type="text/javascript"   src="https://cdn.datatables.net/1.10.19/js/jquery.dataTables.min.js"></script>
</head>
    
<table id="example" class="display" style="width:100%">
        <thead>
            <tr>
                <th>Name</th>
                <th>Position</th>
                <th>Office</th>
                <th>Age</th>
                <th>Start date</th>
                <th>Salary</th>
            </tr>
        </thead>
        <tbody>
            <tr>
                <td>Tiger Nixon</td>
                <td>System Architect</td>
                <td>Edinburgh</td>
                <td>61</td>
                <td>2011/04/25</td>
                <td>$320,800</td>
            </tr>
            <tr>
                <td>Ashton Cox</td>
                <td>Junior Technical Author</td>
                <td>San Francisco</td>
                <td>66</td>
                <td>2009/01/12</td>
                <td>$86,000</td>
            </tr>
        </tbody>
        <tfoot>
            <tr>
                <th>Name</th>
                <th>Position</th>
                <th>Office</th>
                <th>Age</th>
                <th>Start date</th>
                <th>Salary</th>
            </tr>
        </tfoot>
    </table>
</html>

<script type="text/javascript">
(function($) {
$(document).ready(function() {
    $('#example').DataTable();
} );
}(jQuery));</script>

I am struggling to upload the results image file, but it shows a datatable with cell borders, which I should like to avoid if possible. Can you advise how to remove the cell borders leaving a row border only for this example, so I can apply the logic to my datatables.

Note:

changing

<

table id="example" class="display" style="width:100%">
to

<

table id="example" class="row-border" style="width:100%">

still results in a cell border, I would have thought cell-border would be mutually exclusive to row-border, how do I disable cell-border ?

Many Thanks

Colin

cpshart · April 2019

I have a solution to the problem using CSS as follows

table {
    border-width: 0 0px 0px 0;
}

th {
    border-width: 0 0px 0px 0;
}

td {
    border-width: 0 0px 0px 0;
}

the above worked for me

Sorry title bears little relation to the solution and problem

Thanks Colin

allan · April 2019

Hi,

Sorry for the delayed reply here. Good to hear you've got it working now though.

Allan

update of Editor-PHP-1.9.0 error Access denied for user 'xxxx'@'localhost' (using password NO

update of Editor-PHP-1.9.0 error Access denied for user 'xxxx'@'localhost' (using password NO

Answers

Howdy, Stranger!

Categories

DataTables

update of Editor-PHP-1.9.0 error Access denied for user 'xxxx'@'localhost' (using password NO

update of Editor-PHP-1.9.0 error Access denied for user 'xxxx'@'localhost' (using password NO

Answers

Howdy, Stranger!

Quick Links

Categories

DataTables