Php coding 
Author: Errol W.
Visited 1351,
Followers 1,
Shared 0
I am using this code:
<php?
$database = "databasename"
$servername = "localhost";
$username = "username";
$password = "password";
// Create connection
$conn = new mysqli($database, $servername, $username, $password);
// Check connection
if ($conn->connect_error) {
die("Connection failed: " . $conn->connect_error);
}
echo "Connected successfully";
SELECT `value` FROM `cartinvoice_addresses` WHERE `field_id` = "Name" ;
?>
If you this link dbViewer - Delta Dream (dreamfoundationmobileal.org)
Part of code is display and nothing from database.
Please help.
Posted on the
Is PHP included and enabled in your hoster package?
If yes, which PHP version is running on your server?
In the first line you forgot the semicolon, I think. Correctly it should read like
$database = "databasename";
Author
PHP version 7.3.27
Don't forget to generate your page with PHP extension... By default it is HTML
the given page is with php extension...
Author
The php extention is used.
Did you check the missing semikolon behind the $database definition?
Author
I fixed that, but made no difference.
Author
So I got rid of the connection part of the code. Now, page comes up blank.
<php?
$database = "databasename"
$servername = "localhost";
$username = "username";
$password = "password";
SELECT `value` FROM `cartinvoice_addresses` WHERE `field_id` = "Name" ;
?>
dbViewer - Delta Dream (dreamfoundationmobileal.org)
you defined the server name with localhost. Is that correct? It is usual that the database is on your web space with your web host or provider.
Author
I started out using the database viewer built in to X5. When setting that up, it was using localhost. I assumed I could do the same.
Try to put the IP of your database web hosting and not the DB name wichi is not propaged into the DNS for a remote connection. Works ONLY when you try directly from the provider.
You cannot used the IP of your DB from locally testing. this one is not reachable from external ... Only localhost in this case.
Author
I put in the ip address for the server name. It still comes up with a blank page.
Into your original post the SELECT is wrong
SELECT `value` FROM `cartinvoice_addresses` WHERE `field_id` = "Name" ;
good one is:
SELECT `value` FROM `cart_invoice_addresses` WHERE `field_id` = "Name" ;
I suggest to you to test your code into a standalone PHP file without WSX5
You have many errors into your code
// Create connection - wrong syntax
$conn = new mysqli($database, $servername, $username, $password);
// First line is wrong syntax
<php?
// SELECT syntax seems wrong
SELECT `value` FROM `cartinvoice_addresses` WHERE `field_id` = "Name" ;
$result = $conn->query("SELECT 'value' .......
When your code is OK into standalone file, use it into WSX5
Enjoy!
Axel
This code is working locally without WSX5 into a PHP extension file.
<!DOCTYPE html>
<?php
$dbname = "afs_demo";
$servername = "localhost";
$username = "root";
$password = "password";
// Create connection
$mysqli = new mysqli($servername, $username, $password, $dbname);
$mysqli -> set_charset("utf8");
// Check connection
if ($mysqli->connect_error) {
die("Connection failed: " . $mysqli->connect_error);
}
echo "Connected successfully";
$sql = "SELECT value FROM cart_invoice_addresses WHERE field_id = 'Name'" ;
// $result = $mysqli->query($sql);
$result = mysqli_query($mysqli, $sql);
// while ($row = $result->fetch_assoc()) {
while ($row = mysqli_fetch_assoc($result)) {
echo '<br>';
echo $row['value'];
}
$mysqli->close();
?>
the displaying is:
Enjoy!
Axel