[jamesgates1]

I have a simple select MySQL query which i need to transfer to MySQLI. I would also need to have prepared statements.

If anyone could help me please reply or PM me.

Thanks, James.

[matty9]

Ctrl-R "mysql_" with "mysqli_".

How to use prepared statements: http://php.net/manual/en/mysqli.quicksta...ements.php

[La Manifesto]

You wouldn't learn a thing if someone changed it for you. Change it yourself.

[Lumia]

I would Love to but i don't use mysql or mysqli ,i only use PDO in my websites.

[Haxalot]

I would Love to but i don't use mysql or mysqli ,i only use PDO in my websites.

If you can't help, then why bother posting?

I have a simple select MySQL query which i need to transfer to MySQLI. I would also need to have prepared statements.

If anyone could help me please reply or PM me.

Thanks, James.

Try it yourself, and if you get stuck then post back here. You'll learn a lot more by trying to do it yourself than just getting someone else to do it for you.

[Vource]

Trial, and error is the best remedy for these sort's of problem's. Did our parent's teach us to use computer's the way we use them now? No. We taught ourselves via the vast information span that was already available upon release of what we now call the "Internet".

If you are still stuck after trying to do it yourself please feel free to drop me a PM, and I'd be glad to help you out.

Good luck, and Best wishes.
~Vource :Blackhat:

[jamesgates1]

I appreciate the replies and understand i need to learn for myself but i have already tried 3 times on stack overflow with people showing me different methods. What i want to do is to receive a JSON output of all output records but currently all i receive is: "string(3) "the" string(81) "SELECT `ID`, `NewsStory`, `Summary1`, `Summary2` FROM `Articles` WHERE `Tags` = ?"". If you could give me an explanation with the edits then that would help me to understand.

PHP Code


    <?php
    //Open a new connection to the MySQL server
    $mysqli = new mysqli('localhost','createyo_james','password','createyo_TestDatabase');

    //Output any connection error
    if ($mysqli->connect_error) {
        die('Error : ('. $mysqli->connect_errno .') '. $mysqli->connect_error);
    }
    $myArray = array();
    $Tags = $_GET["Tags"];

    var_dump($_GET["Tags"]);

    $query = "SELECT `ID`, `NewsStory`, `Summary1`, `Summary2` FROM `Articles` WHERE `Tags` = ?";

    $statement = $mysqli->prepare($query);
    var_dump($query);
    //bind parameters for markers, where (s = string, i = integer, d = double,  b = blob)
    $statement->bind_param('s', $Tags);

    if($statement->execute()){
    $tempArray = array();
          while($row = $result->fetch_object()) {
                $tempArray = $row;
                array_push($myArray, $tempArray);
          }
          echo json_encode($myArray);

        $result->close();
        $mysqli->close();
        }else{
        die('Error : ('. $mysqli->errno .') '. $mysqli->error);
    }
    $statement->close();

    ?>

Thanks, James.

[MineSQL]

I appreciate the replies and understand i need to learn for myself but i have already tried 3 times on stack overflow with people showing me different methods. What i want to do is to receive a JSON output of all output records but currently all i receive is: "string(3) "the" string(81) "SELECT `ID`, `NewsStory`, `Summary1`, `Summary2` FROM `Articles` WHERE `Tags` = ?"". If you could give me an explanation with the edits then that would help me to understand.

PHP Code


    <?php
    //Open a new connection to the MySQL server
    $mysqli = new mysqli('localhost','createyo_james','password','createyo_TestDatabase');

    //Output any connection error
    if ($mysqli->connect_error) {
        die('Error : ('. $mysqli->connect_errno .') '. $mysqli->connect_error);
    }
    $myArray = array();
    $Tags = $_GET["Tags"];

    var_dump($_GET["Tags"]);

    $query = "SELECT `ID`, `NewsStory`, `Summary1`, `Summary2` FROM `Articles` WHERE `Tags` = ?";

    $statement = $mysqli->prepare($query);
    var_dump($query);
    //bind parameters for markers, where (s = string, i = integer, d = double,  b = blob)
    $statement->bind_param('s', $Tags);

    if($statement->execute()){
    $tempArray = array();
          while($row = $result->fetch_object()) {
          $tempArray = $row;
          array_push($myArray, $tempArray);
          }
          echo json_encode($myArray);

        $result->close();
        $mysqli->close();
        }else{
        die('Error : ('. $mysqli->errno .') '. $mysqli->error);
    }
    $statement->close();

    ?>

Thanks, James.

You just said that its people showing you methods on stack overflow, that doesn't sound like trying to learn for your self... This code you posted is the oop method used in mysqli. I would go with procedural if your moving from mysql_* functions.

[jamesgates1]

You just said that its people showing you methods on stack overflow, that doesn't sound like trying to learn for your self... This code you posted is the oop method used in mysqli. I would go with procedural if your moving from mysql_* functions.

Oop is seen as the best of the two

Thanks, James.