PHP - Jquery & Php Problem

Im wondering if i should use jQuery or Php. and how about i would go about doing this.

Code: [Select]

<?php
    print "<table border=\"0\" cellpadding=\"0\" width=\"100%\" height=\"100\"cellspacing=\"0\" style=\"border-collapse:collapse\"bordercolor=\"grey\" bgcolor=\"white\" valign=\"top\">
<td align=\"left\" width=\"100%\" onclick=\"I3.location.href='getuserdetail.php?prop=$ownerid'\"><b>Property Name</b></td><td><b>Tenant</b></td><td><b>Property Status</b></td><td>Rent Amount</td>";
        $connect = mysql_connect("localhost","root","");
        mysql_select_db("magic");
        $query = "SELECT * FROM props WHERE ownerid = '$ownerid' ORDER BY name ASC ";
        $result = mysql_query($query);
        while($row = mysql_fetch_assoc($result))
{
$propertyid     = $row['propid'];
$propertyname   = $row['name'];
$propertydesc = $row['description'];
$propertycity   = $row['city'];
$propertystate  = $row['state'];
$propertyzip    = $row['zip'];
$active = $row['active'];
$lease = $row['lease'];
$leaseamt = $row['leaseamt'];

if($active == "1"){
$propertystatus = "Active";
} else {
$propertystatys = "Unknown";
}





print"<tr  onMouseOver=\"this.bgColor = '#CEE3F6'\" onMouseOut =\"this.bgColor = '#FFFFFF'\">
<td align=\"left\" width=\"25%\" onclick=\"window.open('viewpropdetail.php?prop=$propertyid','mywindow','width=1200,height=600,scrollbars=1')\">$propertyname</td><td>$ownerfirstname $ownerlastname</td><td>$propertystatus</td><td>$$leaseamt</td>

";
  }


print"</td></table>";
                                                           
                                                           ?>

Basically i have a link under that is add property. it pops up a box. with a form you fill it out, and it inserts the record into database.

What I'm trying to do. is get it to "Refresh" the property list ( ex. code above).  so it shows the new property in the table.



i have never used jQuery. but was wondering if i could do that with php.  Is there a way to say if records are changed.. update?

Hi All (Again)

I am looking to pick up variables in jquery from a string created:

function search_by() {
   var search_term = $('#search_for', $(this).attr('value'));
   alert(search_term);
}

I cant seem to get the value i am trying to into a "var".

This is the code on the page i am using a  onClick="search_by();"
i.e:
<a class="show_cats" search_cat="PDAs & Accessories" search_for="fire" onclick="search_by();" href="#">

I am trying to get the value inside the "search_for" field.
Any ideas????

Hi
I am in the process of teaching myself web development, coming from a vb and mssql background.

I am building a small page that will display my film library, I just want something quick and simple that gets things working.  I have three img tags on my page that display the film posters.  The current film and the one previous and next.

What I would like is a left and a right arrow that just scroll through the library.

I am thinking I need to read the sub folder of D:\movies and story the full path name into an array, and then when the user presses a arrow it moves forward or back.

Everything is local and I am unsure about how to handle the event of the left/arrow being pressed.  Does PHP handle that kind of event or would Jquery be more suitable or something else completely??

thanks for any pointers.

Hey, I have a foreach loop displaying some data from my table, what i need to do is run a Jquery each function on the repeated element so it fadesIn each element one at a time. I am guessing i need to set somesort of interval for this to work. I have been messing with it for a good hour or so now and i cant seem to get it working. Has anyone done this before or seen it done else were?

I am trying to limit comments and replies to comments and display an error message once the limit is reached. I have successfully limited comments and comment replies, and successfully provided the error message when prompted ONLY for the comments, and not the comment replies.

The comment replies have a little bit of jquery working with them, so that's the only thing I can see that would be causing the message not to display. I have tried other methods then the one currently being used.

https://gist.github.com/8972a8343c6fd2b878b1

thanks in advance.

Hi! Having a lot of fun dusting off the coding and putting together a site with PHP, CSS, and jQuery. I've run into one problem that I can't get past though. I implemented jQuery History to use hashtags to maintain browser back/forward buttons and linkability of the site (and not reload header and footer when updating content). The main purpose of the site is to showcase photography that's hosted on Flickr. I've got this working well using Slickr.

I have the Slickr code to load my galleries sets in a file called 'pictures.php' which is loaded fine into #page_content using a link to #pictures. The problem arises when I click on a gallery/set: I get taken back to the default view of the site without any hashtage because Slickr requires a link using parameters, so:

www.myexamplesite.com/#pictures

becomes

www.myexamplesite.com/index.php?id=72157626067797650&p=1

As you can see, since it loses the hashtag, I am no longer looking at the right page. Does anybody have any ideas on how I can specify both the hashtag and the parameter? Cheers!

