Connection interface

Hello Ray,
I am having some problems with a connection not working.
I can remember a previous occasion when you suggested

"You should probably just create a new connection using our interface to ensure you don't have any issues moving forward.
Just use the same host, username, and password from the one provided".

Can you please say where I can find the interface ?.
Many thanks

John

========================

The error implies the file: boatsforsalenow/canal-boats.php on line 1

Has a bad file name reference (missing the .php extension?)

I'm not sure why you have a hand coded connections file, but that would definitely cause issues with using the connection in Dreamweaver as well.

Thanks Ray.
The page definitely has the .php extension please see picture.

Is the present connections file incorrect?
Is there a tutorial somewhere that shows how to use the connections file creator?

The site has been working OK until recently.

The page appears to be missing the extension... shouldn't it be:

<?php require_once('Connections/conn1_i.php'); ?>

Agreed Ray .php certainly should be there.
Strange part is there were 13 pages in all, that had the php extension missing.
The .php is there now.

Later another error message popped at the top of the index page

Warning: mysqli_error() expects exactly 1 parameter, 0 given in /homepages/37/d415519235/htdocs/boatsforsalenow/Connections/conn1_i.php on line 8

I'm not sure why you are using a hand coded connection file. I'd have to get a copy of that file to tell you what is wrong with it, but if you just used the Dreamweaver mysqli connection dialog to create your connection then I'm sure it would have the correct syntax.

Thanks Ray
A copy of the file is attached

I'm still not sure why you are using a hand coded connection file, but your syntax is wrong. The code:

if (mysqli_errno()) {
die('<p>Failed to connect to MySQL: '.mysqli_error().'</p>');
}

should be:

if (mysqli_errno($conn1_i)) {
die('<p>Failed to connect to MySQL: '.mysqli_error($conn1_i).'</p>');
}

Please see PM

Go to: WebAssist->Database->Database Connections

That will launch the connections dialog that will allow you to create the connections properly so they will be recognized by Dreamweaver.