Inserting multiple record in MYSQL one at a time sequentially using AJAX

Hi All,
This is my first post in this forum. I'm developing a CMS for my latest website. This CMS is also in PhP & MySQL. I'm done with the ADD section where the Admin can INSERT new records in Database but I'm stuck in the EDIT. I'm getting 2 problems over here. Below is the description:

1)The FIRST page will list all the records from the table which Admin can EDIT with CHECKBOX for each record to select. He can select one or more than one record to EDIT.
2)Now if he selects ONLY ONE record, then in the SECOND page where he will enter NEW values for record and submit the form then the JavaScript which I had written there in is not working. It is not getting the FORM values in variables.
3)But if he selects more than one then the script is working fine and giving me correct values for all the records.
4)Suppose he selects 2 records and enters new values for them and hit the submit button then both the record should get processed sequentially, means, first Record A should get into processing and for this a message should get displayed as "Processing" and when it gets done then the message should appear as "Processed" and then starts the cycle for the next record in line. In between if any error occurs for any record the Erros message should get displayed but processing should carry on for subsequent records, if present.

As far as I've understood my requirement I know I have to use AJAX for this and below is my attempt to this but here also I'm confused about the strange behaviour. Whats happening here is, though the Ajax function is called once for each record but in the function the statements inside
"if(xmlObj.readyState == 4 && xmlObj.status == 200)" is executing twice for each record. Below is my code. Can anyone point me out what mistake am I doing.

Expand|Select|Wrap|Line Numbers

 
/*edit_process.php starts here*/

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">

<HTML>

<script type="text/javascript">

function ajaxFunction()

{

    var xml;

    try

    {  

        xml=new XMLHttpRequest();  // Firefox, Opera 8.0+, Safari

    }

    catch (e)

    {  

        try

        {

            xml=new ActiveXObject("Msxml2.XMLHTTP");  // Internet Explorer 6.0+

        }

        catch (e)

        {

            try

            {

                xml=new ActiveXObject("Microsoft.XMLHTTP");  // Internet Explorer 5.5+

            }

            catch (e)

            {

                alert("Your browser does not support AJAX!");

                return false;

            }

        }

    }

     return xml;  // Mandatory Statement returning the ajax object created

} //ajaxFunction closes
 
function postValues(params, div, xmlObj)

{

    var url="edit_trailer.php";

    var flag;    

    //alert(params);    
 
    xmlObj.open("POST", url, true);        

    xmlObj.setRequestHeader("Content-type", "application/x-www-form-urlencoded");

    xmlObj.setRequestHeader("Content-length", params.length);

    //xmlObj.setRequestHeader("Connection", "close");    
 
    xmlObj.onreadystatechange = function()

    {    

        alert("Ready state is: " + xmlObj.readyState);

        if(xmlObj.readyState != 4)

        {

            alert('processing for ' + div);

            document.getElementById(div).innerHTML = '<img src="http://bytes.com/images/loader.gif">';    

        }
 
        if(xmlObj.readyState == 4 && xmlObj.status == 200)

        { //All below statements are executing twice for each record

            alert('processed for ' + div);

            document.getElementById(div).innerHTML = '<img src="http://bytes.com/images/loader2.gif">';

            alert(xmlObj.responseText);

            flag=true;

            alert('returning from callback ' + flag);

            return;

        }

    }

    xmlObj.send(params);

    alert('returning after send ' + flag);

    return flag;

} //postValues closes
 
function submit_data()

