Do you wonder if your IT business is truly profitable or if you should raise your prices? Learn how to calculate your overhead burden using our free interactive tool and use it to determine the right price for your IT services. Start calculating Now!
How to use ajax in jquery to retrieve information from a database?
Hi, I would like to retrieve information from my database using ajax in jquery. I googled this but I have not found a tutorial for exactly what I am trying to do. (also, many of them had asp.net or C# in them, which I am not familiar with yet)
I know how I would normally retrieve info from the database with php: (example)
$query = "SELECT name FROM submenus WHERE id=" . $id;
$result = mysql_query($query, $conn);
confirm_query($result);
while ($row = mysql_fetch_assoc($result)
$name = $row['name'];
}
but if you want this to change each time according to an item being clicked the page would have to reload. I would like to display information (details) next to an image (according to the image that is clicked) without the page reloading.
Can anyone tell me a real SIMPLE way of retrieving data from a database or know of a good tutorial for this (jquery/ajax/php)?
I know how I would normally retrieve info from the database with php: (example)
$query = "SELECT name FROM submenus WHERE id=" . $id;
$result = mysql_query($query, $conn);
confirm_query($result);
while ($row = mysql_fetch_assoc($result)
$name = $row['name'];
}
but if you want this to change each time according to an item being clicked the page would have to reload. I would like to display information (details) next to an image (according to the image that is clicked) without the page reloading.
Can anyone tell me a real SIMPLE way of retrieving data from a database or know of a good tutorial for this (jquery/ajax/php)?
Do more with
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
With jQuery :
page.php something like:
$(document).ready(function() {
$("item-being-clicked-selector").click(function(e) {
// e.preventDefault(); // uncomment this if the item is a link/anchor
$.getJSON("/path/to/page.php", {"id":$(this).attr("id) }, function(data) {
$("put-data-here-selector").html(data); // put-data-here-selector is a div, a span, a cell, ...
});
});
});
page.php something like:
<?PHP
$name = "error";
if( isset($_GET["id"]) ) {
$id = $_GET["id"];
$query = "SELECT name FROM submenus WHERE id=" . $id;
$result = mysql_query($query, $conn);
confirm_query($result);
if($row = mysql_fetch_assoc($result)){
$name = $row['name'];
}
}
echo $name;
?>
You ajax page need to ONLY RETURN the data asked and not a full page, so no HTML or something else, only data.
In the page.php provide we return only the name not something like :
Else you can use what you want (the library you want to do the query or any other work)
In the page.php provide we return only the name not something like :
<html><head></head><body>
FairyBusiness
</body></html>
Else you can use what you want (the library you want to do the query or any other work)
ok, can you give me an example of how to specify which function from the library to use in jquery/ajax?
example: function get_info()
example: function get_info()
You ajax page need to ONLY RETURN the data asked and not a full page, so no HTML or something else, only data.
...... not really understanding this part. .. ..
but I put the link and the div to be written in here:
<a id="lala" href="">Hello</a>
<div id="stuff"></div>
http://gowiththemaster.com/tleithoff/index.php?id=1&type=1blurb&table=submenus
but when I click on the link nothing happens. I put the jquery function in my action.js and I call to page.php (which has many functions so I dont know how it would know, which function to run). and I want it to use the details() function
It did not work though.
but I put the link and the div to be written in here:
<a id="lala" href="">Hello</a>
<div id="stuff"></div>
http://gowiththemaster.com/tleithoff/index.php?id=1&type=1blurb&table=submenus
but when I click on the link nothing happens. I put the jquery function in my action.js and I call to page.php (which has many functions so I dont know how it would know, which function to run). and I want it to use the details() function
It did not work though.
You need to write : page.php
This page query your database from a query based on the ID (lala ????) and RETURN ONLY the name for "lala" ID
Check my previous post to see an example of page.php
This page query your database from a query based on the ID (lala ????) and RETURN ONLY the name for "lala" ID
Check my previous post to see an example of page.php
ok i changed the id to #1, because I know i have an id of 1 in my table. but still nothing
I dont want it to get the id from the url though, just from what it being clicked
I dont want it to get the id from the url though, just from what it being clicked
still get a 404 error for page.php...
Did you create it this page? Check my previous post to see an example of page.php
Did you create it this page? Check my previous post to see an example of page.php
The right path :
http://gowiththemaster.com/tleithoff/includes/page.php
The current path used by getJSON
http://gowiththemaster.com/includes/page.php
So we update it :
http://gowiththemaster.com/tleithoff/includes/page.php
The current path used by getJSON
http://gowiththemaster.com/includes/page.php
So we update it :
$("#1").click(function(e) {
e.preventDefault(); // uncomment this if the item is a link/anchor
$.getJSON("/tleithoff/includes/page.php", {"id":$(this).attr("id") }, function(data) {
$("#stuff").html(data); // put-data-here-selector is a div, a span, a cell, ...
});
});
Ok it run fine but the function return nothing, are you sure you have data for : SELECT name FROM submenus WHERE id=1
perhaps page.php is not complete, did you add the connexion database part and so on ?
<< know how I would normally retrieve info from the database with php: (example) >>
<< know how I would normally retrieve info from the database with php: (example) >>
i changed my function to this:
and I echo the function. it works
function details() {
global $conn;
$id = 1;
$query = "SELECT blurb FROM submenus WHERE id=" . $id;
$result = mysql_query($query, $conn);
confirm_query($result);
while($row = mysql_fetch_assoc($result)){
$name = $row['blurb'];
}
echo $name;
}
and I echo the function. it works
if you want to be sure it work, just replace the content of page.php by the following and only the following :
<?PHP
echo "FairyBusiness";
?>
uhh I did that but it changed my whole page to just say Fair Business!!! I wanted it to write in the div. . .
You modify something else than the previous page, don't know why.
It work previously fine (but no result from the query or an error)
It work previously fine (but no result from the query or an error)
i dont know what you are talking about it never worked before because it didnt know which function to run on the page.php. Now all page.php says is FairyBusiness so that is what my page says!
I guess it is clicking my link automatically. but i did not change anything other then what you told me to change
I guess it is clicking my link automatically. but i did not change anything other then what you told me to change
<article id="page_1">
<div class="wrapper" id="page1">
<div class="prefix_2">
<div class="grid_20 grid_box">
<div class="box">
<div class="text">
<h2><?php echo get_data('header'); ?></h2>
<div class="pad_bot2">
<div class="scroll-pane scroll scroll2">
<?php echo get_data('content'); ?>
<a id="1" href="">Hello</a>
<div id="stuff"></div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</article>
finishes.php
include 'includes/library.php';
global $conn;
//$id = 1;
$query = "SELECT blurb FROM submenus WHERE id=" . $id;
$result = mysql_query($query, $conn);
confirm_query($result);
while($row = mysql_fetch_assoc($result)){
$name = $row['blurb'];
}
echo $name;
>ok I made a separate php file named finishes and I put the php code there
Read again : ID:35779496
This is what the page currently return
Read again : ID:35779496
This is what the page currently return
<br />
<b>Warning</b>: include(includes/library.php) [<a href='function.include'>function.include</a>]: failed to open stream: No such file or directory in <b>/home/content/19/7229919/html/tleithoff/includes/finishes.php</b> on line <b>3</b><br />
<br />
<b>Warning</b>: include() [<a href='function.include'>function.include</a>]: Failed opening 'includes/library.php' for inclusion (include_path='.:/usr/local/php5/lib/php') in <b>/home/content/19/7229919/html/tleithoff/includes/finishes.php</b> on line <b>3</b><br />
<br />
<b>Warning</b>: mysql_query(): supplied argument is not a valid MySQL-Link resource in <b>/home/content/19/7229919/html/tleithoff/includes/finishes.php</b> on line <b>7</b><br />
<br />
<b>Fatal error</b>: Call to undefined function confirm_query() in <b>/home/content/19/7229919/html/tleithoff/includes/finishes.php</b> on line <b>8</b><br />
I forgot they were in the same directory, now is should work except that it does not have a value for $id
Currently : Query failed: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1
A small update :
And use :
<?PHP
echo "[\"name\":\"FairyBusiness\"]";
?>
And use :
$("#1").click(function(e) {
e.preventDefault(); // uncomment this if the item is a link/anchor
$.getJSON("/tleithoff/includes/page.php", {"id":$(this).attr("id") }, function(data) {
$("#stuff").html(data.name); // put-data-here-selector is a div, a span, a cell, ...
});
});
>how did you get finishes.php?id=1
Yes, because it return what you can see in the pic ID:35780181
It's not a JSON object
That's why I asked you to modify/update finishes.php with the code ID:35780197
Yes, because it return what you can see in the pic ID:35780181
It's not a JSON object
That's why I asked you to modify/update finishes.php with the code ID:35780197
ok, yes it works!!
I dont understand the code that its in. . .
how do I get it to do this though:
I dont understand the code that its in. . .
how do I get it to do this though:
include 'includes/library.php';
global $conn;
//$id = 1;
$query = "SELECT blurb FROM submenus WHERE id=" . $id;
$result = mysql_query($query, $conn);
confirm_query($result);
while($row = mysql_fetch_assoc($result)){
$name = $row['blurb'];
}
echo $name;
ok I tried this but no luck:
include 'includes/library.php';
global $conn;
//$id = 1;
$query = "SELECT blurb FROM submenus WHERE id=" . $id;
$result = mysql_query($query, $conn);
confirm_query($result);
while($row = mysql_fetch_assoc($result)){
$name = $row['blurb'];
}
echo $name;
Try this :
<?PHP
include 'includes/library.php';
global $conn;
//$id = 1;
$query = "SELECT blurb FROM submenus WHERE id=" . $id;
$result = mysql_query($query, $conn);
confirm_query($result);
if($row = mysql_fetch_assoc($result)){
$name = $row['blurb'];
}
echo "{\"name\":\"" . $name . "\"}";
?>
>Is the id of the link transfering to the $id of php code??
Yes, id = 1 well transmitted to php code (the page finishes.php)
>nope, didnt work.
Yes, here the current error (it look like you're using the wrong path to your library POV finishes.php) :
Yes, id = 1 well transmitted to php code (the page finishes.php)
>nope, didnt work.
Yes, here the current error (it look like you're using the wrong path to your library POV finishes.php) :
<br />
<b>Warning</b>: include(includes/library.php) [<a href='function.include'>function.include</a>]: failed to open stream: No such file or directory in <b>/home/content/19/7229919/html/tleithoff/includes/finishes.php</b> on line <b>3</b><br />
<br />
<b>Warning</b>: include() [<a href='function.include'>function.include</a>]: Failed opening 'includes/library.php' for inclusion (include_path='.:/usr/local/php5/lib/php') in <b>/home/content/19/7229919/html/tleithoff/includes/finishes.php</b> on line <b>3</b><br />
<br />
<b>Warning</b>: mysql_query(): supplied argument is not a valid MySQL-Link resource in <b>/home/content/19/7229919/html/tleithoff/includes/finishes.php</b> on line <b>7</b><br />
<br />
<b>Fatal error</b>: Call to undefined function confirm_query() in <b>/home/content/19/7229919/html/tleithoff/includes/finishes.php</b> on line <b>8</b><br />
Query failed: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1
yes i know, thats why I am thinking the $id is not making it
<?PHP
include 'library.php';
global $conn;
//$id = 1;
$query = "SELECT blurb FROM submenus WHERE id=" . $id;
$result = mysql_query($query, $conn);
confirm_query($result);
var_dump($query);
if($row = mysql_fetch_assoc($result)){
$name = $row['blurb'];
}
echo "{\"name\":\"" . $name . "\"}";
?>
ok it work, remove line 9 and read again ID:35779496
add : $id = $_GET["id"]; // yes this is the missing part...
add : $id = $_GET["id"]; // yes this is the missing part...
I did this, but it did not work:
<?PHP
include 'library.php';
global $conn;
if( isset($_GET["id"]) ) {
$id = $_GET["id"];
$query = "SELECT blurb FROM submenus WHERE id=" . $id;
$result = mysql_query($query, $conn);
confirm_query($result);
var_dump($query);
if($row = mysql_fetch_assoc($result)){
$name = $row['blurb'];
}
echo "{\"name\":\"" . $name . "\"}";
}
?>
Premium Content
You need an Expert Office subscription to comment.Start Free Trial