php - mysqli bind variables -


I have this partial code:

  if ($ getRecords = $ con- & Gt; Create ("Choose which one from Auction article =?")) {$ GetHtml = $ con- & gt; Prepare ("Choose from ARTICLE_DESC, where ARTICLE_NO =?"); $ GetHtml-> Tie-up ("i", $ pk); $ GetHtml-> Executed (); $ GetHtml-> Bind_result ($ ARTICLE_DESC); $ GetRecords- & gt; Bind_param ("i", $ pk); $ GetRecords- & gt; Executed (); $ GetRecords- & gt; Bind_salt ($ ARTICLE_NO, $ ARTICLE_NAME, $ SUBTITLE, $ CURRENT_BID, $ START_PRICE, $ BID_COUNT, $ QUANT_TOTAL, $ QUANT_SOLD, $ ACCESSSTARTS, $ ACCESSENDS, $ ACCESSORIGIN_END, $ USERNAME, $ BEST_BIDDER_ID, INFINISHED, $ Watch, $ BUYITNOW_PRICE, $ PIC_URL, PRIVATE_AUCTION $ $ AUCTION_TYPE, $ ACCESSINSERT_DATE, $ ACCESSUPDATE_DATE, $ CAT_DESC, $ CAT_PATH, $ COUNTRYCODE, $ LOCATION, $ CONDITIONS, $ REVISED, $ PAYPAL_ACCEPT, $ PRE_TERMINATED, $ SHIPPING_TO, $ FEE_INSERTION, $ FEE_FINAL, $ FEE_LISTING, $ PIC_XXL, $ PIC_DIASHOW, $ PIC_COUNT, $ ITEM_SITE_ID);  

Which is otherwise ok, though I get an error:

Number of bind variable does not match the number of fields in the queue ready

I posted in the last line.

I'm not sure what the problem is. I want to separate some columns, such as ARTICLE_DESC, can not I use the selection *, and put it in the names of each column in the query?

Edit: Is it bound to be bound? Are there security or performance advantages to achieve? Do you really want to set the names of columns, rather using it? *.

In this way, you will know which column passes through the Bind_result method.


Comments