PHP Fetch Data From Database

Question

I'm trying to fetch data from hashtag where is #a2 or #ar hashtag but not work with my code

$sql_query = mysqli_query($conn, "SELECT * FROM posts WHERE hashtag=#a2");

Dave · Accepted Answer · 2016-07-21 05:55:23Z

2

try this,

$data = "#a2";
$sql_query = mysqli_query($conn, "SELECT * FROM posts WHERE hashtag LIKE '%$data%'");

answered Jul 21, 2016 at 5:49

Dave

3,0917 gold badges22 silver badges33 bronze badges

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

3 Comments

You forgot to remove = after hashtag

should be $data=addslashes("#a2");

If someone sees $data="#a2" and replaces it with $data="#$_GET['tag']" you get sql injection.

Saurabh · Accepted Answer · 2016-07-21 05:49:08Z

1

$sql_query = mysqli_query($conn, "SELECT * FROM posts WHERE hashtag LIKE '%#a2%'");

answered Jul 21, 2016 at 5:49

Saurabh

7841 gold badge5 silver badges15 bronze badges

Viks · Accepted Answer · 2016-07-21 06:27:36Z

0

You can also do it using your method but you just have to enclose #a2 in quotes like

$sql_query = mysqli_query($conn, "SELECT * FROM posts WHERE hashtag='#a2'");

Hope it helps

answered Jul 21, 2016 at 6:27

Viks

2371 silver badge7 bronze badges