mysql - How to SELECT all columns FROM table LIKE ?, where user selects values -


i'm trying set html pg display 'snp' table db. i've gotten , running nicely, wanted add in feature instead of:

my $sql = "select * snp cid ? order pos limit 10";

i allows user type in keyword , pull out proper table. thought do:

sub get_snp{     $sql = "select * snp ? ? order pos limit 10";     $snp_sth = $dbh->prepare($sql);     $snp_sth->execute("$user_select","%$search_string%");

to more clear, code worked $search_string not when adding in $user_select after. here parameters:

my $search_string = param("search_for"); $user_select = param("columns");

and both parameters later called in html portion follows:

<tr bgcolor="#c0c0c0">            <td><input type="text" name="search_for"                 style="color:#787878;"                 value="enter keyword | select option"            </td>             <select name="columns">              <option selected> --select option--</option>              <option value ="cid"> cid</option>              <option value ="pos"> position #</option>              <option value ="cdspos"> cds position</option>              <option value ="m82base"> m82 base</option>              <option value ="il"> introgression line</option>              <option value ="ilbase"> il base</option>              <option value ="snptype"> snp type</option>              <option value ="aachange"> snp</option>             </select>            <td><input type="submit" value="search"></td>            <td><input type="reset" value="reset"></td>          </tr>

so above can see set droplist 8 different selections 8 different tables. again if user types in sl2.40ch12 , selects chromosome id (or cid) want data displayed, or if type in il10-1 , select introgression line (or il), data should pulled.

i may not going in right way suggestions helpful! let me know if more code or general information required :)

bound parameters (the ? doohikey) work parameter values, not table names or column names.

if want use variable table or column name, then:

  • validate it (make sure valid table, or valid column, in db)

  • interpolate sql string using regular interpolation:

    my $sql = qq[select * snp $my_col ? order pos limit 10];

Comments

Post a Comment

Popular posts from this blog

curl - PHP fsockopen help required -

i trying work on cloudflare api , have found in documentation. unfortunately have no idea how can use in fsockopen or through curl. here example of post request. need know how can make request below data post using curl or fsockopen curl https://www.cloudflare.com/api_json.html -d 'a=cache_lvl' \ -d 'tkn=8afbe6dea02407989af4dd4c97bb6e25' \ -d 'email=sample@example.com' \ -d 'z=example.com' \ -d 'v=agg' here link cloudflare https://www.cloudflare.com/docs/client-api.html#s4.2 try one: $ch = curl_init("https://www.cloudflare.com/api_json.html"); curl_setopt($ch, curlopt_returntransfer,1); curl_setopt($ch, curlopt_followlocation, 1); curl_setopt($ch, curlopt_ssl_verifypeer,false); // handling of -d curl parameter here. $param = array( 'a' => 'cache_lvl', 'tkn' => '8afbe6dea02407989af4dd4c97bb6e25', 'email' => 'sample@example.com', 'z' =...
Read more

HTTP/1.0 407 Proxy Authentication Required PHP -

i working in restricted network/limited access internet. since have use proxy make web service call. here php code calling web service , response . $client = new soapclient("http: //www.xyz.com/abc/wsdls/login.wsdl", array("trace" => 1, "exceptions" => 1, 'proxy_host' => $proxy_host, 'proxy_port' => $proxy_port, 'proxy_login' => $proxy_login, 'proxy_password' => $proxy_password)); response is fatal error: uncaught soapfault exception: [wsdl] soap-error: parsing wsdl: couldn't load ' http://www.xyz.com/abc/wsdls/login.wsdl ' : failed load external entity if copy url error message , paste in browser(with same proxy settings) works. 2nd scenario is, if pass values instead of variables giving me diffarant response $client = new soapclient("http: //www.xyz.com/abc/wsdls/login.wsdl", array("trace" => 1, "exceptions" => 1, 'proxy_host' ...
Read more

c# - Resource not found error -

i have problem accessing method on homecontroller. show code of method : [httpget] public actionresult decriptidentifiantetredirige(string login_crypter, string mdp_crypter) { string loginacrypter = _globalmanager.protegemotdepasse(login_crypter); string mdpacrypter = _globalmanager.protegemotdepasse(mdp_crypter); user userapp = new models.user(login_crypter, mdp_crypter); if (userapp.authentificationvalidee(userapp.userlogin, userapp.password)) { session["name"] = userapp.userlogin; return redirecttoaction("accueil", "home"); } else { return redirecttoaction("validerauthentification", "home"); } } then in routeconfig.cs wrote route : routes.maproute( name: "authentificationapresdecryptage", url: "{controller}/{action}/{login_crypter}/{mdp_crypter}", defaults: new...
Read more