How to call Java script function inside Jquery

How to call Java script  function inside Jquery

<script type="text/javascript"> 

 function prodd(id){

  }          

jQuery(document).ready(function(){

prodd = function(id) {

document.getElementById(id).style.visibility = 'hidden'; 

  var id = $("#pdId").val();

  var dataString = 'id='+ id;

  $.ajax

  ({

  type: "POST",

  url: '<?php echo site_url('sellerInventory/delete');?>',

  data: 'id='+ id,

  cache: false,

  success: function(html)

  {

 

  }

  });

  

 };

// Call Jquery function inside jquery Script:

 var addproductM = function(name,id)

   {

   var MURL = $("#MURL").val();

    var strHTML="";

  strHTML+='<div class="confirmationproducts" onclick="prodd(this.id);" id="I';

  strHTML += id;

  strHTML += '">';

  strHTML+='<div class="cpproduct">';

  strHTML+=name;

  strHTML+='</div>';

  strHTML += '<input type="hidden" id="pdId" value="';

  strHTML += id;

  strHTML += '">';

  strHTML+='<div class="cpdelet id="de"><a class="linkdelete" id=""  href="#"></a></div>';

  strHTML+='<div class="clear-both"></div></div>';

$(".prod").html(strHTML);

var price = $('#price').val();

var catId = $('#cId').val();

var locally = $("input[name=locally]:checked").val();

var organic = $("input[name=organic]:checked").val();

var stocknow = $("input[name=stocknow]:checked").val();

var homeDe = $("input[name=homeDe]:checked").val();

var priceNote = $('#priceNote').val();

//Multiple data submission to ajax request

var data = "id="+id+"&locally="+locally+"&organic="+organic+"&stocknow="+stocknow+"&homeDe="+homeDe+"&priceNote="+priceNote+"&price="+price+"&catId="+catId;

$.ajax

  ({

  type: "POST",

  url: MURL,

  data: data,

  cache: false,

  success: function(html)

  {

 

  }

  });

$.fallr('hide');

   }

$('.linktype').click(function () {

var currentAnchor = $(this);

    var id = currentAnchor.attr('id');

    var name = currentAnchor.attr('name');

    var light = $('#url').val();

    var dataString = 'id='+ id;

$.ajax

({

type: "POST",

url: light,

data: dataString,

cache: false,

success: function(data)

{

var gap     = 20;

var boxH    = $(window).height() - gap;     // bottom gap

var boxW    = $(window).width() - gap * 2;  // left + right gap

$.fallr('show', {

   content : data,

   width   : boxW,

   height  : boxH,

   buttons : {

       button1 : { text: 'Add Product',onclick :function(){addproductM(name,id);}},

       button2 : { text: 'Cancel'}

   },

   

}); 

},

});

    });

});

});

Json and Ajax in Codeigniter

Json & Ajax

In view we have to put like this..

If you selecting the dropdown the request will be sent to ajax and response data will be json ...





<script type="text/javascript">
function showUser(str)
{

if (str=="")
  {

  document.getElementById("txtHint").innerHTML="";
  return;
  }

if (window.XMLHttpRequest)
  {// code for IE7+, Firefox, Chrome, Opera, Safari

  xmlhttp=new XMLHttpRequest();
  }
else
  {// code for IE6, IE5
  xmlhttp=new ActiveXObject("Microsoft.XMLHTTP");
  }

xmlhttp.onreadystatechange=function()
  {

  if (xmlhttp.readyState==4 && xmlhttp.status==200)
    {
 //alert('hai');
 //alert(xmlhttp.responseText);
      //document.getElementById("objId").innerHTML=xmlhttp.responseText;
      putdata(xmlhttp.responseText);
 
    }
  }
 
xmlhttp.open("GET","page/ajax/"+str,true);
xmlhttp.send();
}
function putdata(ajaxobject){
var res=JSON.parse(ajaxobject);
//alert(res.data[0].id);
//alert(res);
//

//alert(arr[6]);
//alert(arr);
document.getElementById('purl').value=res.data[0].url;
document.getElementById('ptitle').value=res.data[0].title;
document.getElementById('pmetades').value=res.data[0].meta_des;
document.getElementById('pmetakey').value=res.data[0].meta_key;
//document.getElementById('pcontent').value=res.data[0].content;
CKEDITOR.instances.pcontent.setData(res.data[0].content);
//document.getElementById('emailTemp').value=arr[4];

//alert(arr[6]);
}

</script>







 <select id="type" onchange="showUser(this.value);" name="type">
              <option >Please select one</option>
                <option value="1">Our Partner</option>
                <option value="2">Welcome</option>
                <option value="3">Coversage </option>
              </select>




Controller:


function ajax(){
  $this -> db -> select('*');
$this -> db -> from('page');
$this -> db -> where('page_id', $this->uri->segment(3));
$query = $this->db->get();
$JSON1=array('operation'=>'1','status'=>'ok','msg'=>'msg','data'=>$query->result());
echo json_encode($JSON1);
//echo "data:".json_encode();

}

Mysql Queries

Msql queries: 

NOT IN :

$query  = $this->db->query('select t.id,t.name from tag as t where t.id  not in (select pt.tag_id  from product_tag  as pt where pt.product_id = ' . $this->uri->segment(3) .')');
  return $query->result();




Left Join:


$query  = $this->db->query('select t.id,t.name from product_tag as p left join tag as t on t.id=p.tag_id where p.product_id=' . $this->uri->segment(3) .'');
  return $query->result();

Two left join :



$queryList = $this->db->query('select p.id,p.mp_from,p.mp_to,p.short_des,p.name,p.status,p.detailed_des,p.image,p.time_updated,c.name as cname,c.id as cid,s.name as sname,s.id as sid from product as p left join category as c on c.id=p.category_id left join sub_category as s on  s.id = p.subcategory_id where p.id =' . $this->uri->segment(3) .'');

return $queryList->result();