Hello everyone, im make a website for my final school project.

My header is a image slider made in jQuery with a time interval to change to images.
At the moment when you press a link, the URL changes (example: index.php?page=contact). Then I use the $_GET to know what html file needs to be included, for this example: contact.html. The problem is when the URL changes (after clicking a link), the page refreshes and my jQuery header also refreshes to image[0].

Is there a way to include the right content when clicking on a link, without refreshing the page/header?

Thanks in advance

Gucco.

how come this doesnt echo out on my page? supposed to be an ajax response:
Trying to write a form tag to the #quantity div.

script does get executed as it echoes test

echo ' test';
echo '<script type="text/javascript">';
echo '$("#quantity").append(function(index, html) { ';
echo 'return';
echo '<form name="f1" id="f1"><input name="f1" id="f_1" type="hidden" value="1235" /></form>';
echo '   });';
echo '</script>';

Hi,   Have a look this menu   http://jsfiddle.net/GBkMB/6/   I want the same mune but with click function (its using hover function now)   Please help me with this 

I'm using jQuery webcam to capture a photo of the client. I need to send it to the server just when the form is submitted (It's a form with information, and I need to have the photo attached to it).

I have everything working except the part of saving the image encoded with base64 to the database like blob.

Here is what I have so far:

Code: [Select]
    <script type="text/javascript">
    var pos = 0;
    var ctx = null;
    var cam = null;
    var image = null;
   
    jQuery("#webcam").webcam({
   
    width: 320,
    height: 240,
    mode: "callback",
    swffile: "/../../js/jscam_canvas_only.swf",
   
    onTick: function(remain) {
   
    if (0 == remain) {
    jQuery("#status").text("Sorria!");
    } else {
    jQuery("#status").text(remain + " segundo(s) restante(s)...");
    }
    },
   
    onSave: function(data) {
   
        var col = data.split(";");
        var img = image;
   
        for(var i = 0; i < 320; i++) {
            var tmp = parseInt(col[i]);
            img.data[pos + 0] = (tmp >> 16) & 0xff;
            img.data[pos + 1] = (tmp >> 8) & 0xff;
            img.data[pos + 2] = tmp & 0xff;
            img.data[pos + 3] = 0xff;
            pos+= 4;
        }
   
        if (pos >= 4 * 320 * 240) {
            ctx.putImageData(img, 0, 0);
            var canvas = document.getElementById("canvas");
            var save_image = canvas.toDataURL("image/png");
            save_image = save_image.replace(/^data:image\/(png|jpeg);base64,/, ""); 
            $('input[name=save_image]').val(save_image);
            pos = 0;
        }
    },
   
    onCaptu function () {
               
    jQuery("#flash").css("display", "block");
    jQuery("#flash").fadeOut(100, function () {
    jQuery("#flash").css("opacity", 1);
    });
                    jQuery("#canvas").show();
                    webcam.save();
    },
   
    onLoad: function () {
               
    var cams = webcam.getCameraList();
    for(var i in cams) {
    jQuery("#cams").append("<li>" + cams[i] + "</li>");
    }
                    jQuery("#canvas").hide();
    }
    });
   
    function getPageSize() {
   
    var xScroll, yScroll;
   
    if (window.innerHeight && window.scrollMaxY) {
    xScroll = window.innerWidth + window.scrollMaxX;
    yScroll = window.innerHeight + window.scrollMaxY;
    } else if (document.body.scrollHeight > document.body.offsetHeight){ // all but Explorer Mac
    xScroll = document.body.scrollWidth;
    yScroll = document.body.scrollHeight;
    } else { // Explorer Mac...would also work in Explorer 6 Strict, Mozilla and Safari
    xScroll = document.body.offsetWidth;
    yScroll = document.body.offsetHeight;
    }
   
    var windowWidth, windowHeight;
   
    if (self.innerHeight) { // all except Explorer
    if(document.documentElement.clientWidth){
    windowWidth = document.documentElement.clientWidth;
    } else {
    windowWidth = self.innerWidth;
    }
    windowHeight = self.innerHeight;
    } else if (document.documentElement && document.documentElement.clientHeight) { // Explorer 6 Strict Mode
    windowWidth = document.documentElement.clientWidth;
    windowHeight = document.documentElement.clientHeight;
    } else if (document.body) { // other Explorers
    windowWidth = document.body.clientWidth;
    windowHeight = document.body.clientHeight;
    }
   
    // for small pages with total height less then height of the viewport
    if(yScroll < windowHeight){
    pageHeight = windowHeight;
    } else {
    pageHeight = yScroll;
    }
   
    // for small pages with total width less then width of the viewport
    if(xScroll < windowWidth){
    pageWidth = xScroll;
    } else {
    pageWidth = windowWidth;
    }
   
    return [pageWidth, pageHeight];
    }
   
    window.addEventListener("load", function() {
   
    jQuery("body").append("<div id=\"flash\"></div>");
   
    var canvas = document.getElementById("canvas");
   
    if (canvas.getContext) {
    ctx = document.getElementById("canvas").getContext("2d");
    ctx.clearRect(0, 0, 320, 240);
   
    var img = new Image();
    img.onload = function() {
    ctx.drawImage(img, 320, 240);
    }
    image = ctx.getImageData(0, 0, 320, 240);
    }
    var pageSize = getPageSize();
    jQuery("#flash").css({ height: pageSize[1] + "px" });
   
    }, false);
   
    window.addEventListener("resize", function() {
   
    var pageSize = getPageSize();
    jQuery("#flash").css({ height: pageSize[1] + "px" });
   
    }, false);
    </script>
