Solved

Inserting values in mysql database

Posted on 2012-12-21
7
464 Views
Last Modified: 2012-12-22
Hello Experts,

I would like to insert the values from the PHP page into MYSQL database where the values were in the form of ...

<?php 
 for ($i = 0; $i < count($_POST['chkbx']); $i++) {
            $chkd = $_POST['chkbx'][$i];
            $filename = $_POST['myfilename'][$i];
            $src = $_POST['mysource'][$i];
            $tgt = $_POST['mytarget'][$i];
            
}
?>

Open in new window


For example, there are 5 rows on php and user has selected any of the rows...that row data from php needs to inserted into mysql database that many rows.

Can you suggest the query for this or any references?

Thanks,
Shail
0
Comment
Question by:ShaileshShinde
  • 3
  • 3
7 Comments
 
LVL 17

Expert Comment

by:Kent Dyer
ID: 38715117
You mean something like..
<?php
   $conn = mysql_connect ("localhost","login","password");
   $db = mysql_select_db('database',$conn);

$LIBRARY_NO=$_POST['LIBRARY_NO'];
$TITLE=mysql_real_escape_string($_POST['TITLE']);
$LYRICIST=$_POST['LYRICIST'];
$VOICING=$_POST['VOICING'];
$NO_OF_COPIES=$_POST['NO_OF_COPIES'];

// Update the database if form posted 
if ($_POST['cmdadd'] != null)
{ 
$sql = "INSERT INTO Music(";
if ($LIBRARY_NO != null) {$sql=$sql."`LIBRARY_NO`";}
if ($TITLE != null) {$sql=$sql.", `TITLE`";}
if ($LYRICIST != null) {$sql=$sql.", `LYRICIST`";}
if ($VOICING != null) {$sql=$sql.", `VOICING`";}
if ($NO_OF_COPIES != null) {$sql=$sql.", `NO_OF_COPIES`";}
$sql=$sql.")"; 
//echo $sql;
$result = mysql_query($sql) or die("SQL Update failed"); 
  if ( ! $result )
    die ("Couldn't update: ".mysql_error());
  print "<h1>Table updated ". mysql_affected_rows() . 
  " row(s) changed</h1><p>";
}
?>

Open in new window

HTH,

Kent
0
 
LVL 31

Expert Comment

by:Marco Gasi
ID: 38715138
<?php 
 for ($i = 0; $i < count($_POST['chkbx']); $i++) {
            $chkd = $_POST['chkbx'][$i];
            $filename = mysql_real_escape_string($_POST['myfilename'][$i]);
            $src = mysql_real_escape_string($_POST['mysource'][$i]);
            $tgt = mysql_real_escape_string($_POST['mytarget'][$i]);
            $query = "INSERT INTO table (filename, src, tgt) VALUES ('$filename', '$src', '$tgt')";
            //execution code here 
}
?>

Open in new window


then execute the query with mysql, mysqli or PDO. Keep in mind that now the use of mysql is discouraged and it is recommended the use of mysqli or PDO

If you want, you can post the markup of the form so I can be a bit more precise.

Cheers
0
 
LVL 1

Author Comment

by:ShaileshShinde
ID: 38715149
Hello Expert,

The markup is something like this...

echo "<tr class=\"d" . ($i & 1) . "\">
                        <td><input class=textboxa type=text style=\"font-style: Italic;font-weight: bold;\" value=\"$i\" /><br/></td>
                        <td><input name=test_$i class=textboxc type=text style=\"font-style: Italic;font-weight: bold;\" value=\"" . $row['Delivery'] . "\" title=Delivery /><br/></td>
                        <td><input name=subtest_$i class=textboxc type=text style=\"font-style: Italic;font-weight: bold;\" value=\"" . $row['quality'] . "\" title=quality /><br/></td></tr>";

Open in new window

0
Efficient way to get backups off site to Azure

This user guide provides instructions on how to deploy and configure both a StoneFly Scale Out NAS Enterprise Cloud Drive virtual machine and Veeam Cloud Connect in the Microsoft Azure Cloud.

 
LVL 31

Expert Comment

by:Marco Gasi
ID: 38715182
I don't see checkboxes: how user selects rows? In your first snipet you used $_POST['chkbx'] so I presumed you had a checkbox per row in your form...
0
 
LVL 1

Author Comment

by:ShaileshShinde
ID: 38715200
Hello expert,

Yes, there is an checkbox each row...

<td><input name=chk[] type=checkbox value=$i /><br/></td>

Open in new window

0
 
LVL 31

Accepted Solution

by:
Marco Gasi earned 100 total points
ID: 38715221
Well, then you have to use 'chk' instead of 'chkbx':

<?php 
 for ($i = 0; $i < count($_POST['chk']); $i++) {
            $chkd = $_POST['chkbx'][$i];
            $filename = mysql_real_escape_string($_POST['myfilename'][$i]);
            $src = mysql_real_escape_string($_POST['mysource'][$i]);
            $tgt = mysql_real_escape_string($_POST['mytarget'][$i]);
            $query = "INSERT INTO table (filename, src, tgt) VALUES ('$filename', '$src', '$tgt')";
            mysql_query($query) or die(mysql_error()); 
}
?>

Open in new window

0
 
LVL 1

Author Closing Comment

by:ShaileshShinde
ID: 38715445
Thanks Experts!
0

Featured Post

Use Case: Protecting a Hybrid Cloud Infrastructure

Microsoft Azure is rapidly becoming the norm in dynamic IT environments. This document describes the challenges that organizations face when protecting data in a hybrid cloud IT environment and presents a use case to demonstrate how Acronis Backup protects all data.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
error log using ftp 7 40
Restore of mysql database from .SQL file - using Coldfusion 5 36
How can I make this form submit to itself? 10 27
PHP Syntax Error 4 27
Author Note: Since this E-E article was originally written, years ago, formal testing has come into common use in the world of PHP.  PHPUnit (http://en.wikipedia.org/wiki/PHPUnit) and similar technologies have enjoyed wide adoption, making it possib…
Foreword (July, 2015) Since I first wrote this article, years ago, a great many more people have begun using the internet.  They are coming online from every part of the globe, learning, reading, shopping and spending money at an ever-increasing ra…
The viewer will learn how to count occurrences of each item in an array.
The viewer will learn how to create and use a small PHP class to apply a watermark to an image. This video shows the viewer the setup for the PHP watermark as well as important coding language. Continue to Part 2 to learn the core code used in creat…

776 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question