Get 1 value from db with php

Asked Jul 26 '16 at 17:08

Active Jul 26 '16 at 17:23

Viewed 28 times

So i want to search for a specific value (price) in the db like this:

<?php
include 'settings.php';

        // Create connection
        $conn = mysqli_connect($servername, $username, $password, $dbname);
        // Check connection
        if (!$conn) {
            die("Connection failed: " . mysqli_connect_error());
        }

$steamData = file_get_contents("http://steamcommunity.com/profiles/76561198258195397/inventory/json/730/2");
$data = json_decode($steamData, true);
$items = $data['rgDescriptions'];
foreach($items as $key => $item){
        $name = $item["market_hash_name"];
        $query = "SELECT price FROM itemprice WHERE market_hash_name = '$name'";
        $result = mysql_query($query) or die($query."<br/><br/>".mysql_error());
        $price = mysql_result($result, 0);
        echo '<div class="items"><center><img src="http://steamcommunity-a.akamaihd.net/economy/image/' . $item["icon_url"] . '" height="192" width="256"></center><div><center><h5 style="color:#'.$item["name_color"].'">'.$item["market_name"].'<br>'.$price.'</h5></center></div><br></div>';
    } 

mysqli_close($conn);
?>

It says: SELECT price FROM itemprice WHERE market_hash_name = StatTrak™ AK-47 | Elite Build (Well-Worn)

Access denied for user 'xxxxxxx'@'localhost' (using password: NO)

edited Jul 26 '16 at 17:23

asked Jul 26 '16 at 17:08

theofficialhb

and you never told us what the error is – Funk Forty Niner Jul 26 '16 at 17:10
@Fred-ii- edited... – theofficialhb Jul 26 '16 at 17:13
did you not connect to the db? and using the same MySQL API as the functions you're using. – Funk Forty Niner Jul 26 '16 at 17:13
`$name` is a most likely string here so it needs to be quoted and escaped if there are characters that MySQL will/may complain about. – Funk Forty Niner Jul 26 '16 at 17:14
@Fred-ii- added the whole code...idk whats the problem... – theofficialhb Jul 26 '16 at 17:14
well now you posted the db connection and mixing apis. you can't do that. You have to use the same one from connection to querying. Read http://stackoverflow.com/questions/17498216/can-i-mix-mysql-apis-in-php – Funk Forty Niner Jul 26 '16 at 17:15
@Fred-ii- thanks..sorry for being retard but could u write how should it look like? – theofficialhb Jul 26 '16 at 17:18
@Jay-Blanchard Where is the quote or backtick problem? – Jocelyn Jul 26 '16 at 17:18
Right here @Jocelyn `market_hash_name = $name";` – Jay Blanchard Jul 26 '16 at 17:21
Have you resolved the connection issue? – Jay Blanchard Jul 26 '16 at 17:24
Your using a `mysqli_*` function to connect, so `$result = mysql_query($query) ` will never work as it is a function for a different MySQL API. – Jay Blanchard Jul 26 '16 at 17:25
@theofficialhb You should fix the MySQL error first. Fred-ii told you what's wrong in his 2nd comment. – Jocelyn Jul 26 '16 at 17:25
Connection is ok it doesnt say Connection failed: ..... – theofficialhb Jul 26 '16 at 17:25

Get 1 value from db with php

0 Answers0