php-mysql : concat query in below code and manipulation of code

Question

here is my code

<?php
$page = isset($_POST['page']) ? intval($_POST['page']) : 1;
$rows = isset($_POST['rows']) ? intval($_POST['rows']) : 10;
$offset = ($page-1)*$rows;
$result = array();

include 'conn.php';

//$rs1 = "select CONCAT(id,' ',firstname) AS password FROM users";

$rs = mysql_query("select count(*) from users");

$row = mysql_fetch_row($rs);


$result["total"] = $row[0];
$rs = mysql_query("select * from users limit $offset,$rows");


$items = array();
while($row = mysql_fetch_object($rs)){
    array_push($items, $row);
}
$result["rows"] = $items;

echo json_encode($result);
?>

and my output is

ID   firstname     lastname  password*
 1    john          abc 
 2    don           def
 3    man           ghi

I want password to cancat with id+firstname.. help me in above code please...

Dont use mysql_query more.Try PDO

Mahmood Rehman
– Mahmood Rehman

2013-09-26 05:52:05 +00:00
Commented Sep 26, 2013 at 5:52 — Mahmood Rehman
– Mahmood Rehman, Commented Sep 26, 2013 at 5:52

Pupil · Accepted Answer · 2013-09-26 05:53:35Z

2

Corrected Code:

<?php
$page = isset($_POST['page']) ? intval($_POST['page']) : 1;
$rows = isset($_POST['rows']) ? intval($_POST['rows']) : 10;
$offset = ($page-1)*$rows;
$result = array();

include 'conn.php';

//$rs1 = "select CONCAT(id,' ',firstname) AS password FROM users";

$rs = mysql_query("select count(*) from users");

$row = mysql_fetch_row($rs);


$result["total"] = $row[0];
$rs = mysql_query("select *, CONCAT(id, firstname, password) AS pwd  from users limit $offset,$rows");


$items = array();
while($row = mysql_fetch_object($rs)){
    array_push($items, $row);
}
$result["rows"] = $items;

echo json_encode($result);

?>

answered Sep 26, 2013 at 5:53

Pupil

24k6 gold badges49 silver badges71 bronze badges

Sign up to request clarification or add additional context in comments.

4 Comments

Fluffeh Over a year ago

Whenever I see string concats in MySQL, I wish that they would include the || string operation from oracle which makes it so quick to write string concats.

Sagar Shinde Over a year ago

but no change in oputput :/

Pupil Over a year ago

You need to access $row['pwd'] because, we have used alias.

Sagar Shinde Over a year ago

@ProgrammingStudent i dint get u

Collectives™ on Stack Overflow

php-mysql : concat query in below code and manipulation of code

1 Answer 1

4 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

4 Comments

Your Answer

Sign up or log in

Post as a guest

Related