WebSite X5Help Center

 
Errol W.
Errol W.
User

Php coding  en

Author: Errol W.
Visited 1170, 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
16 ANSWERS - 8 USEFUL
Andreas S.
Andreas S.
Moderator
Best User of the month DE

Is PHP included and enabled in your hoster package?
If yes, which PHP version is running on your server?

Read more
Posted on the from Andreas S.
Franz-Josef H.
Franz-Josef H.
Moderator

In the first line you forgot the semicolon, I think. Correctly it should read like

$database = "databasename";

Read more
Posted on the from Franz-Josef H.
Errol W.
Errol W.
User
Author

PHP version 7.3.27

Read more
Posted on the from Errol W.
Axel  
Axel  
User

Don't forget to generate your page with PHP extension... By default it is HTML

Read more
Posted on the from Axel  
Franz-Josef H.
Franz-Josef H.
Moderator

the given page is with php extension...

Read more
Posted on the from Franz-Josef H.
Errol W.
Errol W.
User
Author

The php extention is used.

Read more
Posted on the from Errol W.
Franz-Josef H.
Franz-Josef H.
Moderator

Did you check the missing semikolon behind the $database definition?

Read more
Posted on the from Franz-Josef H.
Errol W.
Errol W.
User
Author

I fixed that, but made no difference.

Read more
Posted on the from Errol W.
Errol W.
Errol W.
User
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)

Read more
Posted on the from Errol W.
Franz-Josef H.
Franz-Josef H.
Moderator

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.

Read more
Posted on the from Franz-Josef H.
Errol W.
Errol W.
User
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.

Read more
Posted on the from Errol W.
Axel  
Axel  
User

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.

Read more
Posted on the from Axel  
Errol W.
Errol W.
User
Author

I put in the ip address for the server name. It still comes up with a blank page.

Read more
Posted on the from Errol W.
Axel  
Axel  
User

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" ;

Read more
Posted on the from Axel  
Axel  
Axel  
User

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

Read more
Posted on the from Axel  
Axel  
Axel  
User

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

Read more
Posted on the from Axel