Then I have just a normal form that the customer has to fill it in, followed by this:

Code: [Select]
    <div id="webcam">
    </div>
    <p style="width:250px;text-align:center; "><input type="button" value="Tirar Fotografia" onclick="webcam.capture(3);void(0);"/></p></td><td><p><canvas id="canvas" height="200" width="200"></canvas></p>
in php i have:

Code: [Select]
$image=file_get_contents(base64_decode($_POST['save_image']));

27.//file: selectBenefit.php
28.<?php
29.echo "value: " .$_POST['ss_num'] . "<br/>";
?>

16.// file: applicant_info.js
17.
18.function getApplicantInfo()
{  
 
19.  $("#divMainBenefitsProcessing").slideDown();
20. 
$.ajax({
 cache: false,
 url: 'selectedBenefit.php',
 type: 'GET',
 cache: false,
 success: function(response) {
console.log(response); 
21. $("#divMainBenefitsProcessing").html(response);
  
  
  $("#divMainBenefitsProcessing").slideDown();
22.var radioButton = $("input[name='arr_bnft_records']:checked");
            
            if (radioButton == null || radioButton.length < 1)
                alert("Please select a benefit record for processing.");
            else
     {
     $("#ss_id_other").val(radioButton.attr("data-ss-id-other"));
                $.post('selectedBenefit.php',{ss_num: $("#ss_id_other").val()});
23.    }
24. },
 
 beforeSend: function(){
25. },
 error: function(e) {
console.log(e.message);
 }
}); 
}

1.<!-- file: "benefits.htm" -->
2.?<!DOCTYPE html>
<html>
3.<head>
<title>Benefit Processing Page Social</title>
     <meta charset = "utf-8">
             <link rel = "stylesheet" type = "text/css" href = "css_files/divapplist.css">
4.<script src="js_files/jquery-1.11.1.min.js"></script>
5.                <script type = "text/javascript" src = "js_files/selectBenefit.js"></script>
6.                <script type = "text/javascript" src = "js_files/applicant_info.js"></script>
7.</head>
8.<table border="0" cellpadding="10" cellspacing="1" width="900" class="tblListForm">
<tr class="listheader">
<td></td>
<td>Social Security No.</td>
<td>Last Name</td>
<td>Other Name(s)</td>
<td>Date of Birth</td>
<td>Benefit Type</td>
9.</tr>
10. 
  <tr >
<td><input type="radio" name="arr_bnft_records"
 value="47" 
 data-app-id="37" 
 data-benefit-type="Funeral Grant" 
 data-ss-id-other="33333" 
 data-father-weeks=""
 data-funeral-qual="" 
 data-last-name="Lee" 
 data-other-names="Brenda" 
 data-dob="1965-04-04" 
 data-sex="F" 
  
></td>
<td>33333</td>
<td>Lee</td>
<td>Brenda</td>
<td>1965-04-04</td>
<td>Funeral Grant</td>
11.</tr>
12. 
13.<tr class="listheader">
<td colspan="6"><input type="button" id = "submit_btn2" value ="Select" onclick= "getApplicantInfo()"  /></td>
</tr>
</table>
14.

I have some data assigned in jQuery code that I need to send over to my PHP script and I am not quite sure how to do it. 




I have a main page "benefit.htm" which calls a JavaScript function "getApplicantInfo()" defined in the source file "applicant_info.js". The get Applicant function then calls "selectBenefit.js" and tries to pass the value

"$(#ss_id_other").val()" to the "selectBenefit.js" file as the variable "ss_num" within that file. How can this be accomplished?




Source code snippets are included

This topic has been moved to Ajax Help.

http://www.phpfreaks.com/forums/index.php?topic=342757.0

