I want to add a comment system after my article, <form id="postform" class="postform"> is written into a MYSQL_QUERY result circle. but after post a comment, the current posted comment will be showed in all the <div class="post_comment"></div>, how to modify jquery ajax part so that the current posted comment only be showed in its own <div class="post_comment"></div>? [code]...
View 9 RepliesOk, I need to have a page where you hit an attack button and it displays your hitpoints after the battle, The problem is that I cannot get ajax to work with a php file if I query the database for the hitpoints.
here is the php [code]...
I modify a php comment system. I want add it after every article witch are query from database.
this is the php part
<?php
...
while($result = mysql_fetch_array($resultset))
{
$article_title = $result['article_title'];
[Code]....
How to modify the ajax data part that each article's comment can send each data to the ajax_post.php?
i want to retrieve data from mysql database using ajax and php. my code is below which does not work
here is index.html
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
[Code].....
The below coding is the javascript coding in which i have used AJAX coding also.its only pagenavigation coding.
function change(which)
{
if(which=="page1")
{
document.getElementById(which).style.borderBottomColor="white";
document.getElementById("page2").style.borderBottomColor="#778";
document.getElementById("page3").style.borderBottomColor="#778";
document.getElementById("page4").style.borderBottomColor="#778";
[Code]...
I am attempting to create a profile page with PHP utilizing AJAX technologies as well. I need profile data to auto-refresh on the page when a change is made in the database but every 15-30 seconds intervals are fine too. I would really like to use AJAX/PHP for this because I think it will be good for me to know and learn.
I have checked the internet for this and all of the examples show a form select/combobox where you select a "User" and then it populates the information automatically in a div below.
But... I need AJAX or PHP to READ THE VARIABLE FROM THE URL instead of a form(Combobox) and ultimately refresh the data on the page with the results from the DB query in the php file.
If I have a jquery var, such as:
var foo = $(this).fieldValue();
And within the </script> block I have a bit of PHP code that generates json, I want to pass the var to the php/mysql code such as:
Code:
$sql="Select from table where qid='foo'
In other words, how does a php/mysql query, in php code, grab the value of a previously declared Jquery var?
could someone please point me in the right direction for creating an AJAX page that displays "live" data from a mysql database? I need the page to update its self every time data changes in a mysql table.
View 1 Replies View RelatedI have a form.On the form I have a drop down box that allows the user to select a data set to work with (A or B). The table loads just fine and all is right with the world. No problems there.What I need is for the user to be able to edit the data set and have those changes written directly back to the mySQL database. They also need the option of deleting a record entirely.I know how to do all the database queries, updates, etc. I just don't know how to write the ajax forms to accomplish this.
View 4 Replies View RelatedI want to include the iphone gps long and lat into my website to be added to a sql query.Gets GPS long and lat from iphone and pops it in a div:
Code:
<html>
<head>
<script type="text/javascript">
[code]....
I want this to work like a tracking system where it gets the gps long and lat from the iphone and then adds it to a sql table (id, user_id, long, lat). I have the code to get the long and lat but how do i get the script to add them to a sql query from java?Also how can i get the script to refresh every 15 mins to overwrite the last long and lat?
I work primarily with php, and haven't had much experience with JavaScript. I was wondering if JavaScript is suitable for automatically updating a database with the contents of a text area, at intervals of 3 minutes... without refreshing the page? It doesn't have to change the content of the text area, just take a snapshot of it. I am trying to develop an 'autosave' feature.
View 3 Replies View RelatedDoes anyone know how to set a javascript variable as a query result from a MySQL database.
As an example, like this:
Set this query:
I just can't do it. I've tried doing it like this:
But the thing stops my <body onLoad=""> function from working. I'm no expert in Javascript.
Firstly this isnt a double post, I stupidly posted in the Java forum not the java script forum. Im trying to create a dynamic table based on the selections of multiple lists as per here Screen Shot
A user would select thier choices from the various lists and then add them to a table - this is where my question comes in. How do I achieve creating a table which will grow depending on how many additions a user adds?
Hope I make sense, Im trying to get my head around this.
<a href="test.php?t=123" id="test">Table</a>
//// JavaScript Document
$(document).ready(function() {
$('#a').click(function() {
[Code].....
I am trying to get data from mysql into a variable, that should be read by protovis.
I tried
/* abfrage_LB.php echoes a json string with the data from mysql */
var parsedData;
$.post('abfrage_LB.php', function(data){
parsedData = JSON.parse(JSONdata);
});
the error message says, that parsedData is undefined. How can I display, what is in parsedData?
I start to use JQuery and see how is really simple...! I just have a question that I couldn´t find in documentation or here in the forum, andI have a PHP Script that is a combobox with a several textareas. What I would like to do is, select a data in combobox andit will get some data in MySQL database and put it the textarea inputs.The combobox is from name of persons, and the textareas is address, telephone, email, etc... all of them are in MySQL database.
View 2 Replies View RelatedI'm triyng to use the $.ajax jquery function to insert some dates in a database, using php.I have the page that insert the data called : sign.php and in the page I have the form, and the ajax scritp.
$("#submit_sign").click(function(data){
$.ajax({
type: "POST",
url: ("sign.php"),
[code]....
if I use the page without ajax it works, if I use the script jquery it works but doesn't insert the dates in the field, it send only white field. can't pass the variable POST beetween the ajax script and the php script.
I have a database listing of properties down the page. Each property row has a date selector and a time selector. I need to somehow validate that if one of the dates is selected the time must be selected per property record before the bulk save can happen (or visa versa), if neither are selected it cane be left blank and addressed later. How I can go about validating this using jquery?
The field names are as follows:
DATE - data[Property][777][entry_date]
TIME - data[Property][777][entry_time]
NOTE: 777 is the property ID and changes per record down the screen.
I basically need something such as within a function to run dynamically:
if(data[Property][$id][entry_date] <> NULL) {
data[Property][$id][entry_time] is required
} else if (data[Property][$id][entry_time ] <> NULL) {
data[Property][$id][entry_date ] is required
}
I have a .load that executes a php mysql query from another page. This query displays all the data of the database. Each result is wrapped around a div.
<div id ="post<? echo $row['post_id']; ?>">
the id of the div depends on the post id of the result. How do I put the data of $row['post_id'] in my javascript?
I have a php script which contains various links which get handled by a jQuery function which in turn passes parameters to and loads another php script. The php script that gets loaded queries a large MySQL database and returns a set of results in an HTML table. Where there is more than 1 page of results the php script provides page numbers which can be clicked on to bring up further pages of results. Where there are more than 20 pages a small algorithm displays an abbreviated set of page numbers,This obviously worked fine when the script was running on its own but now it's being loaded using jQuery it's preumably of no use. Can anyone suggest a way of tackling the problem, I did take a look at various pagination plugins but they didn't seem to be what I was looking for based on what I've said above.
View 4 Replies View RelatedI am looking for JQuery script to edit mysql table. I am sure something should be published, but I don't know where to search. I need something very simple to install and configure. The idea is to have a form field on a page, where all columns of table would be placed. Every mysql column should be on separate line and there should be a save button next to it. So if I edit a column, then I would just press Save button, and the request to save actual value would be send to server. No page reload. I would continue editing and saving all columns and when I would be at bottom of page, then I would press the Next button, and next mysql row would be loaded to the form field.
View 10 Replies View RelatedI have a database site I am currently designing, and would like to use a single page with forms in external html documents to undertake admin tasks (eg. add/remove records etc.)
I have managed to successfully load the form html into the necessary div using the $.load function, however, when I try to process the form, with this code:
$("#add_form").validate({
debug: false,
rules: {
maker: "required",
[Code]....
which asks 'process_form.php' to process the data, it doesn't seem to send the data in the form to the page. to confirm this, and whilst trying to get the system to work, the 'process_form.php' consists of 2 lines,:
echo $_GET['maker'];
echo '123456';
(ie. one line to return a string literal, and one line to return one of the variables which SHOULD be passed by the form)
This results in just the 123456 string being returned.
I have tried several things: loading the script above in the head of the 'parent' html page (ie. which the form is loaded into); - does not properly fire at all;
loading the script 'in-line' in the imported html - this leads to the result given above; running the script in an external script.js file through an onsubmit directive on the form...does not appear to properly fire the script.
I have multiple rows of data in an HTML table. E.g., financial transactions. In each row I have an HTML dropdown SELECT with options (user will select transaction tag). I want the transactionID and selected tagID to pass to an onchange event for that unique row. The transactionID comes through for the unique row of data, but I
[Code]...
I created a page (index.html, including the embedded javascript) with a div loaded by an external html content. But in this new content the click function I defined in the index.html page does not work in the new content. Then my question is: do i need to include all javascript in the external html content?
View 1 Replies View Related[code]My problem is simply that i have say 5 columns in the database placing the jquery script in that section allows that to be on each and every post. That works fine. the problem is though only the first one works the rest do not. It simply just doesn't have any action while the first one works fine.
View 1 Replies View RelatedI have this snippet:
[Code]...
that is sent when a very simple form (one value and button) is sent. The thing is, it works on my local webserver, but when I upload it to my webhost, it wont work. It works if add data.php?nick=Test, then the
data will be added into my database but not when called from .ajax.