Hello Experts,

I need help on modal form validation.

The following code inserts properly (only when all inputs are filled correctly).

I'm having trouble validating subject_taught and class_taught inputs.

More so, I want the form to clear all inputs (reset) after insert without error. The datatable should refresh afterwards.

The code:

<?php
include('../includes/connection.php');


if ( ! empty($_POST) ) {
	
    if ( empty( $_POST["initial"] ) || empty( $_POST["username"] ) || empty( $_POST["password"] ) || empty( $_POST["role"] ) || empty( $_POST["subject_taught"] ) || empty( $_POST["class_taught"] ) ) {

    	$response = '<div class="alert alert-danger">
		<span class="badge badge-danger">Empty Field(s) Detected!</span> All fields are required.</div>';

        die($response);
    }

    // Validation passed so let's deal with the DB stuff

	$initial = $_POST["initial"];
	$username = $_POST["username"];
	$password = $_POST["password"];
	$role = $_POST["role"];
	$class_assigned = $_POST["class_assigned"];
	

	$master_query = '';
	
	$stmt = $conn->prepare("SELECT Username FROM Users WHERE Username = ?");
        $stmt->bind_param("s", $username);
        $stmt->execute();
        $staffList = $stmt->get_result();

    if (mysqli_num_rows($staffList) > 0 ) {

    	$response = '<div class="alert alert-danger">
		The Username: <span class="badge badge-pink">'.$username.'</span> already exists. Try another one!</div>';

	die($response);
  

Select all Open in new window

…

All thanks to Chris Stanyon who has been helping in making sure I'm successful in my project.

Now, I have a bootstrap modal that inserts into mysql using explode. I like to use same type of modal form to update the data fetched from database.

When I click on the Edit button on the datatable, I want the Modal to open the record of the selected user for necessary update.

Please Note: I use Ajax to post to the database.

The sample of what I want is attached and the script for my insert is as follows:

Modal for Insert:

<!-- new staff modal-->
<div class="modal fade" role="dialog" id="addStaffModal">
  <div class="modal-dialog" role="document">
    <div class="modal-content">
      <div class="modal-header">
        <button type="button" class="close" data-dismiss="modal" aria-label="Close"><span aria-hidden="true">&times;</span></button>
        <h4 class="modal-title">Add New Staff</h4>
      </div>

      <form class="form-horizontal" method="post" id="newStaff-Form" action="data.php">
      <div class="modal-body">
      	
      	<div id="response" class="center"></div>
      	
        <div class="form-group">
    		<label class="control-label col-xs-12 col-sm-3 no-padding-right" for="initials">Initials<span style=color:red;> *</span>
    		</label>
    		<div class="col-xs-12 col-sm-9">
    			<div class="clearfix">
    				<input type="text" name="initials" 

Select all Open in new window

…

Hello all,

I'm a hobbyist, starting to dip my toe into Bootstrap 4, along with JQuery and Ajax.

I've got a PHP script, which works fine for tabs in Bootstrap 3 - and I'm now trying to convert it into Bootstrap 4 Collapse/Accordion - but cannot get it working - my ajax content currently appears outside all the accordion tabs, at the very bottom of the screen. I've spent some time researching this, but cannot see examples on what I'm trying to achieve.
 
For my Bootstrap 4 Accordion, when it initially appears, I want the first panel open and populated with my dynamic ajax content - with loading gif -  with each panels content being dynamically refreshed with ajax with each panel press.

<script>
$(document).ready(function() {


    $("#247button").click(function() {
 
        $("#ajax-content").empty().append("<div id='loading'><img src='/images/loading.gif' height='60' width='60' alt='Loading' /></div>");
        $("#nav li a").removeClass('current');
        $(this).addClass('current');
 
        $.ajax({ url: this.href, success: function(html) {
            $("#ajax-content").empty().append(html);
            }
    });
    return false;
    });
 
    $("#ajax-content").empty().append("<div id='loading'><img src='/images/loading.gif' height='60' width='60' alt='Loading' /></div>");
    $.ajax({ url: '/247getday2staffTIMES.php', success: function(html) {
            $("#ajax-content").empty().append(html);
    }
    });
});
</script>  


<div id="accordion">
 

Select all Open in new window

…

I am using a JS library to drag the controls on my PAGE to perform different functions. Checkout the demo by clicking on this link:

http://iamfashionphotographer.com/del/cb-m-1/final.html

Select all Open in new window

1) When the page loads, see the right side and click on the icon.
2) Then you will see a snippet there. Just drag it on the page.
3) After that a button will be visible on PAge. Click on it and fill the form fields and fill the data with integer values and click on save.
4) The values are stored in DB.

