I want to do is let the user input a file,then read the contents send it to the server, loop over the inputs to query MySQL, return the results and display it in a user friendly,scrollable table?
View 1 RepliesThis is a combination of jQuery and a PHP problem so I'm not 100% certain where to post it. I am working on method to reoder a list that comes from a database. When the lists is displayed, it will be ordered by a "sort" column. The user can drag/drop the list to change the order, and I want the order to update the sort values in the database.I found a script that provides a decent starting point, but I am not getting the results I want.
1: It is able to reorder the columns, and save the results which is good.
2: It is saving the results as "0,1,2,3" rather than reordering the numbers from the "sort" column. (< this is what I need fixed)
EG: Name > Sort
Apple3
Orange 5
Pear 13
Kiwi 105
If I reorder these in the reverse order using the script, I end up with the following in the database.
Apple 3
Orange 2
Pear 1
Kiwi 0
Yet what I want is,
Apple 105
Orange 13
Pear 5
Kiwi 3
how I can get it to work with the existing "sort" values, rather than serializing and starting at 0. Here are the script files I am currently working with for testing.
DATABASE
Code:
CREATE TABLE `menu` (
`id` int(11) NOT NULL auto_increment,[code]....
I have a PHP file which is called upon through AJAX. The PHP file "fetch.php" searches the database with the given JS variables, an x and y co-ordinate, through GET, and brings back the user id associated with those co-ordinates. So I then get that users information... I'm then trying to bring those PHP variables back into the AJAX call on the original page and display the results. Here's what I've got so far...
Javascript/jQuery
Code JavaScript:
<script type="text/javascript">
jQuery.fn.elementlocation = function() {
var curleft = 0;
var curtop = 0;
var obj = this;
do {
curleft += obj.attr('offsetLeft');
curtop += obj.attr('offsetTop');
obj = obj.offsetParent();
} while ( obj.attr('tagName') != 'BODY' ); .....
Everything is working fine, except one thing, I've check the php file and it does echo a username so I know there is a result being sent back from my query. It's just I can't seem to get the user_name_area and user_online_area to display the results from the fetch.php file. Am I parsing them correctly, do I have to assign them to a variable or is what I'm trying to do impossible? I've never attempted this whole json thing before and I seem to be having some problems with it.
I have successfully loaded an element of content from another section of our website on a page, but for some reason it is firing .load() twice and displaying the section of content twice, stacked on top of each other.
<script type="text/javascript" src="/js/jquery.162.min.js"></script>
<script type="text/javascript">
$(function() {
$('#site_navigation').load('/store/ .menu_div', function() {
[Code]....
This form retrieves results from a mysql database. It works fine but when I click submit it shows the result only for a second. When I hold down submit the result stays there. How do I get the result to stay on the screen after I hit submit? Even better how do I get it to spit out results without having to hit a submit button or press enter?
View 15 Replies View RelatedI'm putting together the following website, HGV/LGV Training [URL] and have an issue regarding a form submit action. Basically I've used an open-source script for the search form so can't get any support from the Author.
My problem is that I need the search results to appear in a different URL but at the moment they just appear in a new DIV on the home page. My knowledge of JS is limited and can't get my head around what the OS script is doing. I think the relevant section of the search form is as follows:
<form method=post action=<?echo $_PHP_SELF;?>>
<input type="text" name="zipcode">
<? echo show_country_codes(); ?>
I'm trying to get each of the if statements below in a text text box with the result depending on the answer of the equation. However i can't figure out a way to allow the user to click a button to to show the result in a text box.
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML>
<HEAD>
<TITLE> New Document </TITLE>
[Code]....
ive need to format the date (variable "tomorrow") in this form to mysql
format yyyy-mm-dd can anyone please show me how to amend my script?
<script language="javascript">
function showDate(thisObj){
/* create a Date object using the system clock */
today=new Date();
td = today.getDate();
tm = today.getMonth();
ty = today.getFullYear();
tomorrow=new Date(ty,tm,td+1)
/* convert contents to string and place in control */
document.getElementById(thisObj).value=tomorrow;
}
</script>
<body onLoad="showDate('date');">
<input id="date" type="text" readonly="readonly" />
</body>
I have a listings page which displays results using images and text which are stored in a MySQL database, all is working fine. The images are pulled into the page from the database and each listing can have up to a maximum of 10 images. Some will have all 10, some probably one or two, so the page is coded such that if there's an image in the field, it displays a thumbnail, if there isn't then it shoves a " " in instead.
The results page has one main photo (image 1) and then a series of thumbnails (images 2-10) below it and I need to be able to set this up so that when someone clicks on image 2 it shows the full-size version of that image in the div where image1 sits, and the same for however many remaining images there are.
So my question is, how easy it is to do this with javascript and does anyone have any idea how to code it?
The main photo sits in a div whose id is "mainphoto" the remainder all sit in a div whose id is "thumbpix".
I have these two MySQL tables (location, properties). Each location can have one or more properties so both tables are related using Keys. What I'm trying to implement is an HTML form where when a user selects a location then the system automatically filters the properties results accordingly. The "location" list is loaded from MySQL using PHP, but obviously PHP doesn't allow me to filter the "properties" list while the selection is at the user side.
View 2 Replies View RelatedI've got a page that lists a bunch of info in a large table. In each row is a link, and when that link is clicked on, an ajax call fires that returns detailed info on the item in that row. I usually display the html just to the right of the table, but the table has gotten too large. I need to display the info in a pop up now. The only thing is, how do I get the results of my ajax call into a pop up window? I've been having an awful time getting this to work.
I'm using JQuery to make the ajax call, what can I put in my success of complete event to create the pop up using the data the ajax call returns?
I have been searching for a way to display facebook api friends.getAppUsers in set of 5. I am able to do this if i hard code it but I cant seem to find and comprehend a method to do this dynamically.
What i want to achieve is, if i have 43 friends using the application, the code should allow users to view this result in set of 5.
[Code]...
I am using an AJAX to get an HTML response and insert it into the DOM.This is how my request looks like:
function ajax_get_update() {
$.get(url, function(results) {
var table = $("table", results);
var span = $("span.step-links", results);
[code]....
So, this results in an empty table on the page, though it shouldn't be.
I 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 table that has parts with multiple characteristics. Part Number, Height, Width, Capacity, Price, Etc. I would like to have a drop downs for all of these values, when a user selects one of these values it will filter the results into a list. Ex. user selects a part that has a Height of 6 and width of 10 it will only list those parts. As I said earlier, I have a script that will give me all the parts, however I am not able to make the onchange list parts with multiple values.
View 9 Replies View RelatedWhen you click the text "info" in the column "comments", a row should be displayed below with text information that is related to the "comments". Need also to click the text "Info" again to hide the text information of comments. Problem: I don't know how to display the row when you click one of the comments with the text "info". When clicking one of the link the remaining rows with the text "info" should not be affected. In order words, the part should be independent Need also some help hiding the text information of comments.
There are some things that you also need to take account to: - The amount of data that will be displayed in the table will be changed from day to day. The data is taken from a xml file.- Would like the sourcode to be written in jQuery.- Only html, css and javascript is allowed in this context.- html code in tr and td will be generated by javscript code.The class "firstDataRow" is the added in the tr row that has the text information of commentsPlease remember that the text hide and show is only for temporary.
// Fullmetalboy
<table border="1" SUMMARY="aaa" id="tblProject">
<thead>
[code]....
Could any1 email me a comprehensive tutorial on populating a drop down box using either PHP and/or Javascript from a MySQL table?
View 3 Replies View RelatedI'm dynamically outputting the contents of a MySQL table using Python, to a HTML table, which users view (obviously) through a web browser. It looks great, but the problem is that I'd like users to be able to update these values. For example, I have the current value of certain fields in text boxes. I'd like users to be able to change those values, then hit a submit button or similar (ideally on-the-fly) to update the dB. I imagine javascript will need to pass values to a Python script, but I don't know what the best way to go about this is.
# Python code embedded in a .psp file
cursor = db.cursor()
cursor.execute("SELECT from_name, from_address, project, orb_proj, app, tier, environment,
[code]....
I am trying to use AJAX to pull back mysql table information. I tried to alter an example I found (w3 schools) where they showed how use a selection table to pull a specific line out of a mysql table, using the "q" (not really sure if the "q" character is important or not). xmlhttp.open("GET","xxxxxxx.php?q="+str,true) I follow what they were doing there, but I want to pull the entire table back not just specific lines. (So I got rid of the Q)
Here is a snipit of HTML. The showdata function is part of the testpull.js code. You click the button and it should run the javascript to pull back the entire table and place it in the "placedata" div section.
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html lang="en" xmlns="http://www.w3.org/1999/xhtml" xml:lang="en">
<head>
[Code]....
I have a <div> tag that contains a table of results returned using AJAX. I have an onmouseover on the div so that when the user is viewing the results the div stays visible. An onmouseout is also declared so that when the user goes off of the div, it will disappear after a few seconds. When the user clicks on an entry I perform some logic and close the div.
However the problem occurs when my AJAX returns too many results to display in the set size of my div. When this occurs my div becomes scrollable. When the user is interacting with the scrollable, it seems to fire the onmouseout event because the div disappears.
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.
I have a PHP script that searches a database and outputs the results in a table with several TD's. The user can select a radiobutton and press a button to edit that record. I need a JavaScript to do this :
Highlight the entire row when the mouse is over it (using in-line class). Un-highlight when the mouse exits it (in-line class again). Allow the user to select the radio button by clicking anywhere in the row Highlight the selected row (with another in-line class) My scripts endlessly have problems. Below is a small sample from the table...
A non-highlighted row is class "tcell"
a highlighted (mouseover) class is "rhtcell"
a radiobutton selected class is "selcell"
<table align="center" border="0" width="1000" class="stable">
<form method="post" action="index.php">
[Code]..
I would like to be able to generate a table from which I can easily edit the contents of a mySQL database (similar to phpMyAdmin.) In that table I would like to have a button that will open a pop-up, allowing me to edit - and maintain formatting such as apostrophes and line breaks - a long description field. That popup will then populate a hidden input field on its parent with the modified description.
I've got the pop-up opening and its fields are populated using php's GET function (see line 11). The special characters, particularly carriage returns, are messing me up; I can remove them using php's str_replace, but I want to retain them for formatting.
My program builds several tables using inner HTML. All the tables are displayed only when the program terminates. How can I make it display one table at a time and then wait for a click before displaying the next table?
View 9 Replies View RelatedWasn't sure if I should post this in the CSS or Javascript section so I just went with Javascript as it's what the code is in. Made a small Javascript game, when the player looses it will populate a table which is set to display: none; with the scores and then using the code below show the table...
document.getElementById('scoresTable').style.display = 'table'; This works fine for me in Opera, Google Chrome and Safari .. but not Firefox or IE.
How can the user obtain a specific result by choosing values from 2 dropdown list. As a result, the value obtained can not be modified by the user. The table of ten rows by ten columns have to be stored in a mysql dbase.. It's certanly possible , but tedious and time-consuming by using a bunch of "if ... then statements". Considered from a table point of view, the final result is the coordinate of a row value and a column value.
View 1 Replies View Related