Hi, I am working on a project to help me learn more about JSON and JQuery and how they interact. I am able to pull in my JSON data fine and it displays in an HTML table. What isn't working is I want the tables rows to be striped, and normally this works, but I didn't know if it isn't working b/c it is AJAX or if I have something wrong with my JQuery. Also, I was hoping to add a reference to an image path in the JSON file as well, but wasn't sure how that is done or if it could be done at the JSON level.   Here is my code that I am working on:

<!DOCTYPE html>
<html lang="en">
<head>
    <meta charset="utf-8" />
    <title>JSON Presidents</title>
	<style type="text/css">
        
        body{
            font-family:arial, helvetica, sans-serif;
        text-align:center;
            width:100%;
            margin:200px 0 0 0;
        }
        
	#PresidentInfo{
	width:75%;
	margin:0 auto;
       
        
	}
        
        table#data{
            width:100%;
        }
        
        table#data th{
            background:#333;
            color:#fff;
            text-align:center;
            text-shadow:1px 1px 1px rgba(0,0,0,1);
            padding:5px;
        }
        
        table#data td{
            border:1px solid #333;
            border-collapse:collapse;
            padding:10px;
            margin:0 5px 0 5px;
            text-align:center;
        }
        
        .odd {
   background: #ccc;
}
            
	

	
	
	</style>
</head>
<body>
        
    <div id="PresidentInfo">
  
    </div>

    <script src="http://code.jquery.com/jquery-1.7.1.min.js"></script>
	   <script>
           (function ($) {
$(document).ready (function(){
   $("tr:odd").addClass("odd");
    });
});
})(jQuery);
</script>
    <script>
  $.getJSON('data.json', function(data) {
        var output="<table id='data'><tr><th>First Name:</th><th>Last Name:</th><th>Month of Inauguration:</th><th>Year of Inauguration:</th></tr>";
        for (var i in data.Presidents) {
            output+="<tr><td>" + data.Presidents[i].firstName + "</td><td>" + data.Presidents[i].lastName + "</td><td>" + data.Presidents[i].YearInauguratedPresident.month +  "</td><td>" + data.Presidents[i].YearInauguratedPresident.year + "</td></tr>";
        }

        output+="</tr></table>";
        document.getElementById("PresidentInfo").innerHTML=output;
  });
    </script>
 
</body>
</html>

{"Presidents":[
        {
            "firstName":"Barack",
            "lastName":"Obama",
            "YearInauguratedPresident": {
                "month":"January",
                "day":20,
                "year":2009
            }
        },
        {
            "firstName":"George W",
            "lastName":"Bush",
            "YearInauguratedPresident": {
                "month":"January",
                "day":20,
                "year":2001
				}
            },
			     {
            "firstName":"Bill",
            "lastName":"Clinton",
            "YearInauguratedPresident": {
                "month":"January",
                "day":20,
                "year":1993
				}
            },
			     {
            "firstName":"George",
            "lastName":"H.W Bush",
            "YearInauguratedPresident": {
                "month":"January",
                "day":20,
                "year":1989
            }
        }
]}

Whats up guys..just wanted to know if there is any security i should worry about on this

Is there anyway at all to by pass this post
Yes its overkill thats why im asking..

 $(".like").click(function () {
            var id = $(this).parent().find(".id").val();
         var url = 'id=' + escape(id) + '&submit=1';
          $.ajax({
         type: "POST",
         url: "Actions/insert/up.php",
           cache: true,
          data: url,
         success: function(){........took out some code no reason to have


below is up.php

<?php
$id=stripslashes(trim(htmlentities(mysql_real_escape_string(strip_tags(strtolower(preg_replace('/\s+/','', $_POST['id'])))))));
$s=stripslashes(trim(htmlentities(mysql_real_escape_string(strip_tags(strtolower(preg_replace('/\s+/','', $_POST['submit'])))))));
$user=stripslashes(trim(htmlentities(mysql_real_escape_string(strip_tags(strtolower(preg_replace('/\s+/','', $_POST['user'])))))));
define('IS_AJAX', isset($_SERVER['HTTP_X_REQUESTED_WITH']) && strtolower($_SERVER['HTTP_X_REQUESTED_WITH']) == 'xmlhttprequest');
if(IS_AJAX) {
if (isset($_COOKIE['user']))
{
$connection = mysql_connect() or die(mysql_error());
mysql_select_db('mainframe', $connection) or die(mysql_error());
$idcheck=mysql_query("SELECT id FROM taken out WHERE id='$user' "); $rowic = mysql_fetch_array($idcheck); if ($idcheck){
if ($s=='1'){
mysql_query("INSERT INTO thumbsup (postidup,useridofup,typeof) VALUES ('$id','$user','up')")or die(mysql_error());
}else {die('Take it easy big guy!');}

}else {die('Take it easy big guy!');}

}else {die('Take it easy big guy!');}

}else {die('Take it easy big guy!');}


mysql_close($connection);
?>