What I want:
1) When you click on Table or button, you will notice that some additional buttons/controls  will appear. Click on the last icon which is a delete icon. You will notice that control will be deleted from the page. But values are still saved in Database.

I want that if user click on delete icon then its data from the table must be deleted from the database.

Need code help that on which event I will set the ajax call to delete data against that control.

Note: If user drag a control on page then following event is called:

	$('.ui-droppable').on('sortstop', function(e,i) {
	});

Select all Open in new window

Looking for expert opinion

Thanks

Hi there.
I'm adapting a tutorial which uses ajax and php to pull information from my database, when  the user scrolls to the bottom of the page.

I noted however, that when I was reaching the bottom of the page, information wasn't always getting pulled from my database. I amended my code slightly to include my div tags within the php echo  (as per the original code) and the code now works (to an extent)  - it's pulling information as specified from the database.

So my working php code which displays the information on the page, and reloads is the following :

while($teacher = mysqli_fetch_array($data))
		{
			//here we are displaying the information from the database
			echo '
			<div class="container">
			<div class="col-sm-6 col-md-4 buffer">
			<div class="card" style="width: 100%;">
			
				<div class="card-header">
				<h1>'.$teacher['id'].'</h1>
				<img src="../public/img/flags/'.$teacher['nationality'].'flag.gif">
				<h2>'.$teacher['firstname'].'</h2>
				</div>
				
				<div class="card-body">
				<h1>'.$teacher['id'].'</h1>
				<h2>'.$teacher['firstname'].'</h2>
				</div>
			
			</div>
			</div>
			</div>
			';
		}

Select all Open in new window

However, I want to display more information within the while.. The following code represents the information I want to display within the while loop and how it should appear. This code displays everything correctly on it's own but the pulling of the data does not seem to work with it.  

<div class="row">
            

Select all Open in new window

…

I am working on web page on a php/mySQL server.

My quote/order web page has several cascadingdropdowns which are not working.   Not sure why, but the code
I wrote using a widgit way back.   This was before jQuary was around.  It was leading edge back  then but now its not so great.

Can you point me to a good example that I can

I've got a dropdown box which is populated with ajax according to what option i choose from another dropdown. I need to duplicate the dropdown box keeping the same options loaded via ajax, this is what i've done o far. Many thanks for your help

This is the code to get tha value from the first dropbox and then use it for ajax

$('#flatGroup').on('change',function(){
        var countryID = $(this).val();
        console.log(countryID);
        if(countryID){
            $.ajax({
                type:'POST',
                url:'../controllers/ctrl_admin_group_table_app/ctrl_admin_get_building_table.php',
                data: {

                  group_id: countryID

                },

                success:function(html){
                    $('#flatTable-1').html(html);
                    $(".bs-select").selectpicker('refresh');

                }
            }); 
        }

    });

Select all Open in new window

This is the code i'm using to close the second dropbox that receive the option from ajax

// start repeating form tabelle
        //Start repeating form group add limit
        var maxGroup1 = 5;
        //add more fields group
        var fieldGroup1= $(".fieldGroup1").clone();

        $(".addMore1").click(function() {

          var fgc1 = $('body').find('.fieldGroup1').length;

          if (fgc1 < maxGroup1) {

            var fieldHTML1 = '<div class="form-group fieldGroup1">' + fieldGroup1.html() + '<div class="col-md-1"><label 

Select all Open in new window

…

I'm trying to include a live test for unique email and name.    The concept is to initially disable the submit button, and then re-initialize it if the credentials check-out to be unique. At this point clicking the submit button would initial the signup.php routines. Otherwise, the user would receive an error message to try again.

I have include the code "name_check' : 1," and "email_check' : 1," as ajax({ data arguments; because I've seen them in other code found online. But I don't understand what they mean: Is username_check a standard ajax function? I couldn't find any reference in the documentation.  Does this code assign the value 1 to username_check?

$('document').ready(function(){

    let name_state = false;
    let email_state = false;

    $("input[type=submit]").attr('disabled','disabled');


    // Verify user name is unique in database
    //
    $('#name').on('blur', function(){
        let name = $('#name').val();
        if (name == '') {
            name_state = false;
            return;
        }
        $.ajax({
            url: 'check_credentials.php',
            type: 'post',
            data: {
                'username_check' : 1,
                'name' : name,
            });
            .done function(response){
                if (response == 'taken' ) {
                    name_state = false;
                } else if (response == 'not_taken') {
                    name_state = true;
                }
            }
        });
    

Select all Open in new window

…

I have a AJAX search form which takes input from user. Pressing Submit will send the request to php file which run 3 different queries and save results in 3 different variable
Now on my search result page, I want to show results in 3 different section.  

The searchresult1 variable result should display in 1st section (see attached diagram), searchresult2 variable result should display in 2nd section and so on.


see the layout of Search Results page here:

https://ibb.co/kH0Z3J

Select all Open in new window

Code For Ajax Call

 function Search() {
        var input =jQuery("#input").val();
	var path_base = <?=base_path();?>
		
         jQuery.ajax({

        type: "POST",
        url: "myfile.php",
        data: {input:input,path_base:path_base},
        // dataType: "JSON",
        success: AjaxSucceeded,
        error: AjaxFailed
    });

Select all Open in new window

myfile.php code

// Execute the query1
$q = '"' . $cl->EscapeString($_REQUEST['input']) . '"/1';
$searchresults = $cl->Query($q, 'search1' ); //second parameter is index name


// Execute the query2
$q2 = '"' . $cl2->EscapeString($_REQUEST['input']) . '"/1';
$searchresults2 = $cl2->Query($q2, 'search2' );

Select all Open in new window

What is the best way to implement that. Can I combine all the 3 search results  and then seperate them in AjaxSucccess method. In that case how to setup the html? Need coding help.


Thanks

Still struggling with php/mySQL/ajax registration script. Now getting CORS error "Cross-Origin Request Blocked"  This may be FF issue because I'm not getting the error on Chrome.  I'm not clear why this error when everything is within pricelearman.com. Also, I tried to suppress the error by pasting in the .htaccess file recommended by H5BP.  In the end, my script is able to connect with the database, but no data is uploaded
signup.php
signup.js
signup_process.php
db_config.php

Here is the dump of array which I have recieved from Ajax Request. Now I want to grab the value of 'title' and 'bundle' and send it as a json_encode
back to my php file so that I will access it in AjaxSuccess method.

I have print array with this:

print_r($searchresults['matches']);

Select all Open in new window

Array Dump

  [93] => Array
        (
            [weight] => 4558
            [attrs] => Array
                (
                    [title] => Arabic Page test
                    [status] => 1
                    [created] => 1522315423
                    [entity_id] => 93
                    [bundle] => mainpage
                )

        )

    [105] => Array
        (
            [weight] => 4558
            [attrs] => Array
                (
                    [title] => News Page 2
                    [status] => 1
                    [created] => 1522415885
                    [entity_id] => 105
                    [bundle] => news
                )

        )

    [106] => Array
        (
            [weight] => 4558
            [attrs] => Array
                (
                    [title] => TESTTT
                    [status] => 1
                    [created] => 1522416460
                    [entity_id] => 106
                    [bundle] => mainpage
                )

        )

    [107] => Array
        (
            [weight] => 4558
            [attrs] => Array
                (
                    [title] => NEws Page 1
                    

Select all Open in new window

…

Please refer to jsFiddle at "https://jsfiddle.net/midnightCabbie/mpm4uqtw/1/"  The issue is when clicked the submit button tries to send the data, but never succeeds. I'm not sure if the button is configured correctly, or if there is an issue with the php script.  

Here is the db_config.php  file:

<?php

//PDO
$db_host="localhost";
$db_user="pricelea_root";
$db_pass="pd5765166";
$db_name="pricelea_client_register";

try{
    $db_con = new PDO("mysql:host=$db_host;dbname=$db_name",$db_user,$db_pass);
     // set the PDO error mode to exception
    $db_con->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
    echo "Connected successfully";
    }
catch(PDOException $e)
    {
    echo "Connection failed: " . $e->getMessage();
    }

?>

Select all Open in new window

Thanks in advance

This is a multipart form, so I am using FormData.

<form id="PriceForm" name="PriceForm" method="post" enctype="multipart/form-data" accept-charset="UTF-8">

Select all Open in new window

I am using this same code in 2 other modules, and it is working fine. It appears it is not even reaching the PHP file, and I have run out of ideas to troubleshoot.
In the code below, I am pressing the "Save" button, which is recognized, and I have verified that it is sending correctly populated variables to DataSave.
Validation comes back positive (also verified)

What I have done to troubleshoot
1. Verified, line by line, that the code sequence is identical to what is working elsewhere.
2. Placed error information in the PHP file ($Error[] = "Testing";)
3. Finally, created a simple test file (shown at bottom) to return a result. There was no change, so it does not seem to be in the PHP file.

The button listener (I am selecting the "Save" button)

$(document).ready(function()
{
   $(document).on('click', '.SubmitButton', function(e)
   {
      e.preventDefault();
      var ButtonID = $(this).attr('id');
      var Form = $('#PriceForm');
      var Validate = false;
      if(ButtonID == "Reset")
      {
         if(confirm("Did you mean to clear the form?") == true)
         {
            ClearURI();
            window.location="pricing.php";
         }
      }
      else if(ButtonID == "Save")
      {
         var Data = new FormData(Form[0]);
         Data.append( 'Sec', 

Select all Open in new window

…