linking the fields in php

Question

Table_gnews|
+-------------------+
| gnewsid=>int      |                
| gnewsh=>varchar   | 
| gnewsd=>varchar   | 

Data:
gnewsh:test
gnewsd:leadstart.in/blog

PHP code below

<?php

$hostname = "localhost";
$username = "gb";
$password = "123";
$dbname = "test_database";
$limitStart = $_POST['limitStart'];
$limitCount = 100;
if(isset($limitStart ) || !empty($limitStart)) {
$con = mysqli_connect($hostname, $username, $password, $dbname);
$query = "SELECT * FROM gnews ORDER BY gnewsid limit $limitStart, $limitCount";
$result = mysqli_query($con, $query);
$res = array();
while($result1 = mysqli_fetch_assoc($result)) {
$res[$result1['gnewsid']] ='<h3>' . <a href="$result1["gnewsd"]" target="_blank">"$result1["gnewsh"]"</a> . '</h3>';
}
echo json_encode($res);
}
?>

What I want: When I click "test" it will open "leadstart.in/blog" in a separate tab. I tried in this way: But no result

$res[$result1['gnewsid']] ='<h3>' . <a href="$result1["gnewsd"]" target="_blank">"$result1["gnewsh"]"</a> . '</h3>';

Where is the fault? Any Help

But no result means? what is the output you got or any error? — Nawin, Dec 07 '17 at 12:10
$res[$result1['gnewsid']] ='
' . "$result1["gnewsh"]" . '
'; would you try that? — Özgür Can Karagöz, Dec 07 '17 at 12:11
Maybe you should learn the PHP basics first, try this: `$res[$result1['gnewsid']] ='
' . '"$result1["gnewsh"]"' . '
';` — xander, Dec 07 '17 at 12:15
Also `$result1["gnewsd"]` is not working in that string if you write it like that. — xander, Dec 07 '17 at 12:16
"nothing is coming" is not very helpful.. are you calling the php page directly in the browser or through AJAX on some other site? Also there should be some errors at least with your original code that was not valid PHP. When you use a proper IDE to develop your code you can also run it directly without any browser to better find errors. — xander, Dec 07 '17 at 12:21
Your code is vulnerable to [**SQL injection**](https://en.wikipedia.org/wiki/SQL_injection) attacks. You should use prepared statements with bound parameters, via either the [**mysqli**](https://secure.php.net/manual/en/mysqli.prepare.php) or [**PDO**](https://secure.php.net/manual/en/pdo.prepared-statements.php) driver. [**This post**](https://stackoverflow.com/questions/60174/how-can-i-prevent-sql-injection-in-php) has some good examples. — Alex Howansky, Dec 07 '17 at 15:07

score 0 · Accepted Answer · answered Dec 07 '17 at 12:17

0

Try like this:

$res[$result1['gnewsid']] ='<h3> <a href="'.$result1['gnewsd'].'" target="_tab">'.$result1['gnewsh'].'</a></h3>';

answered Dec 07 '17 at 12:17

Himanshu Upadhyay

6,558
1
20
33

linking the fields in php

' . "$result1["gnewsh"]" . '

'.$result1['gnewsh'].'

' . '"$result1["gnewsh"]"' . '

1 Answers1