In Percona’s white paper “Performance at Scale: Keeping Your Database on Its Toes,” we take a high-level approach to what you need to think about when planning for database scalability.
Solved
Inserting values in mysql database
Posted on 2012-12-21
Hello Experts,
I would like to insert the values from the PHP page into MYSQL database where the values were in the form of ...
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
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];
}
?>
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
[X]
Welcome to Experts Exchange
Add your voice to the tech community where 5M+ people just like you are talking about what matters.
- Help others & share knowledge
- Earn cash & points
- Learn & ask questions
3-
3
7 Comments
You mean something like..
Kent
<?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>";
}
?>
Kent
Active 1 day ago
<?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
}
?>
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
Hello Expert,
The markup is something like this...
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>";
Active 1 day ago
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...
Hello expert,
Yes, there is an checkbox each row...
Yes, there is an checkbox each row...
<td><input name=chk[] type=checkbox value=$i /><br/></td>
Active 1 day ago
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());
}
?>
Featured Post
Work with freelancers specializing in everything from database administration to programming, who have proven themselves as experts in their field. Hire the best, collaborate easily, pay securely, and get projects done right.
Question has a verified solution.
If you are experiencing a similar issue, please ask a related question
This post contains step-by-step instructions for setting up alerting in Percona Monitoring and Management (PMM) using Grafana.
- Software-Other
- Databases
- MySQL Server
- MongoDB
- NoSQL Databases
- Percona, *Monitoring tool
In this blog post, we’ll look at how ClickHouse performs in a general analytical workload using the star schema benchmark test.
The viewer will learn how to look for a specific file type in a local or remote server directory using PHP.
In this video, Percona Solution Engineer Dimitri Vanoverbeke discusses why you want to use at least three nodes in a database cluster.
To discuss how Percona Consulting can help with your design and architecture needs for your database and infras…
Suggested Courses
Course of the Month14 days, left to enroll
656 members asked questions and received personalized solutions in the past 7 days.
Join the community of 500,000 technology professionals and ask your questions.