{    

    document.getElementById('update').disabled = true;
 
    var xmlHttp;

    xmlHttp=ajaxFunction();

    if (xmlHttp==null)

    {

        alert ("Browser does not support HTTP Request");

        return;

    }

    //alert("Ajax created");    
 
    var name, id, synop, thumb, url, recID;

    name = document.edit.elements["name[]"];
 
    if (name.length==undefined) //this part is not working when there is one record

    {

        alert('only one element');

        name = document.edit.name;

        id = document.edit.id;

        synop = document.edit.synop;

        thumb = document.edit.thumb;

        url = document.edit.url;

        recID = document.edit.recID;
 
        alert('Name ' + name.value);

        alert('Id ' + id.value);

        alert('Syn ' + synop.value);

        alert('thumb ' + thumb.value);

        alert('url ' + url.value);        

    }

    else  //this part is working when there are more then one record

    {

        id = document.edit.elements["id[]"];

        synop = document.edit.elements["synop[]"];

        thumb = document.edit.elements["thumb[]"];

        url = document.edit.elements["url[]"];

        recID = document.edit.elements["recID[]"];        
 
        flag=true;//set flag to true to call function for the first record

        for(i=0;i<name.length;i++)

        {

            var param="name="+name[i].value+"&id="+id[i].value+"&syn="+synop[i].value;

            param+="&thumb="+thumb[i].value+"&url="+url[i].value+"&recId="+recID[i].value;    
 
            var div='div'+(i+1);            
 
            if(flag)

            {

                alert(flag + ' bfore calling');

                flag=false;//set flag to false and get its value from the function

                flag=postValues(param, div, xmlHttp);//call function    

                alert(flag + ' after calling');

            }
 
        } //for loop closes
 
    }// else closes
 
    return false;

}

</script>

</HEAD>
 
<BODY>

<?php    

require("db_connect.php");

require("db_open.php");

if (!$conn)

{

    exit("Error connecting to the database: " . $conn);

}
 
//This value is coming from FIRST page where admin select record for editing

$record = $_POST['record']; 

$query = "select mov_name, mov_id, mov_synop, mov_thumb, page_name ";

$query.= "FROM bhod_test_trailers WHERE mov_nos=";

?>

<FORM method="post" id="edit" onSubmit="return submit_data()" NAME="edit" enctype="multipart/form-data">

<TABLE border="0" cellspacing="0" cellpadding="0" align="center" width="500">

<?php

    $divid=1;

    foreach ($record as $rec)

    {

        $sql = $query . $rec;

        $result = mysql_query($sql);

        if (!$result)

        {

            echo 'Could not run query: ' . mysql_error();

            exit;

        }

        $row = mysql_fetch_row($result);

?>

    <TR>

        <TD width="96" align="left" valign="top">

            <img src="trailers/<?php echo $row[3]; ?>.jpg" border="0" width="92" height="85">

        </TD>

        <TD width="254" align="left">            

<TABLE border="0" cellspacing="0" cellpadding="0" width="254">

<input type="hidden" name="recID[]" value="<?php echo $row[1]; ?>" />

    <TR>

        <TD align="left" valign="top">

    <label for="mov_name">Movie Name:</label>

    <input type="text" name="name[]" value="<?php echo $row[0]; ?>" />

        </TD>

    </TR>
 
    <TR>

        <TD align="left" valign="top">

            <label for="mov_synop">Synopsis:</label>

            <textarea name="synop[]" cols="20" rows="3"><?php echo $row[2]; ?></textarea>

        </TD>

    </TR>
 
    <TR>

        <TD align="left" valign="top">

            <label for="mov_id">Clip ID:</label>

            <input type="text" name="id[]" value="<?php echo $row[1]; ?>" />

        </TD>

    </TR>
 
    <TR>

        <TD align="left" valign="top">

        <label for="page_name">URL:</label>

        <input type="text" name="url[]" value="<?php echo $row[4]; ?>" />

        </TD>

    </TR>
 
    <TR>

        <TD align="left" valign="top">

            <label for="mov_thumb">Thumbnail:</label>

            <input type="file" name="thumb[]" />

        </TD>

    </TR>

</TABLE>

        </TD>

        <TD width="150" align="left" valign="top">

            <div id="div<?php echo $divid; ?>"></div> //this div will hold our process status

        </TD>

    </TR>
 
    <TR>

        <TD colspan="3"><BR></TD>

    </TR>
 
<?php    

        $sql = '';

        $divid++;

    }//for loop closes

?>

    <TR>

        <TD colspan="3">            

            <input type="submit" id="update" value="Update" />

        </TD>

    </TR>

</TABLE>

</FORM>

</BODY>

</HTML>

/*edit_process.php ends here*/

Jan 3 '09 #1

Subscribe Post Reply

4565

acoder

16,027

Expert Mod 8TB

It's executed twice because you're calling the Ajax function twice.

Jan 6 '09 #2

by: Ryan Hubbard | last post by:

I'm inserting a record into MySQL 4.0 using Visual Basic ADO. When using the AddNew and Update method I am unable to retrieve the value of a Auto incrment field (Yes I know I can MoveLast but this...

MySQL Database

Inserting into two tables with one sql statement

by: Greg Ofiesh | last post by:

Anyone who can help, I have two tables T1 and T2. T1 has fields K1 and F2 and T2 has fields K2 and F1. F1 is the foreign key relating to K1 and F2 is the foreign key relating to K2. My...

Microsoft SQL Server

Multiple statements in single query batch

by: DG | last post by:

Hi, Can anyone advise how to execute multiple statements in a single query batch. For example- update customers set customer_name = 'Smith' where customer_name = 'Smyth'; select * from...

MySQL Database

Inserting unicode characters into a database using RecordSet.Update

by: Roger Withnell | last post by:

I'm using ASP, VBScript and SQL Server. I'm also using UTF-8 character set and so my codepage is 65001 and SQL Server datatype nvarchar. I can insert unicode characters correctly into the...

ASP / Active Server Pages

Inserting records to MYSQL using ODBC

by: csgraham74 | last post by:

Hello, im using MS Access as a front end to link to MYSQL. although this is possibly an Access issue i thought someone would be able to help me. the error message "ODBC--insert on a linked table...

MySQL Database

Can inner join replace multiple loop selects?

by: MP | last post by:

Hi trying to begin to learn database using vb6, ado/adox, mdb format, sql (not using access...just mdb format via ado) i need to group the values of multiple fields - get their possible...

Microsoft Access / VBA

Duplicate records while inserting the data

by: ebindia0041 | last post by:

This is like the bug from hell. It is kind of hard to explain, so please bear with me. Background Info: SQL Server 7.0, Asp.net 1.1 with c# I'm inserting simple records into a table. But one...

.NET Framework

Multiple threads reading from the same file... is it possible?

by: WATYF | last post by:

Hi there... I have a huge text file that needs to be processed. At the moment, I'm loading it into memory in small chunks (x amount of lines) and processing it that way. I'd like the process to be...

Visual Basic .NET

foreach loop not inserting in MySQL

by: djmeltdown | last post by:

I'm having trouble getting a foreach() loop to insert a record into a MySQL Database. Which I've never had any trouble before, it just seems quirky. I've tried the mysql_query statement without a...

PHP

Easy Steps to Fix "Canon Printer Won't Connect to WiFi Network"

by: taylorcarr | last post by:

A Canon printer is a smart device known for being advanced, efficient, and reliable. It is designed for home, office, and hybrid workspace use and can also be used for a variety of purposes. However,...

General

How to turn on java script in a villaon keypad mobile phone

by: Charles Arthur | last post by:

How do i turn on java script on a villaon, callus and itel keypad mobile phone

Java

Basic Javascript concepts

by: aa123db | last post by:

Variable and constants Use var or let for variables and const fror constants. Var foo ='bar'; Let foo ='bar';const baz ='bar'; Functions function $name$ ($parameters$) { } ...

Javascript

Navigating the Data Structures and Algorithms (DSA)

by: BarryA | last post by:

What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...

Algorithms / Advanced Math

Looking to do Android software development, any suggestions? Is flutter better?

by: nemocccc | last post by:

hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?

General

Is that possible of reading the .csv file in column wise and the column have different lengths ?

by: Sonnysonu | last post by:

This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...

C / C++

How to build RAID in BIOS?

by: Hystou | last post by:

There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...

Computer Hardware

What is ONU?

by: marktang | last post by:

ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...

General

Problem With Comparison Operator <=> in G++

by: Oralloy | last post by:

Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers,...

C / C++

Inserting multiple record in MYSQL one at a time sequentially using AJAX

Similar topics