mysql - How to parse 1,2,3 string to int with PHP -

-

me 1, int (coma) 2 (int), (coma) .. from a string 1,2,3 and this is a parameter of the function that is selected from 

  where the ID is from the ID ([that string ]); Prepare the statement with

PDO .

I tried to explode it and then tried to make another variable, but still I should call STRING 1 (anti), (coma) 2 (int), (coma) < / Code> is not a string because STRING does not work here 

  SELECT * to the table WHERE id ([that string]);

You are right, IN ('1,2,3') It is not, as is IN (1,2,3) . So you can not use only one string.

If you ensure 100% that there are integers in the string and there is no chance in it, other inputs (for example, if your code string is created with those values ​​are sure to be an integer) , You can simply repeat the list in your query.

But I like to use the prepared statement when there is no guarantee that the string only is an integer.

You can create a prepared statement in which many parameters count the elements in your list. 

  function afunc ($ string) {$ array_of_values ​​= explode (",", $ string); $ Array_of_placeholders = array_fill (1, calculation ($ value), "?"); $ String_of_placeholders = intestine (",", $ array_of_placeholders); $ Sql ​​= "SELECT * to table WHERE id ($ string_of_placeholders)"; $ Stmt = $ pdo- & gt; Ready ($ sql); $ Stmt- & gt; Execute ($ array_of_values); }

MySQL does not care that the parameter value is string or integer even if you use bindParam ($ variable, PDO :: PARAM_INT) If you read the code for the PDO_mysql driver, then type logic such as PDO :: PARAM_INT is ignored, and all the parameters have been passed to the MySQL server as a string. Since they are in an integer-comparative context, the SQL parser converts them into integers (and strips any non-numeric part).


Comments

Post a Comment

Popular posts from this blog

java - org.apache.http.ProtocolException: Target host is not specified -

-
I have written a simple httprequest / response code and I am getting this error below: I used to type in my classpath httpclient, httpcore, common -Codecs and general logging. I am very new to Java and I do not know what's going on here. Please help me. code: import org.apache.http.client.HttpClient; Import org.apache.http.client.methods.HttpGet; Import org.apache.http.HttpResponse; Import org.apache.http.impl.client.HttpClientBuilder; Import org.apache.http.Header; Import org.apache.http.HttpHeaders; Public class UnshorteningUrl {public static zero main (string [] args throws exception {HttpGet request = zero; HTTP Client Client = HTTP ClientBuilder.credit (). Build (); Try {Request = New HTTP Gate ("trib.me/1lBFzSi"); HttpResponse httpResponse = client.execute (request); Header [] header = httpResponse.getHeaders (HttpHeaders.LOCATION); // Preconditions.checkState (headers.length == 1); String new url = header [0] .getValue (); System.out.println ("new url...
Read more

java - Gradle dependencies: compile project by relative path -

-
Is it possible to specify a dependency on another gradeal project in the granular (in android studios) outside the current project limits? For example, with a relative path like this: dependence {collection project ('../../ stdlib / dagger'}} MyApp (path / user / foo / workspace / mypad) The app (Path / User / Foo / Workspace / MyPass / App) And I have an Android Library Project with 3 subdomules: stdlib (path is / user / foo / Utilities (Path / User / Foo / Workspace / Stadlib / Utilis) http (Path / User / Foo / Workspace / Stadlib / HT) / Li> What I have to do is compile the Dagger, Util, http module in the MyApp project. The Stidelib Library module under heavy development And MyApp will grow in the form of Growth, so I do not want to push them into a Mewen repository. I am a little change. is likely to add another Gredle projects in some way? I will push the study library into the Maven repository after the source is in search of a temp...
Read more

ruby on rails - Object doesn't support #inspect when used with .include -

-
So I have participated in a glitch error that I do not even know how to debug. I am very new to the railing, so it has kicked my ass well when I use the .includes (school) seen by the student, it gives a blue box error, But when I look at any other model and .includes (school) , the school works just fine. class student & lt; ActiveRecord :: Base has has_many: relationships, foreign_key: "liker_id", dependent :: has_many: matches, foreign_key: "student_1_id", dependent :: deleted belong_to: school belong_to: conference belong_to: would_you_rather belong_to: home city belong_to: year is_to: Major and class school & lt; on the console activatecord :: Affiliate for the base: conference includes: respondent, class: "school", foreign_key: "rival_id" (e.g. For: School) Select SQL generated Select "School". * "School" from "school" "ID" IN (1) error message back NoMethodError: u...
Read more