Is question mark really need when select all row in prepared statement?












1















I wonder if I still need question mark if I don't want to specify any row. Because bind_param needs it.



$zr="0";
$stmt=$mysqli->prepare("select * from products_db where not prd_id=?");
$stmt->bind_param("i",$zr);//can I skip this line or what?


I search everywhere but there's no such a thing. Once I tried without ? it errors without reason. I might be typo error, something?










share|improve this question




















  • 2





    FYI, no program ever "errors without reason". If you can't see the errors, it just means your environment is not configured to show them. See How to get useful error messages in PHP? and How to get MySQLi error information in different environments

    – Phil
    Nov 27 '18 at 5:27
















1















I wonder if I still need question mark if I don't want to specify any row. Because bind_param needs it.



$zr="0";
$stmt=$mysqli->prepare("select * from products_db where not prd_id=?");
$stmt->bind_param("i",$zr);//can I skip this line or what?


I search everywhere but there's no such a thing. Once I tried without ? it errors without reason. I might be typo error, something?










share|improve this question




















  • 2





    FYI, no program ever "errors without reason". If you can't see the errors, it just means your environment is not configured to show them. See How to get useful error messages in PHP? and How to get MySQLi error information in different environments

    – Phil
    Nov 27 '18 at 5:27














1












1








1








I wonder if I still need question mark if I don't want to specify any row. Because bind_param needs it.



$zr="0";
$stmt=$mysqli->prepare("select * from products_db where not prd_id=?");
$stmt->bind_param("i",$zr);//can I skip this line or what?


I search everywhere but there's no such a thing. Once I tried without ? it errors without reason. I might be typo error, something?










share|improve this question
















I wonder if I still need question mark if I don't want to specify any row. Because bind_param needs it.



$zr="0";
$stmt=$mysqli->prepare("select * from products_db where not prd_id=?");
$stmt->bind_param("i",$zr);//can I skip this line or what?


I search everywhere but there's no such a thing. Once I tried without ? it errors without reason. I might be typo error, something?







php mysqli prepared-statement






share|improve this question















share|improve this question













share|improve this question




share|improve this question








edited Nov 27 '18 at 5:25









Phil

97.8k11141161




97.8k11141161










asked Nov 27 '18 at 4:59









WilfWilf

1,25112357




1,25112357








  • 2





    FYI, no program ever "errors without reason". If you can't see the errors, it just means your environment is not configured to show them. See How to get useful error messages in PHP? and How to get MySQLi error information in different environments

    – Phil
    Nov 27 '18 at 5:27














  • 2





    FYI, no program ever "errors without reason". If you can't see the errors, it just means your environment is not configured to show them. See How to get useful error messages in PHP? and How to get MySQLi error information in different environments

    – Phil
    Nov 27 '18 at 5:27








2




2





FYI, no program ever "errors without reason". If you can't see the errors, it just means your environment is not configured to show them. See How to get useful error messages in PHP? and How to get MySQLi error information in different environments

– Phil
Nov 27 '18 at 5:27





FYI, no program ever "errors without reason". If you can't see the errors, it just means your environment is not configured to show them. See How to get useful error messages in PHP? and How to get MySQLi error information in different environments

– Phil
Nov 27 '18 at 5:27












1 Answer
1






active

oldest

votes


















2














If you don't need to bind any parameters, you can use mysqli::query()



$result = $mysqli->query('SELECT * FROM products_db');


This both prepares and executes the SQL provided but offers no way to safely bind parameters.



This is roughly equivalent to...



$stmt = $mysqli->prepare('SELECT * FROM products_db');
$result = $stmt->execute();


which you can also use.



Note there are no positional parameters (ie ?) and therefore, no need to use mysqli_stmt::bind_param().






