how can i show sql concat on my web with php

Question

first my code:

$con = mysqli_connect("****", "*****", "*****", "practica");

if(!$con){
    die ('no se conecta revisa lo primero');
}

if ($resultado = mysqli_query($con, "SELECT concat(text,text2) AS concatenado FROM valors")){
    echo "rows: ". mysqli_num_rows($resultado);
}
mysqli_close($con);

how can i show on my webpage the number of rows? it shows nothing, also how can i make to show every concat from these to column tables (text,text2)? every one have 10 inserts and i need to show it, thanks

Have you checked for errors in the SQL? (https://stackoverflow.com/questions/17053466/how-to-display-errors-for-my-mysqli-query) — Nigel Ren, Apr 25 '20 at 11:42
no errors, just there returns nothing, but there is no fails, im on ubuntu server — hector Gallardo, Apr 25 '20 at 12:24

score 0 · Accepted Answer · answered Apr 25 '20 at 11:55

0

$servername = "localhost";
$username = "root";
$password = "";
$dbname = "test";

// Create connection
$conn = new mysqli($servername, $username, $password, $dbname);
// Check connection
if ($conn->connect_error) {
  die("Connection failed: " . $conn->connect_error);
}

$sql = "select concat(text,text2) AS concatenado from valors";
$result = $conn->query($sql);

if ($result->num_rows > 0) {
  // output data of each row
  echo "rows: " . $result->num_rows;
} else {
  echo "0 results";
}

$conn->close();

I am sure that it will work for you

answered Apr 25 '20 at 11:55

forevereffort

407
1
3
13

1

Please add some description of what you have changed which will solve the problem. – Nigel Ren Apr 25 '20 at 12:05
thanks for the answer, still it show in blank im on ubuntu server – hector Gallardo Apr 25 '20 at 12:18
Hello did you check that the service for PHP and MySQL are running on your local? – forevereffort Apr 26 '20 at 05:00

how can i show sql concat on my web with php

1 Answers1