Databases
StackOverflow2013
Postsdbo
POjquery to php code then to database
 

Note that there are some explanatory texts on larger screens.

plurals
  1. POjquery to php code then to database
    primarykey
    data
    text
    <p>I'm trying to pass information from jquery to a database. </p> <p>I have the function in jquery already submitting etc but unsure where to go now. </p> <p>The php I want to get to will be requesting the data but the bit im unsure with is passing my data to this page? PLease not the //NEED TO ADD SOMETHING HERE? bit. </p> <p>I know I Need to add something like a post but unsure how to do this using jquery.</p> <p>Below is the jquery code: </p> <pre><code>$( "#dialog-form" ).dialog({ autoOpen: false, height: 600, width: 1000, modal: true, buttons: { "Create Property": function() { var bValid = true; allFields.removeClass( "ui-state-error" ); bValid = bValid &amp;&amp; checkLength( name, "name", 3, 16 ); bValid = bValid &amp;&amp; checkLength( email, "address1", 6, 80 ); bValid = bValid &amp;&amp; checkLength( password, "address2", 5, 16 ); if ( bValid ) { ***//NEED TO ADD SOMETHING HERE?*** $( this ).dialog( "close" ); } }, Cancel: function() { $( this ).dialog( "close" ); } }, close: function() { allFields.val( "" ).removeClass( "ui-state-error" ); } }); </code></pre> <p>Below is the php page I want to pass the data to: </p> <pre><code>if(isset($_REQUEST['submit-property'])) { //Create a new object $property = new Property(""); //Collect the variables passed from REQUEST $name = $_REQUEST['name']; $address1 = $_REQUEST['address1']; $address2 = $_REQUEST['address2']; $address3 = $_REQUEST['address3']; $address4 = $_REQUEST['address4']; $postCode = $_REQUEST['postCode']; etc etc etc </code></pre> <p>Hope someone can help. </p> <p>Thanks alot. </p>
    singulars
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. PTQuestion
    1. USSergio
    1. USWayneP
    plurals
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. PO
      singulars
      1. PTAnswer
    1. This table or related slice is empty.
    1. COAH sorry. I should of said. It's just checking to see if the fields are valid. The names of the fields that I need to post to the php page are name, address1 and address2. Everything works apart from I don't know what the code would be to pass (post) this information to another page.
      singulars
      1. POjquery to php code then to database
      1. USWayneP
    2. COYou need first read up on how to post to a php page. You can find simple example at http://api.jquery.com/jQuery.post/ should be fairly simple to figure out.
      singulars
      1. POjquery to php code then to database
      1. USxlordt
    3. COYou might want to use an ajax request... though, you might also decide to instead use a postback. There's plenty of existing examples and tutorials to help you send your first ajax request. Try it yourself, then, when you have problems, ask here. At this point you don't have a problem for us to help you solve.
      singulars
      1. POjquery to php code then to database
      1. USKevin B
 

Querying!

 
Guidance
A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload