php dynamic search build query

-






<?php
 $hostName = "localhost";
 $userName = "root";
 $password = "";
 $dbName = "pobpaper";
 $conn= new mysqli($hostName,$userName,$password,$dbName);
 if(!$conn){
    echo "DB is not connected";
 }

 $jt = $_GET["jt"];
 $jc = $_GET["jc"];

 $myArr = [];

 if($jt != NULL){
    $new = explode(" ", $jt);
    echo $new[0];
    $c = count($new);
    echo $c;
    if($c == 1){
        if($new[0] == 'remote'){
            array_push($myArr,(object)["st"=> 'jobtype','jtid'=>'1']);
        }
        else{
            array_push($myArr,(object)["st"=> 'jobtype','jtid'=>'2']);

        }

    }
    else if($c == 2){
        if($new[0] == 'remote'){
            echo 'came';
            array_push($myArr,(object)["st"=> 'jobtype','jtid'=>'1,2']);
        }
        else{
            array_push($myArr,(object)["st"=> 'jobtype','jtid'=>'2,1']);
        }
    }
    echo 'array length';
    echo count($myArr);
 }
 if($jc != NULL){
    $new = explode(" ", $jc);
    echo $new[0];
    $c = count($new);
    echo $c;
    if($c == 1){
        if($new[0] == 'nodejs'){
            array_push($myArr,(object)["st"=> 'jobcategory','jtid'=>'1']);
        }
        else{
            array_push($myArr,(object)["st"=> 'jobcategory','jtid'=>'2']);

        }

    }
    else if($c == 2){
        if($new[0] == 'nodejs'){
            echo 'came';
            array_push($myArr,(object)["st"=> 'jobcategory','jtid'=>'1,2']);
        }
        else {
            array_push($myArr,(object)["st"=> 'jobcategory','jtid'=>'2,1']);

        }
    }
 }

 echo"array 12" ;
 var_dump($myArr[0]-> st);
 if(count($myArr) == 1){
     $firs = $myArr[0]-> st;
     $sec = $myArr[0]-> jtid;


        $query = "SELECT * FROM sometable WHERE `$firs` IN ($sec)";

 
     echo $query;
     $result = mysqli_query($conn,$query);
     while($row = mysqli_fetch_assoc($result)){
        echo " ". $row['sno'] ;
    }
 }
 else if(count($myArr) == 2){
    $firs = $myArr[0]-> st;
    $sec = $myArr[0]-> jtid;
    $firs2 = $myArr[1]-> st;
    $sec2 = $myArr[1]-> jtid;

     $query = "SELECT * FROM sometable WHERE `$firs` IN ($sec) AND `$firs2` IN ($sec2)";

 
    echo $query;
    $result = mysqli_query($conn,$query);
    while($row = mysqli_fetch_assoc($result)){
       echo " ". $row['name'] ;
   }

 }
//  $subname = $_GET["subname"];

?>

Comments

Post a Comment

All time Best Post

Write a program that declares a class named Person. It should have instance variables to record name, age and salary. Use new operator to create a Person object. Set and display its instance variables.

-
Image
 Program -  import java.util.*; public class persondata { public static void main(String[]args) { person a = new person(); a.set(); System.out.println("your data is \n\n"); a.display(); } }  class person { private String name; private int age; private int salary;   public void display() { System.out.println("your name is :"+name); System.out.println("your age is :"+age); System.out.println("your salary is "+salary); } public void set(){ Scanner sc = new Scanner(System.in); System.out.println("enter your name"); name = sc.next(); System.out.println("enter your age"); age = sc.nextInt(); System.out.println("enter your salary"); salary = sc.nextInt(); } } outpiut -   
Read more

IMAGE CRUD OPERATION USING EXPRESS MONGOOSE MULTER

-
Image
  IMAGE CRUD OPERATION USING EXPRESS MONGOOSE MULTER Dependencies Used -    File Structured -  Server.js file -  // requirements    const express = require ( 'express' ) const imgModel = require ( './db/user' ) const mongoose = require ( 'mongoose' ) const multer   = require ( 'multer' ) const path = require ( 'path' ) const app = express ();   // serving static files  app . use ( express . static ( 'public' ));     // connecting to database  mongoose . connect ( 'mongodb://localhost:27017/testten' , { useNewUrlParser: true , useUnifiedTopology: true , useFindAndModify: false   }) . then (() => console . log ( "database is connected" )) . catch (( err ) => console . log ( err ))   // multer destination set    var storage = multer . diskStorage ({      destination: "./public/uploads/" ,      filename : ( req , file , cb ) => {   ...
Read more

connect websocket to binance api and store t he true value in the db

