Phoegap/Cordova to load specific DB row after AJAX GET The 2019 Stack Overflow Developer Survey Results Are In Announcing the arrival of Valued Associate #679: Cesar Manara Planned maintenance scheduled April 17/18, 2019 at 00:00UTC (8:00pm US/Eastern) The Ask Question Wizard is Live! Data science time! April 2019 and salary with experienceHow can I get jQuery to perform a synchronous, rather than asynchronous, Ajax request?How to manage a redirect request after a jQuery Ajax callJavaScript that executes after page loadjQuery $.ajax(), $.post sending “OPTIONS” as REQUEST_METHOD in FirefoxForm entries to query via PHP file and output result of PHP file using JQuery AJAXPHP/AJAX: Ajax request to php not working, not putting rows into divRetrieve more data when ID row in php is clicked using AJAXCannot display HTML stringHow to get value from select tag after Ajax response as html format?Add a row to a HTML table dynamically loaded and refresh it via AJAX and .load
Is it ok to offer lower paid work as a trial period before negotiating for a full-time job?
Can smartphones with the same camera sensor have different image quality?
Why does the Event Horizon Telescope (EHT) not include telescopes from Africa, Asia or Australia?
ELI5: Why do they say that Israel would have been the fourth country to land a spacecraft on the Moon and why do they call it low cost?
Is it ethical to upload a automatically generated paper to a non peer-reviewed site as part of a larger research?
Keeping a retro style to sci-fi spaceships?
How to prevent selfdestruct from another contract
Did the new image of black hole confirm the general theory of relativity?
Can a 1st-level character have an ability score above 18?
Windows 10: How to Lock (not sleep) laptop on lid close?
Segmentation fault output is suppressed when piping stdin into a function. Why?
Semisimplicity of the category of coherent sheaves?
Is this wall load bearing? Blueprints and photos attached
How to pronounce 1ターン?
How did passengers keep warm on sail ships?
How to grep and cut numbes from a file and sum them
Can a novice safely splice in wire to lengthen 5V charging cable?
Do working physicists consider Newtonian mechanics to be "falsified"?
Finding degree of a finite field extension
What was the last x86 CPU that did not have the x87 floating-point unit built in?
How does ice melt when immersed in water
Does the AirPods case need to be around while listening via an iOS Device?
Why is the object placed in the middle of the sentence here?
Is every episode of "Where are my Pants?" identical?
Phoegap/Cordova to load specific DB row after AJAX GET
The 2019 Stack Overflow Developer Survey Results Are In
Announcing the arrival of Valued Associate #679: Cesar Manara
Planned maintenance scheduled April 17/18, 2019 at 00:00UTC (8:00pm US/Eastern)
The Ask Question Wizard is Live!
Data science time! April 2019 and salary with experienceHow can I get jQuery to perform a synchronous, rather than asynchronous, Ajax request?How to manage a redirect request after a jQuery Ajax callJavaScript that executes after page loadjQuery $.ajax(), $.post sending “OPTIONS” as REQUEST_METHOD in FirefoxForm entries to query via PHP file and output result of PHP file using JQuery AJAXPHP/AJAX: Ajax request to php not working, not putting rows into divRetrieve more data when ID row in php is clicked using AJAXCannot display HTML stringHow to get value from select tag after Ajax response as html format?Add a row to a HTML table dynamically loaded and refresh it via AJAX and .load
.everyoneloves__top-leaderboard:empty,.everyoneloves__mid-leaderboard:empty,.everyoneloves__bot-mid-leaderboard:empty height:90px;width:728px;box-sizing:border-box;
Im building an app using PHoneGap as the compiler so using HTML5, CSS, JQuery, AJAX etc. Ive manage to get AJAX to GET all the rows from the Database perfectly well, as I have to use .HTML extension on my files I'm struggling to be able to link through to specific DB record. I can do this perfectly in PHP. Im struggling with the HTML part.
Here is my AJAX Loader to get all Rows from DB
var inProcessVideos = false;//Just to make sure that the last ajax call is not in process
setTimeout( function ()
if (inProcessVideos)
return false;//Another request is active, decline timer call ...
inProcessVideos = true;//make it burn ;)
jQuery.ajax(
url: 'https://MY-URL.COM/videos-mysql.php', //Define your script url here ...
data: '', //Pass some data if you need to
method: 'POST', //Makes sense only if you passing data
success: function(answer)
jQuery('#videos-modules').html(answer);//update your div with new content, yey ....
inProcessVideos = false;//Queue is free, guys ;)
,
error: function()
//unknown error occorupted
inProcessVideos = false;//Queue is free, guys ;)
);
, 500 );And here is the contents of the PHP File that renders all the Results from the Database. This part displays the content perfectly.
<?php
include ("../config/mysqli_connect.php");
$sql = ("SELECT * FROM videos");
$result = mysqli_query($conn, $sql);
if (mysqli_num_rows($result) > 0)
// output data of each row
while($row = mysqli_fetch_assoc($result))
echo "
<a href='" . $row["id"]. "'>
<div class='video-module'>
<div class='video-thumb'><img src='https://MY-URL.COM/thumbs/" . $row["video_thumb"]. "'></div>
<div class='video-thumb-details'>
<div class='video-thumb-title'> " . $row["id"]. " - " . $row["video_title"]. "</div>
" . $row["publisher_name"]. "
</div>
</div></a>
";
else
echo "0 results";
?>After the ECHO statement I would normally put something like video-Profile.php?id=$id and it would go to that page and pull in that record from the Database.
However now that I have to do it only in HTML, and im assuming AJAX, how to I achieve this.
Here is the PHP and the MYSQL Query to GET the specific record from the Database. Its currently in MYSQL, I will convert it to MYSQLi once I've got it working and got my head around it.
<?php
// Use the URL 'id' variable to set who we want to query info about
$id = ereg_replace("[^0-9]", "", $_GET['id']); // filter everything but numbers for security
if ($id == "")
echo "Missing Data to Run";
exit();
//Connect to the database through our include
include_once "../config/connect_to_mysql.php";
// Query member data from the database and ready it for display
$sql = mysql_query("SELECT * FROM videos WHERE id='$id' LIMIT 1");
$count = mysql_num_rows($sql);
if ($count > 1)
echo "There is no user with that id here.";
exit();
while($row = mysql_fetch_array($sql))
$id = $row["id"];
$video_title = $row["video_title"];
$video_thumb = $row["video_thumb"];
$publisher_name = $row["publisher_name"];
$video_directory = $row["video_directory"];
$video_path = $row["video_path"];
$upload_date = $row["upload_date"];
$video_views = $row["video_views"];
?>
<!doctype html>
<html>
<head>
<meta charset="UTF-8">
<title>Untitled Document</title>
</head>
<body>
<?php echo ("$id");?> - <?php echo ("$video_thumb");?>
</body>
</html>I know this works if I'm running PHP files, and my server is set to PHPv5.3., but before I make it live, it will be sorted to MYSQLi and run on PHP7???
Im looking for inspiration to get this to function via HTML only files.
thanks for your help everyone.
html ajax cordova mysqli phonegap
asked Mar 8 at 13:22
Mark RhodesMark Rhodes
33
add a comment |
Im building an app using PHoneGap as the compiler so using HTML5, CSS, JQuery, AJAX etc. Ive manage to get AJAX to GET all the rows from the Database perfectly well, as I have to use .HTML extension on my files I'm struggling to be able to link through to specific DB record. I can do this perfectly in PHP. Im struggling with the HTML part.
Here is my AJAX Loader to get all Rows from DB
var inProcessVideos = false;//Just to make sure that the last ajax call is not in process
setTimeout( function ()
if (inProcessVideos)
return false;//Another request is active, decline timer call ...
inProcessVideos = true;//make it burn ;)
jQuery.ajax(
url: 'https://MY-URL.COM/videos-mysql.php', //Define your script url here ...
data: '', //Pass some data if you need to
method: 'POST', //Makes sense only if you passing data
success: function(answer)
jQuery('#videos-modules').html(answer);//update your div with new content, yey ....
inProcessVideos = false;//Queue is free, guys ;)
,
error: function()
//unknown error occorupted
inProcessVideos = false;//Queue is free, guys ;)
);
, 500 );And here is the contents of the PHP File that renders all the Results from the Database. This part displays the content perfectly.
<?php
include ("../config/mysqli_connect.php");
$sql = ("SELECT * FROM videos");
$result = mysqli_query($conn, $sql);
if (mysqli_num_rows($result) > 0)
// output data of each row
while($row = mysqli_fetch_assoc($result))
echo "
<a href='" . $row["id"]. "'>
<div class='video-module'>
<div class='video-thumb'><img src='https://MY-URL.COM/thumbs/" . $row["video_thumb"]. "'></div>
<div class='video-thumb-details'>
<div class='video-thumb-title'> " . $row["id"]. " - " . $row["video_title"]. "</div>
" . $row["publisher_name"]. "
</div>
</div></a>
";
else
echo "0 results";
?>After the ECHO statement I would normally put something like video-Profile.php?id=$id and it would go to that page and pull in that record from the Database.
However now that I have to do it only in HTML, and im assuming AJAX, how to I achieve this.
Here is the PHP and the MYSQL Query to GET the specific record from the Database. Its currently in MYSQL, I will convert it to MYSQLi once I've got it working and got my head around it.
<?php
// Use the URL 'id' variable to set who we want to query info about
$id = ereg_replace("[^0-9]", "", $_GET['id']); // filter everything but numbers for security
if ($id == "")
echo "Missing Data to Run";
exit();
//Connect to the database through our include
include_once "../config/connect_to_mysql.php";
// Query member data from the database and ready it for display
$sql = mysql_query("SELECT * FROM videos WHERE id='$id' LIMIT 1");
$count = mysql_num_rows($sql);
if ($count > 1)
echo "There is no user with that id here.";
exit();
while($row = mysql_fetch_array($sql))
$id = $row["id"];
$video_title = $row["video_title"];
$video_thumb = $row["video_thumb"];
$publisher_name = $row["publisher_name"];
$video_directory = $row["video_directory"];
$video_path = $row["video_path"];
$upload_date = $row["upload_date"];
$video_views = $row["video_views"];
?>
<!doctype html>
<html>
<head>
<meta charset="UTF-8">
<title>Untitled Document</title>
</head>
<body>
<?php echo ("$id");?> - <?php echo ("$video_thumb");?>
</body>
</html>I know this works if I'm running PHP files, and my server is set to PHPv5.3., but before I make it live, it will be sorted to MYSQLi and run on PHP7???
Im looking for inspiration to get this to function via HTML only files.
thanks for your help everyone.
html ajax cordova mysqli phonegap
asked Mar 8 at 13:22
Mark RhodesMark Rhodes
33
add a comment |
Im building an app using PHoneGap as the compiler so using HTML5, CSS, JQuery, AJAX etc. Ive manage to get AJAX to GET all the rows from the Database perfectly well, as I have to use .HTML extension on my files I'm struggling to be able to link through to specific DB record. I can do this perfectly in PHP. Im struggling with the HTML part.
Here is my AJAX Loader to get all Rows from DB
var inProcessVideos = false;//Just to make sure that the last ajax call is not in process
setTimeout( function ()
if (inProcessVideos)
return false;//Another request is active, decline timer call ...
inProcessVideos = true;//make it burn ;)
jQuery.ajax(
url: 'https://MY-URL.COM/videos-mysql.php', //Define your script url here ...
data: '', //Pass some data if you need to
method: 'POST', //Makes sense only if you passing data
success: function(answer)
jQuery('#videos-modules').html(answer);//update your div with new content, yey ....
inProcessVideos = false;//Queue is free, guys ;)
,
error: function()
//unknown error occorupted
inProcessVideos = false;//Queue is free, guys ;)
);
, 500 );And here is the contents of the PHP File that renders all the Results from the Database. This part displays the content perfectly.
<?php
include ("../config/mysqli_connect.php");
$sql = ("SELECT * FROM videos");
$result = mysqli_query($conn, $sql);
if (mysqli_num_rows($result) > 0)
// output data of each row
while($row = mysqli_fetch_assoc($result))
echo "
<a href='" . $row["id"]. "'>
<div class='video-module'>
<div class='video-thumb'><img src='https://MY-URL.COM/thumbs/" . $row["video_thumb"]. "'></div>
<div class='video-thumb-details'>
<div class='video-thumb-title'> " . $row["id"]. " - " . $row["video_title"]. "</div>
" . $row["publisher_name"]. "
</div>
</div></a>
";
else
echo "0 results";
?>After the ECHO statement I would normally put something like video-Profile.php?id=$id and it would go to that page and pull in that record from the Database.
However now that I have to do it only in HTML, and im assuming AJAX, how to I achieve this.
Here is the PHP and the MYSQL Query to GET the specific record from the Database. Its currently in MYSQL, I will convert it to MYSQLi once I've got it working and got my head around it.
<?php
// Use the URL 'id' variable to set who we want to query info about
$id = ereg_replace("[^0-9]", "", $_GET['id']); // filter everything but numbers for security
if ($id == "")
echo "Missing Data to Run";
exit();
//Connect to the database through our include
include_once "../config/connect_to_mysql.php";
// Query member data from the database and ready it for display
$sql = mysql_query("SELECT * FROM videos WHERE id='$id' LIMIT 1");
$count = mysql_num_rows($sql);
if ($count > 1)
echo "There is no user with that id here.";
exit();
while($row = mysql_fetch_array($sql))
$id = $row["id"];
$video_title = $row["video_title"];
$video_thumb = $row["video_thumb"];
$publisher_name = $row["publisher_name"];
$video_directory = $row["video_directory"];
$video_path = $row["video_path"];
$upload_date = $row["upload_date"];
$video_views = $row["video_views"];
?>
<!doctype html>
<html>
<head>
<meta charset="UTF-8">
<title>Untitled Document</title>
</head>
<body>
<?php echo ("$id");?> - <?php echo ("$video_thumb");?>
</body>
</html>I know this works if I'm running PHP files, and my server is set to PHPv5.3., but before I make it live, it will be sorted to MYSQLi and run on PHP7???
Im looking for inspiration to get this to function via HTML only files.
thanks for your help everyone.
html ajax cordova mysqli phonegap
asked Mar 8 at 13:22
Mark RhodesMark Rhodes
33
Im building an app using PHoneGap as the compiler so using HTML5, CSS, JQuery, AJAX etc. Ive manage to get AJAX to GET all the rows from the Database perfectly well, as I have to use .HTML extension on my files I'm struggling to be able to link through to specific DB record. I can do this perfectly in PHP. Im struggling with the HTML part.
Here is my AJAX Loader to get all Rows from DB
var inProcessVideos = false;//Just to make sure that the last ajax call is not in process
setTimeout( function ()
if (inProcessVideos)
return false;//Another request is active, decline timer call ...
inProcessVideos = true;//make it burn ;)
jQuery.ajax(
url: 'https://MY-URL.COM/videos-mysql.php', //Define your script url here ...
data: '', //Pass some data if you need to
method: 'POST', //Makes sense only if you passing data
success: function(answer)
jQuery('#videos-modules').html(answer);//update your div with new content, yey ....
inProcessVideos = false;//Queue is free, guys ;)
,
error: function()
//unknown error occorupted
inProcessVideos = false;//Queue is free, guys ;)
);
, 500 );And here is the contents of the PHP File that renders all the Results from the Database. This part displays the content perfectly.
<?php
include ("../config/mysqli_connect.php");
$sql = ("SELECT * FROM videos");
$result = mysqli_query($conn, $sql);
if (mysqli_num_rows($result) > 0)
// output data of each row
while($row = mysqli_fetch_assoc($result))
echo "
<a href='" . $row["id"]. "'>
<div class='video-module'>
<div class='video-thumb'><img src='https://MY-URL.COM/thumbs/" . $row["video_thumb"]. "'></div>
<div class='video-thumb-details'>
<div class='video-thumb-title'> " . $row["id"]. " - " . $row["video_title"]. "</div>
" . $row["publisher_name"]. "
</div>
</div></a>
";
else
echo "0 results";
?>After the ECHO statement I would normally put something like video-Profile.php?id=$id and it would go to that page and pull in that record from the Database.
However now that I have to do it only in HTML, and im assuming AJAX, how to I achieve this.
Here is the PHP and the MYSQL Query to GET the specific record from the Database. Its currently in MYSQL, I will convert it to MYSQLi once I've got it working and got my head around it.
<?php
// Use the URL 'id' variable to set who we want to query info about
$id = ereg_replace("[^0-9]", "", $_GET['id']); // filter everything but numbers for security
if ($id == "")
echo "Missing Data to Run";
exit();
//Connect to the database through our include
include_once "../config/connect_to_mysql.php";
// Query member data from the database and ready it for display
$sql = mysql_query("SELECT * FROM videos WHERE id='$id' LIMIT 1");
$count = mysql_num_rows($sql);
if ($count > 1)
echo "There is no user with that id here.";
exit();
while($row = mysql_fetch_array($sql))
$id = $row["id"];
$video_title = $row["video_title"];
$video_thumb = $row["video_thumb"];
$publisher_name = $row["publisher_name"];
$video_directory = $row["video_directory"];
$video_path = $row["video_path"];
$upload_date = $row["upload_date"];
$video_views = $row["video_views"];
?>
<!doctype html>
<html>
<head>
<meta charset="UTF-8">
<title>Untitled Document</title>
</head>
<body>
<?php echo ("$id");?> - <?php echo ("$video_thumb");?>
</body>
</html>I know this works if I'm running PHP files, and my server is set to PHPv5.3., but before I make it live, it will be sorted to MYSQLi and run on PHP7???
Im looking for inspiration to get this to function via HTML only files.
thanks for your help everyone.
var inProcessVideos = false;//Just to make sure that the last ajax call is not in process
setTimeout( function ()
if (inProcessVideos)
return false;//Another request is active, decline timer call ...
inProcessVideos = true;//make it burn ;)
jQuery.ajax(
url: 'https://MY-URL.COM/videos-mysql.php', //Define your script url here ...
data: '', //Pass some data if you need to
method: 'POST', //Makes sense only if you passing data
success: function(answer)
jQuery('#videos-modules').html(answer);//update your div with new content, yey ....
inProcessVideos = false;//Queue is free, guys ;)
,
error: function()
//unknown error occorupted
inProcessVideos = false;//Queue is free, guys ;)
);
, 500 );var inProcessVideos = false;//Just to make sure that the last ajax call is not in process
setTimeout( function ()
if (inProcessVideos)
return false;//Another request is active, decline timer call ...
inProcessVideos = true;//make it burn ;)
jQuery.ajax(
url: 'https://MY-URL.COM/videos-mysql.php', //Define your script url here ...
data: '', //Pass some data if you need to
method: 'POST', //Makes sense only if you passing data
success: function(answer)
jQuery('#videos-modules').html(answer);//update your div with new content, yey ....
inProcessVideos = false;//Queue is free, guys ;)
,
error: function()
//unknown error occorupted
inProcessVideos = false;//Queue is free, guys ;)
);
, 500 );<?php
include ("../config/mysqli_connect.php");
$sql = ("SELECT * FROM videos");
$result = mysqli_query($conn, $sql);
if (mysqli_num_rows($result) > 0)
// output data of each row
while($row = mysqli_fetch_assoc($result))
echo "
<a href='" . $row["id"]. "'>
<div class='video-module'>
<div class='video-thumb'><img src='https://MY-URL.COM/thumbs/" . $row["video_thumb"]. "'></div>
<div class='video-thumb-details'>
<div class='video-thumb-title'> " . $row["id"]. " - " . $row["video_title"]. "</div>
" . $row["publisher_name"]. "
</div>
</div></a>
";
else
echo "0 results";
?><?php
include ("../config/mysqli_connect.php");
$sql = ("SELECT * FROM videos");
$result = mysqli_query($conn, $sql);
if (mysqli_num_rows($result) > 0)
// output data of each row
while($row = mysqli_fetch_assoc($result))
echo "
<a href='" . $row["id"]. "'>
<div class='video-module'>
<div class='video-thumb'><img src='https://MY-URL.COM/thumbs/" . $row["video_thumb"]. "'></div>
<div class='video-thumb-details'>
<div class='video-thumb-title'> " . $row["id"]. " - " . $row["video_title"]. "</div>
" . $row["publisher_name"]. "
</div>
</div></a>
";
else
echo "0 results";
?><?php
// Use the URL 'id' variable to set who we want to query info about
$id = ereg_replace("[^0-9]", "", $_GET['id']); // filter everything but numbers for security
if ($id == "")
echo "Missing Data to Run";
exit();
//Connect to the database through our include
include_once "../config/connect_to_mysql.php";
// Query member data from the database and ready it for display
$sql = mysql_query("SELECT * FROM videos WHERE id='$id' LIMIT 1");
$count = mysql_num_rows($sql);
if ($count > 1)
echo "There is no user with that id here.";
exit();
while($row = mysql_fetch_array($sql))
$id = $row["id"];
$video_title = $row["video_title"];
$video_thumb = $row["video_thumb"];
$publisher_name = $row["publisher_name"];
$video_directory = $row["video_directory"];
$video_path = $row["video_path"];
$upload_date = $row["upload_date"];
$video_views = $row["video_views"];
?>
<!doctype html>
<html>
<head>
<meta charset="UTF-8">
<title>Untitled Document</title>
</head>
<body>
<?php echo ("$id");?> - <?php echo ("$video_thumb");?>
</body>
</html><?php
// Use the URL 'id' variable to set who we want to query info about
$id = ereg_replace("[^0-9]", "", $_GET['id']); // filter everything but numbers for security
if ($id == "")
echo "Missing Data to Run";
exit();
//Connect to the database through our include
include_once "../config/connect_to_mysql.php";
// Query member data from the database and ready it for display
$sql = mysql_query("SELECT * FROM videos WHERE id='$id' LIMIT 1");
$count = mysql_num_rows($sql);
if ($count > 1)
echo "There is no user with that id here.";
exit();
while($row = mysql_fetch_array($sql))
$id = $row["id"];
$video_title = $row["video_title"];
$video_thumb = $row["video_thumb"];
$publisher_name = $row["publisher_name"];
$video_directory = $row["video_directory"];
$video_path = $row["video_path"];
$upload_date = $row["upload_date"];
$video_views = $row["video_views"];
?>
<!doctype html>
<html>
<head>
<meta charset="UTF-8">
<title>Untitled Document</title>
</head>
<body>
<?php echo ("$id");?> - <?php echo ("$video_thumb");?>
</body>
</html>html ajax cordova mysqli phonegap
html ajax cordova mysqli phonegap
asked Mar 8 at 13:22
Mark RhodesMark Rhodes
33
asked Mar 8 at 13:22
Mark RhodesMark Rhodes
33
asked Mar 8 at 13:22
Mark RhodesMark Rhodes
33
asked Mar 8 at 13:22
Mark RhodesMark Rhodes
33
asked Mar 8 at 13:22
Mark RhodesMark Rhodes
33
33
add a comment |
add a comment |
2 Answers
2
active
oldest
votes
This is a pretty brutalistic way of doing this - typically you'd return JSON or similar from the PHP and then process this into the HTML elements within your JS. But for this case you can do this:
//within call
success: function(answer)
var contents = jQuery(answer); // You have now converted the HTML into a jquery model
contents.filter(function(element)
return $(element).attr('id') === id
) // This allows you to search your child elements and pick them based on criteria
jQuery('#videos-modules').html(contents); // now assign the remaining elements into your html as before
,
answered Mar 8 at 13:41
TobinTobin
612515
Thank you for your help. It’s greatly appreciated. I e added your code to my Ajax request, not working yet, I’ll give it another try when I finish work.
– Mark Rhodes
Mar 8 at 17:17
Do you recommend an easier way of doing this? Or simpler way of doing this? I’m not expecting it to be done for me, just need pointing in the right direction. Thanks
– Mark Rhodes
Mar 8 at 17:19
add a comment |
I have Tried this but i cant seem to find out how to Run a Console Log as it is Run on iOS iPad at the moment. Can not get it to render in the Browser.
var inProcessVideos = false;//Just to make sure that the last ajax call is not in process
setTimeout( function ()
if (inProcessVideos)
return false;//Another request is active, decline timer call
inProcessVideos = true;//make it burn ;)
jQuery.ajax(
url: 'https://MYURL.COM/appFiles/tablet/video-profile.php', //Define your script url here ...
data: '', //Pass some data if you need to
method: 'GET', //Makes sense only if you passing data
success: function(answer)
var contents = jQuery(answer); // You have now converted the HTML into a jquery model
contents.filter(function(element)
return $(element).attr('id') === id;
);
jQuery('#videoProfile').html(answer);//update your div with new content, yey ....
inProcessVideos = false;//Queue is free, guys ;)
,
);
, 500 );Struggling with this, i've looked at all the JQuery, AJAX MySQL web sites i can find including W3Schools, Jquery.com and many others. Just can not get it to pass the ID to the PHP file to get the Record from the DB via AJAX.
My Links in the first JQuery AJAX Call are:
<a href='video-Profile.html' data='".$row["id"]."' value='".$row["id"]." '>Some HTML STUFF/Images/Text etc</a> I can get the ID and the First AJAX Call to show ALL the rows in the DB Table. Now just need to show Record by ID. This is what i cant get my head around. And it must be in .HTML Page as its an App compiled via PhoneGap. I know im repeating my self, Just not to sure if im making my point clear. Thanks for the help in advance.
answered Mar 11 at 19:38
Mark RhodesMark Rhodes
33
add a comment |
Your Answer
StackExchange.ifUsing("editor", function ()
StackExchange.using("externalEditor", function ()
StackExchange.using("snippets", function ()
StackExchange.snippets.init();
);
);
, "code-snippets");
StackExchange.ready(function()
var channelOptions =
tags: "".split(" "),
id: "1"
;
initTagRenderer("".split(" "), "".split(" "), channelOptions);
StackExchange.using("externalEditor", function()
// Have to fire editor after snippets, if snippets enabled
if (StackExchange.settings.snippets.snippetsEnabled)
StackExchange.using("snippets", function()
createEditor();
);
else
createEditor();
);
function createEditor()
StackExchange.prepareEditor(
heartbeatType: 'answer',
autoActivateHeartbeat: false,
convertImagesToLinks: true,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: 10,
bindNavPrevention: true,
postfix: "",
imageUploader:
brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
allowUrls: true
,
onDemand: true,
discardSelector: ".discard-answer"
,immediatelyShowMarkdownHelp:true
);
);
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function ()
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f55064120%2fphoegap-cordova-to-load-specific-db-row-after-ajax-get%23new-answer', 'question_page');
);
Post as a guest
Required, but never shown
2 Answers
2
active
oldest
votes
2 Answers
2
active
oldest
votes
active
oldest
votes
active
oldest
votes
This is a pretty brutalistic way of doing this - typically you'd return JSON or similar from the PHP and then process this into the HTML elements within your JS. But for this case you can do this:
//within call
success: function(answer)
var contents = jQuery(answer); // You have now converted the HTML into a jquery model
contents.filter(function(element)
return $(element).attr('id') === id
) // This allows you to search your child elements and pick them based on criteria
jQuery('#videos-modules').html(contents); // now assign the remaining elements into your html as before
,
answered Mar 8 at 13:41
TobinTobin
612515
Thank you for your help. It’s greatly appreciated. I e added your code to my Ajax request, not working yet, I’ll give it another try when I finish work.
– Mark Rhodes
Mar 8 at 17:17
Do you recommend an easier way of doing this? Or simpler way of doing this? I’m not expecting it to be done for me, just need pointing in the right direction. Thanks
– Mark Rhodes
Mar 8 at 17:19
add a comment |
This is a pretty brutalistic way of doing this - typically you'd return JSON or similar from the PHP and then process this into the HTML elements within your JS. But for this case you can do this:
//within call
success: function(answer)
var contents = jQuery(answer); // You have now converted the HTML into a jquery model
contents.filter(function(element)
return $(element).attr('id') === id
) // This allows you to search your child elements and pick them based on criteria
jQuery('#videos-modules').html(contents); // now assign the remaining elements into your html as before
,
answered Mar 8 at 13:41
TobinTobin
612515
Thank you for your help. It’s greatly appreciated. I e added your code to my Ajax request, not working yet, I’ll give it another try when I finish work.
– Mark Rhodes
Mar 8 at 17:17
Do you recommend an easier way of doing this? Or simpler way of doing this? I’m not expecting it to be done for me, just need pointing in the right direction. Thanks
– Mark Rhodes
Mar 8 at 17:19
add a comment |
This is a pretty brutalistic way of doing this - typically you'd return JSON or similar from the PHP and then process this into the HTML elements within your JS. But for this case you can do this:
//within call
success: function(answer)
var contents = jQuery(answer); // You have now converted the HTML into a jquery model
contents.filter(function(element)
return $(element).attr('id') === id
) // This allows you to search your child elements and pick them based on criteria
jQuery('#videos-modules').html(contents); // now assign the remaining elements into your html as before
,
answered Mar 8 at 13:41
TobinTobin
612515
This is a pretty brutalistic way of doing this - typically you'd return JSON or similar from the PHP and then process this into the HTML elements within your JS. But for this case you can do this:
//within call
success: function(answer)
var contents = jQuery(answer); // You have now converted the HTML into a jquery model
contents.filter(function(element)
return $(element).attr('id') === id
) // This allows you to search your child elements and pick them based on criteria
jQuery('#videos-modules').html(contents); // now assign the remaining elements into your html as before
,
answered Mar 8 at 13:41
TobinTobin
612515
answered Mar 8 at 13:41
TobinTobin
612515
answered Mar 8 at 13:41
TobinTobin
612515
answered Mar 8 at 13:41
TobinTobin
612515
612515
Thank you for your help. It’s greatly appreciated. I e added your code to my Ajax request, not working yet, I’ll give it another try when I finish work.
– Mark Rhodes
Mar 8 at 17:17
Do you recommend an easier way of doing this? Or simpler way of doing this? I’m not expecting it to be done for me, just need pointing in the right direction. Thanks
– Mark Rhodes
Mar 8 at 17:19
add a comment |
Thank you for your help. It’s greatly appreciated. I e added your code to my Ajax request, not working yet, I’ll give it another try when I finish work.
– Mark Rhodes
Mar 8 at 17:17
Do you recommend an easier way of doing this? Or simpler way of doing this? I’m not expecting it to be done for me, just need pointing in the right direction. Thanks
– Mark Rhodes
Mar 8 at 17:19
Thank you for your help. It’s greatly appreciated. I e added your code to my Ajax request, not working yet, I’ll give it another try when I finish work.
– Mark Rhodes
Mar 8 at 17:17
Thank you for your help. It’s greatly appreciated. I e added your code to my Ajax request, not working yet, I’ll give it another try when I finish work.
– Mark Rhodes
Mar 8 at 17:17
Do you recommend an easier way of doing this? Or simpler way of doing this? I’m not expecting it to be done for me, just need pointing in the right direction. Thanks
– Mark Rhodes
Mar 8 at 17:19
Do you recommend an easier way of doing this? Or simpler way of doing this? I’m not expecting it to be done for me, just need pointing in the right direction. Thanks
– Mark Rhodes
Mar 8 at 17:19
add a comment |
I have Tried this but i cant seem to find out how to Run a Console Log as it is Run on iOS iPad at the moment. Can not get it to render in the Browser.
var inProcessVideos = false;//Just to make sure that the last ajax call is not in process
setTimeout( function ()
if (inProcessVideos)
return false;//Another request is active, decline timer call
inProcessVideos = true;//make it burn ;)
jQuery.ajax(
url: 'https://MYURL.COM/appFiles/tablet/video-profile.php', //Define your script url here ...
data: '', //Pass some data if you need to
method: 'GET', //Makes sense only if you passing data
success: function(answer)
var contents = jQuery(answer); // You have now converted the HTML into a jquery model
contents.filter(function(element)
return $(element).attr('id') === id;
);
jQuery('#videoProfile').html(answer);//update your div with new content, yey ....
inProcessVideos = false;//Queue is free, guys ;)
,
);
, 500 );Struggling with this, i've looked at all the JQuery, AJAX MySQL web sites i can find including W3Schools, Jquery.com and many others. Just can not get it to pass the ID to the PHP file to get the Record from the DB via AJAX.
My Links in the first JQuery AJAX Call are:
<a href='video-Profile.html' data='".$row["id"]."' value='".$row["id"]." '>Some HTML STUFF/Images/Text etc</a> I can get the ID and the First AJAX Call to show ALL the rows in the DB Table. Now just need to show Record by ID. This is what i cant get my head around. And it must be in .HTML Page as its an App compiled via PhoneGap. I know im repeating my self, Just not to sure if im making my point clear. Thanks for the help in advance.
answered Mar 11 at 19:38
Mark RhodesMark Rhodes
33
add a comment |
I have Tried this but i cant seem to find out how to Run a Console Log as it is Run on iOS iPad at the moment. Can not get it to render in the Browser.
var inProcessVideos = false;//Just to make sure that the last ajax call is not in process
setTimeout( function ()
if (inProcessVideos)
return false;//Another request is active, decline timer call
inProcessVideos = true;//make it burn ;)
jQuery.ajax(
url: 'https://MYURL.COM/appFiles/tablet/video-profile.php', //Define your script url here ...
data: '', //Pass some data if you need to
method: 'GET', //Makes sense only if you passing data
success: function(answer)
var contents = jQuery(answer); // You have now converted the HTML into a jquery model
contents.filter(function(element)
return $(element).attr('id') === id;
);
jQuery('#videoProfile').html(answer);//update your div with new content, yey ....
inProcessVideos = false;//Queue is free, guys ;)
,
);
, 500 );Struggling with this, i've looked at all the JQuery, AJAX MySQL web sites i can find including W3Schools, Jquery.com and many others. Just can not get it to pass the ID to the PHP file to get the Record from the DB via AJAX.
My Links in the first JQuery AJAX Call are:
<a href='video-Profile.html' data='".$row["id"]."' value='".$row["id"]." '>Some HTML STUFF/Images/Text etc</a> I can get the ID and the First AJAX Call to show ALL the rows in the DB Table. Now just need to show Record by ID. This is what i cant get my head around. And it must be in .HTML Page as its an App compiled via PhoneGap. I know im repeating my self, Just not to sure if im making my point clear. Thanks for the help in advance.
answered Mar 11 at 19:38
Mark RhodesMark Rhodes
33
add a comment |
I have Tried this but i cant seem to find out how to Run a Console Log as it is Run on iOS iPad at the moment. Can not get it to render in the Browser.
var inProcessVideos = false;//Just to make sure that the last ajax call is not in process
setTimeout( function ()
if (inProcessVideos)
return false;//Another request is active, decline timer call
inProcessVideos = true;//make it burn ;)
jQuery.ajax(
url: 'https://MYURL.COM/appFiles/tablet/video-profile.php', //Define your script url here ...
data: '', //Pass some data if you need to
method: 'GET', //Makes sense only if you passing data
success: function(answer)
var contents = jQuery(answer); // You have now converted the HTML into a jquery model
contents.filter(function(element)
return $(element).attr('id') === id;
);
jQuery('#videoProfile').html(answer);//update your div with new content, yey ....
inProcessVideos = false;//Queue is free, guys ;)
,
);
, 500 );Struggling with this, i've looked at all the JQuery, AJAX MySQL web sites i can find including W3Schools, Jquery.com and many others. Just can not get it to pass the ID to the PHP file to get the Record from the DB via AJAX.
My Links in the first JQuery AJAX Call are:
<a href='video-Profile.html' data='".$row["id"]."' value='".$row["id"]." '>Some HTML STUFF/Images/Text etc</a> I can get the ID and the First AJAX Call to show ALL the rows in the DB Table. Now just need to show Record by ID. This is what i cant get my head around. And it must be in .HTML Page as its an App compiled via PhoneGap. I know im repeating my self, Just not to sure if im making my point clear. Thanks for the help in advance.
answered Mar 11 at 19:38
Mark RhodesMark Rhodes
33
I have Tried this but i cant seem to find out how to Run a Console Log as it is Run on iOS iPad at the moment. Can not get it to render in the Browser.
var inProcessVideos = false;//Just to make sure that the last ajax call is not in process
setTimeout( function ()
if (inProcessVideos)
return false;//Another request is active, decline timer call
inProcessVideos = true;//make it burn ;)
jQuery.ajax(
url: 'https://MYURL.COM/appFiles/tablet/video-profile.php', //Define your script url here ...
data: '', //Pass some data if you need to
method: 'GET', //Makes sense only if you passing data
success: function(answer)
var contents = jQuery(answer); // You have now converted the HTML into a jquery model
contents.filter(function(element)
return $(element).attr('id') === id;
);
jQuery('#videoProfile').html(answer);//update your div with new content, yey ....
inProcessVideos = false;//Queue is free, guys ;)
,
);
, 500 );Struggling with this, i've looked at all the JQuery, AJAX MySQL web sites i can find including W3Schools, Jquery.com and many others. Just can not get it to pass the ID to the PHP file to get the Record from the DB via AJAX.
My Links in the first JQuery AJAX Call are:
<a href='video-Profile.html' data='".$row["id"]."' value='".$row["id"]." '>Some HTML STUFF/Images/Text etc</a> I can get the ID and the First AJAX Call to show ALL the rows in the DB Table. Now just need to show Record by ID. This is what i cant get my head around. And it must be in .HTML Page as its an App compiled via PhoneGap. I know im repeating my self, Just not to sure if im making my point clear. Thanks for the help in advance.
var inProcessVideos = false;//Just to make sure that the last ajax call is not in process
setTimeout( function ()
if (inProcessVideos)
return false;//Another request is active, decline timer call
inProcessVideos = true;//make it burn ;)
jQuery.ajax(
url: 'https://MYURL.COM/appFiles/tablet/video-profile.php', //Define your script url here ...
data: '', //Pass some data if you need to
method: 'GET', //Makes sense only if you passing data
success: function(answer)
var contents = jQuery(answer); // You have now converted the HTML into a jquery model
contents.filter(function(element)
return $(element).attr('id') === id;
);
jQuery('#videoProfile').html(answer);//update your div with new content, yey ....
inProcessVideos = false;//Queue is free, guys ;)
,
);
, 500 );var inProcessVideos = false;//Just to make sure that the last ajax call is not in process
setTimeout( function ()
if (inProcessVideos)
return false;//Another request is active, decline timer call
inProcessVideos = true;//make it burn ;)
jQuery.ajax(
url: 'https://MYURL.COM/appFiles/tablet/video-profile.php', //Define your script url here ...
data: '', //Pass some data if you need to
method: 'GET', //Makes sense only if you passing data
success: function(answer)
var contents = jQuery(answer); // You have now converted the HTML into a jquery model
contents.filter(function(element)
return $(element).attr('id') === id;
);
jQuery('#videoProfile').html(answer);//update your div with new content, yey ....
inProcessVideos = false;//Queue is free, guys ;)
,
);
, 500 );<a href='video-Profile.html' data='".$row["id"]."' value='".$row["id"]." '>Some HTML STUFF/Images/Text etc</a> <a href='video-Profile.html' data='".$row["id"]."' value='".$row["id"]." '>Some HTML STUFF/Images/Text etc</a> answered Mar 11 at 19:38
Mark RhodesMark Rhodes
33
answered Mar 11 at 19:38
Mark RhodesMark Rhodes
33
answered Mar 11 at 19:38
Mark RhodesMark Rhodes
33
answered Mar 11 at 19:38
Mark RhodesMark Rhodes
33
33
add a comment |
add a comment |
Thanks for contributing an answer to Stack Overflow!
- Please be sure to answer the question. Provide details and share your research!
But avoid …
- Asking for help, clarification, or responding to other answers.
- Making statements based on opinion; back them up with references or personal experience.
To learn more, see our tips on writing great answers.
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function ()
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f55064120%2fphoegap-cordova-to-load-specific-db-row-after-ajax-get%23new-answer', 'question_page');
);
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
