Search jQuery

jQuery Forum

Javascript/JQuery/AJAX to PHP & MySql LOTS for data fields individually named....

in Getting Started • 4 years ago

I need advice for a new project I've completed in a couple old technologies, I want to do with HTML front end to MySql with PHP and Javascript? My problem is the main screen looks like a spreadsheet with 19 rows and various # columns in 4 main forms. I've designed it for PHP and individually named textboxes. Recommnedations for retrieving 57-95 data elements to return to form w/o reloading whole form? Thanks! MtnGolfer?

Replies(6)

jakecigar

Re: Javascript/JQuery/AJAX to PHP & MySql LOTS for data fields individually named....

4 years ago

Use ajax. But use names like "C[0][0]" and get them all as an 2 dimensional array.

Your responses should be JSON formatted.

JΛ̊KE

jakecigar

Re: Re: Javascript/JQuery/AJAX to PHP & MySql LOTS for data fields individually named....

4 years ago

Or a bunch of 1 dimensional arrays.

JΛ̊KE

watusiware

Re: Javascript/JQuery/AJAX to PHP & MySql LOTS for data fields individually named....

4 years ago

At 100 data elements, it may not be an issue, but if it were a very large number, performance might actually be better if your PHP renders the HTML. And then you avoid a lot of fragile repetitive Javascript code.

It might send more data over the wire, but then it takes much less time to update the document.

Where you will definitely have performance problems is if you need to construct a lot of HTML using Javascript.

I do a lot of Ajax where the client gets JSON, but the JSON contains HTML fragments. So, say if there are 3 tables to update, you'd have the server send a JSON response with 3 HTML fragments, and then the JS just replaces the content of the 3 tables with the new data.

Tom Matth..

Re: Re: Javascript/JQuery/AJAX to PHP & MySql LOTS for data fields individually named....

4 years ago

I have a single table (pretty much) for each form, but am struggling with returning an array to be broken out to 19 rows x 3 columns to display into the original form where each textbox is individually named. I was plannng on doing one PHP update and hoping to return all data elements, just can't figure out right way to display or change the textbox naming scheme... gmFav, gmPk, gmPts... (for example) by 19 rows....

jakecigar

Re: Javascript/JQuery/AJAX to PHP & MySql LOTS for data fields individually named....

4 years ago

Something like this. You can add 19 rows. I added 3.

<!DOCTYPE html>
<html>
<head>
<meta charset="UTF-8" />
<title>form</title>
<meta http-equiv="X-UA-Compatible" content="IE=edge" />
<script src="https://code.jquery.com/jquery-3.3.1.min.js"></script>
<script>
$(function(){
$("form").submit(function(e){
e.preventDefault()
$("#data").load(this.action,$(this).serialize())
})
})
</script>
</head>
<body>
<form action="form.php">
<table>
<thead>
<tr>
<th>one</th>
<th>two</th>
<th>three</th>
</tr>
</thead>
<tbody>
<tr>
<td><input required name="one[]"></td>
<td><input required name="two[]"></td>
<td><input required name="three[]"></td>
</tr>
<tr>
<td><input required name="one[]"></td>
<td><input required name="two[]"></td>
<td><input required name="three[]"></td>
</tr>
<tr>
<td><input required name="one[]"></td>
<td><input required name="two[]"></td>
<td><input required name="three[]"></td>
</tr>
</tbody>
</table>
<button>submit</button>
</form>
<div id=data>
</div>
</body>
</html>

JΛ̊KE

jakecigar

Re: Re: Javascript/JQuery/AJAX to PHP & MySql LOTS for data fields individually named....

4 years ago

http://home.jejaju.com/play/form/ uses an example PHP…

<?php
echo implode(',',$_GET['one']);
echo "; ";
echo implode(',',$_GET['two']);
echo "; ";
echo implode(',',$_GET['three']);
echo "; ";
?>

JΛ̊KE

Top Reply

Response title

Attachments

jQuery Forum

Javascript/JQuery/AJAX to PHP & MySql LOTS for data fields individually named....

Replies(6)

Re: Javascript/JQuery/AJAX to PHP & MySql LOTS for data fields individually named....

Re: Re: Javascript/JQuery/AJAX to PHP & MySql LOTS for data fields individually named....

Re: Javascript/JQuery/AJAX to PHP & MySql LOTS for data fields individually named....

Re: Re: Javascript/JQuery/AJAX to PHP & MySql LOTS for data fields individually named....

Re: Javascript/JQuery/AJAX to PHP & MySql LOTS for data fields individually named....

Re: Re: Javascript/JQuery/AJAX to PHP & MySql LOTS for data fields individually named....

Statistics

Tags

Actions