-
  const WebSocket = require( 'ws' ); const bitcoindata = require( '../model/bitcoindata.model' ); function connectToBinanceWebSocket() {    // Connect to Binance's WebSocket API for the BTC/USDT trading pair    const socket = new WebSocket( 'wss://stream.binance.com:9443/ws/btcusdt@kline_1m' );    // Handle messages received from the WebSocket   socket.on( 'message' , (data) => {      const message = JSON.parse(data);      if (message.e === 'kline' ) {        const candle = message.k;       console.log( `[${new Date(candle.t).toLocaleTimeString()}] Open: ${candle.o}, High: ${candle.h}, Low: ${candle.l}, Close: ${candle.c}` );        if (candle.x == true ) {         console.log({candle})         bitcoindata.crea...
Read more

CRUD APP WITH SORT IN NODE EXPRESS AND MONGODB

-
Image
  CRUD APP WITH SORT IN NODE EXPRESS AND MONGODB wriitten in ecma script6  Dependencies -    File structure  - Server.js file -  //requirements  const express = require ( 'express' ); const mongoose = require ( 'mongoose' ); const bodyparser = require ( 'body-parser' ) const app = express ();   // database connection mongoose . connect ( 'mongodb://localhost:27017/testone' ,{ useNewUrlParser: true , useUnifiedTopology: true }) . then (() => console . log ( "databse is connected" )) . catch (( err ) => console . log ( err ))     // database schema var itemSchema = new mongoose . Schema ({      name : String ,      surname : String ,      event : String })   // database collection creation var item = new mongoose . model ( 'item' , itemSchema )   // setting view engine to ejs app . set ( 'view engine' , 'ejs' )   // using body parser because...
Read more

express session login system using node express mongodb

-
Image
express session login system using node express mongodb Dependencies used -  File -  Server.js file -  const express = require ( 'express' ); const mongoose = require ( 'mongoose' ); const bcrypt = require ( 'bcrypt' ) const session = require ( 'express-session' ) const mongoDBSession = require ( 'connect-mongodb-session' )( session ); const bodyparser = require ( 'body-parser' ); const userModel = require ( './models/user' ) const student = require ( './student' ) const app = express ();   const mongoURI = 'mongodb://localhost:27017/testsix'     mongoose . connect ( 'mongodb://localhost:27017/testsix' ,{ useNewUrlParser: true , useUnifiedTopology: true , useCreateIndex: true , }) . then (() => console . log ( "database is connected" )) . catch (( err ) => console . log ( err ))   app . set ( 'view engine' , 'ejs' )   app . use ( bodyparser . urlencod...
Read more

how to delete image from the folder directly from a Request (MULTER)

-
imported item -  const   path  =  require ( 'path' ) const   fs  =  require ( 'fs' ) // code : router . get ( '/delete/:id' , isAuth , async  ( req , res ) => {      await    addBlogmodel . findByIdAndRemove ( req . params . id ,( err , items ) => {          if ( err ){              res . send ( "sory we have some issuse" )         }          else         {              const   path  =  './public/uploads/' + items . image              try  {                  f...
Read more

calculate rsi

-
Image
  const newFunction = async () => {       // https://stackoverflow.com/questions/70452789/node-js-find-the-same-rsi-as-tradingview       // https://gist.github.com/jmoz/1f93b264650376131ed65875782df386       // https://stackoverflow.com/questions/50203625/calculate-rsi-based-on-kraken-ohlc       // topdown1.count({}, function( err, count){           //  console.log( "Number of data in db :", count );           // topdown1.find(async (err,items)=>{                 // if(err){                   //      console.log(err)                 // }                 // else{                     const ticker = await exchange . fetchTicker ( '...
Read more

java program for 1 to 10 print using while loop

-
 program-  public class Main {     public static void main(String[] args)     {         int i=0;                  while ( i<10 )         {             i++;             System.out.println(i);                      }     } } Output :- 1 2 3 4 5 6 7 8 9 10
Read more

How to fetch last one minute volume of BTC in CCXT Nodejs.

-
Image
  const exchange = new ccxt . binance (); async   function   getLastOneMinuteVolume () {     try {       const binance = new ccxt . binance ();       const symbol = "BTC/USDT" ;     //   const symbol = "USDT";       const ohlcv = await binance . fetchOHLCV ( symbol , "1m" );         console . log ( ohlcv [ ohlcv . length - 1 ])       const lastCandle = ohlcv [ ohlcv . length - 1 ];       const volume = lastCandle [ 5 ];     //   console.log(lastCandle[5])       console . log ( "Last one minute volume:" , volume );     } catch ( error ) {       console . error ( error );     }   }   //   getLastOneMinuteVolume();   setInterval ( getLastOneMinuteVolume , 1000 ) first data in array is volume in USDT , last is volume in BTC , second is price.
Read more