share|improve this answer

























    Your Answer






    StackExchange.ifUsing("editor", function () {
    StackExchange.using("externalEditor", function () {
    StackExchange.using("snippets", function () {
    StackExchange.snippets.init();
    });
    });
    }, "code-snippets");

    StackExchange.ready(function() {
    var channelOptions = {
    tags: "".split(" "),
    id: "1"
    };
    initTagRenderer("".split(" "), "".split(" "), channelOptions);

    StackExchange.using("externalEditor", function() {
    // Have to fire editor after snippets, if snippets enabled
    if (StackExchange.settings.snippets.snippetsEnabled) {
    StackExchange.using("snippets", function() {
    createEditor();
    });
    }
    else {
    createEditor();
    }
    });

    function createEditor() {
    StackExchange.prepareEditor({
    heartbeatType: 'answer',
    autoActivateHeartbeat: false,
    convertImagesToLinks: true,
    noModals: true,
    showLowRepImageUploadWarning: true,
    reputationToPostImages: 10,
    bindNavPrevention: true,
    postfix: "",
    imageUploader: {
    brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
    contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
    allowUrls: true
    },
    onDemand: true,
    discardSelector: ".discard-answer"
    ,immediatelyShowMarkdownHelp:true
    });


    }
    });














    draft saved

    draft discarded


















    StackExchange.ready(
    function () {
    StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f53493014%2fis-question-mark-really-need-when-select-all-row-in-prepared-statement%23new-answer', 'question_page');
    }
    );

    Post as a guest















    Required, but never shown

























    1 Answer
    1






    active

    oldest

    votes








    1 Answer
    1






    active

    oldest

    votes









    active

    oldest

    votes






    active

    oldest

    votes









    2














    If you don't need to bind any parameters, you can use mysqli::query()



    $result = $mysqli->query('SELECT * FROM products_db');


    This both prepares and executes the SQL provided but offers no way to safely bind parameters.



    This is roughly equivalent to...



    $stmt = $mysqli->prepare('SELECT * FROM products_db');
    $result = $stmt->execute();


    which you can also use.



    Note there are no positional parameters (ie ?) and therefore, no need to use mysqli_stmt::bind_param().






    share|improve this answer






























      2














      If you don't need to bind any parameters, you can use mysqli::query()



      $result = $mysqli->query('SELECT * FROM products_db');


      This both prepares and executes the SQL provided but offers no way to safely bind parameters.



      This is roughly equivalent to...



      $stmt = $mysqli->prepare('SELECT * FROM products_db');
      $result = $stmt->execute();


      which you can also use.



      Note there are no positional parameters (ie ?) and therefore, no need to use mysqli_stmt::bind_param().






      share|improve this answer




























        2












        2








        2







        If you don't need to bind any parameters, you can use mysqli::query()



        $result = $mysqli->query('SELECT * FROM products_db');


        This both prepares and executes the SQL provided but offers no way to safely bind parameters.



        This is roughly equivalent to...



        $stmt = $mysqli->prepare('SELECT * FROM products_db');
        $result = $stmt->execute();


        which you can also use.



        Note there are no positional parameters (ie ?) and therefore, no need to use mysqli_stmt::bind_param().






        share|improve this answer















        If you don't need to bind any parameters, you can use mysqli::query()



        $result = $mysqli->query('SELECT * FROM products_db');


        This both prepares and executes the SQL provided but offers no way to safely bind parameters.



        This is roughly equivalent to...



        $stmt = $mysqli->prepare('SELECT * FROM products_db');
        $result = $stmt->execute();


        which you can also use.



        Note there are no positional parameters (ie ?) and therefore, no need to use mysqli_stmt::bind_param().







        share|improve this answer














        share|improve this answer



        share|improve this answer








        edited Nov 27 '18 at 5:26

























        answered Nov 27 '18 at 5:19









        PhilPhil

        97.8k11141161




        97.8k11141161
































            draft saved

            draft discarded




















































            Thanks for contributing an answer to Stack Overflow!


            • Please be sure to answer the question. Provide details and share your research!

            But avoid



            • Asking for help, clarification, or responding to other answers.

            • Making statements based on opinion; back them up with references or personal experience.


            To learn more, see our tips on writing great answers.




            draft saved


            draft discarded














            StackExchange.ready(
            function () {
            StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f53493014%2fis-question-mark-really-need-when-select-all-row-in-prepared-statement%23new-answer', 'question_page');
            }
            );

            Post as a guest















            Required, but never shown





















































            Required, but never shown














            Required, but never shown












            Required, but never shown







            Required, but never shown

































            Required, but never shown














            Required, but never shown












            Required, but never shown







            Required, but never shown







            Popular posts from this blog

            A CLEAN and SIMPLE way to add appendices to Table of Contents and bookmarks

            Calculate evaluation metrics using cross_val_predict sklearn

            Insert data from modal to MySQL (multiple modal on website)