WebSite X5Help Center

 
Errol W.
Errol W.
User

Php code issue  en

Auteur : Errol W.
Visité 1058, Followers 1, Partagé 0  

Here is the code I am using.

// Create connection
$conn = mysqli_connect($servername, $username, $password, $dbname);

// Check connection
if (!$conn) {
die("Connection failed: " . mysqli_connect_error());
}

$sql = "SELECT order_id, label, value FROM cartinvoice_addresses";
$result = $conn->query($sql);

if ($result->num_rows > 0) {
// output data of each row
while($row = $result->fetch_assoc()) {
echo " " . $row["label"]. " " . $row["value"] ;
if( $row["label"] = "address"){ "<br>"}
}
} else {
echo "0 results";
}
$conn->close();
?>

I added this to the original code "if( $row["label"] = "address"){ "<br>"}"  I want the output to skip a line when it finds the word "address" in the table column. When I run the process I get "This Page not working" I suspect the syntax is wrong. Help me. Without that piece of code, there is no problem.

Posté le
8 RéPONSES - 1 CORRECT
Axel  
Axel  
User

Try this:

if( $row["label"] = "address"){ echo "<br>"; }

Lire plus
Posté le de Axel  
Errol W.
Errol W.
User
Auteur

Hello Axel,

I am not getting the page not working after using your advice. However I am not getting the line break.

// Create connection
$conn = mysqli_connect($servername, $username, $password, $dbname);

// Check connection
if (!$conn) {
die("Connection failed: " . mysqli_connect_error());
}

$sql = "SELECT order_id, label, value FROM cartinvoice_addresses";
$result = $conn->query($sql);

if ($result->num_rows > 0) {
// output data of each row
while($row = $result->fetch_assoc()) {
echo " " . $row["label"]. " " . $row["value"] ;
if( $row["label"] = "address"){ echo "<br>"; }

}
} else {
echo "0 results";
}
$conn->close();
?>

Lire plus
Posté le de Errol W.
Axel  
Axel  
User

Try to modify your script with :

$conn = mysqli_connect("my_server", "user", "password", "dbname");

and to save it in PHP file like test.php

and try tu use your test.php  without WSX5. Directly from your web server like https://myserver.com/test.php

It's better to debug the PHP script outside of WSX5.

When it's run, you can add it to use it...

Hope this helps

Axel

Lire plus
Posté le de Axel  
Errol W.
Errol W.
User
Auteur

Thanks, I'll give it a go.

Lire plus
Posté le de Errol W.
Errol W.
Errol W.
User
Auteur

Oh, Yeah that much better for fixing code. Thanks

Lire plus
Posté le de Errol W.
Paul M.
Paul M.
Moderator

Hello Errol,

The comparison operator for equality in PHP is a double equals sign as opposed to a single.

Thus:

if( $row["label"] == "address")

This is why your code is failing the if statement.

Also, you might want to capitalise "address" to match what is in the MySQL database.

if( $row["label"] == "Address")

Kind regards,

Paul

Search the WebSite X5 Help Center

Lire plus
Posté le de Paul M.
Errol W.
Errol W.
User
Auteur

Paul, that did the trick.

Lire plus
Posté le de Errol W.
Paul M.
Paul M.
Moderator

Great, thanks for letting us know!

Lire plus
Posté le de Paul M.