Making multiple rows with one query

Posted on 16th Feb 2014 07:03 pm by admin

I have a table called efed_handler_characters with two fields handler_id and bio_id. What query 2 is supposed to do is get the id from the handler and then with each char(acter) is supposed to make a new record for each of them with that same handler id. I"m trying to figure out how this is done?
Code: <?php
case 1:
echo $e;
require_once('../backstageconfig.php');
require_once('../backstagefunctions.php');
?>
<h1 class="backstage">Handler Management</h1><br />
<h2 class="backstage">Add New Handler Account</h2><br />
<form name="addnewhandler" method="post">
<input type="hidden" name="action" value="handler" />
<table width="100%" class="table2">
<tr>
<td width="120" class="rowheading">Username:</td><td class="row3"><input type="text" name="login" class="fieldtext490"></td>
</tr>
<tr>
<td class="rowheading">Password:</td><td class="row3"><input type="password" name="password" class="fieldtext490"></td>
</tr>
<tr>
<td class="rowheading">Surname:</td><td class="row3">
<input type="text" name="surname" class="fieldtext490"></td>
</tr>
<tr>
<td class="rowheading">Firstname:</td>
<td class="row3"><input type="text" name="firstname" class="fieldtext490"></td>
</tr>
<tr>
<td class="rowheading">Email:</td>
<td class="row3"><input type="text" name="email" class="fieldtext490"></td>
</tr>
<tr>
<td class="rowheading">AIM:</td>
<td class="row3"><input type="text" name="aim" class="fieldtext490"></td>
</tr>
<tr>
<td class="rowheading">MSN:</td>
<td class="row3"><input type="text" name="msn" class="fieldtext490"></td>
</tr>
<tr>
<td class="rowheading">Forum ID:</td>
<td class="row3"><input type="text" name="forumid" class="fieldtext490"></td>
</tr>
<tr>
<td class="rowheading">Account:</td><td class="row3">
<select name="enabled" class="selection">
<option value="0">- Select -</option>
<?php
$query = 'SELECT name,id FROM efed_list_status';
$result = mysql_query ( $query );
while ( $row = mysql_fetch_assoc ( $result ) )
{
print "<option value="".$row['id']."">".$row['name']."</option>r";
}
?>
</select></td>
</tr>
<tr>
<td class="rowheading">Administrator:</td><td class="row3">
<select name="isadmin" class="selection">
<option value="0">- Select -</option>
<option value="2">No</option><option value="1">Yes</option>
</select></td>
</tr>
</table><br />
<input type="hidden" name="newadded" value="true">
<input type="submit" value="Save Handler" class="button" name="submit"></form><br />
<input type="submit" value="Return to Handler List" class="button200"><br /><br />
<h2 class="backstage">Characters<br /><br /><form method="post"><select name="characterid" id="characterid" class="dropdown">
<option value="0">- Select -</option>
<?php
$query = 'SELECT charactername FROM efed_bio';
$result = mysql_query ( $query );
while ( $row = mysql_fetch_assoc ( $result ) )
{
print "<option value="".$row['charactername']."">".$row['charactername']."</option>r";
}
?>
</select>&nbsp;&nbsp;<input type="hidden" id="chars" name="chars" value=""><input type="button" value="Add" class="button" onclick="WrestlerList()"></form></h2><br />
<ul id="characterlist"></ul><br />
<script type="text/javascript" language="javascript">
function WrestlerList()
{
var addWrestler = document.addwrestler.characterid.value;
if (addWrestler) {
document.getElementById("chars").value += addWrestler+",";
document.getElementById("characterlist").innerHTML += "<li>" +
addWrestler + "</li>";
return WrestlerList;
}
else {
document.getElementById("characterlist").innerHTML += "<li>This handler does not have any characters assigned.</li>";
}
}
</script>
</form>
<?php
returnmain();
break;
}
function handler() {
if ((!empty($_POST['newadded']))) {
$password = md5($password);
$login = mysql_real_escape_string($_POST['login']);
$p = mysql_real_escape_string($_POST['password']);
$surname = mysql_real_escape_string($_POST['surname']);
$firstname = mysql_real_escape_string($_POST['firstname']);
$email = mysql_real_escape_string($_POST['email']);
$aim = mysql_real_escape_string($_POST['aim']);
$msn = mysql_real_escape_string($_POST['msn']);
$forumid = mysql_real_escape_string($_POST['forumid']);
$isadmin = mysql_real_escape_string($_POST['isadmin']);
$enabled = mysql_real_escape_string($_POST['enabled']);
$char_array = explode(",", $_POST['chars']);
$query1 = "INSERT INTO `efed_handler` (surname,firstname,isadmin,login,password,enabled,aim,msn,forumid,email,fed_id,) VALUES ('".$surname."','".$firstname."','".$isadmin."','".$login."','".$password."','".$enabled."','".$aim."','".$msn."','".$forumid."','".$email."',1)";
mysql_query($query);
$query1_id = mysql_insert_id();
$query2 = "INSERT INTO `efed_handler_characters` (handler_id, bio_id) VALUES (".$query1_id.", $char_array)";
mysql_query($query2);

}
}
?>

Your Answer:

Login to answer

Other forums

Google voice
I currently have a form in html, but I want it in php so the information is not in the source code.<

EXplanation help
Hey all,

I am still fairly new to PHP programming and I am trying to put together a page wher

Thread in PHP
Thread in PHP
Some basic use and basic code for thread in php
This is my question?

RTF fomatting to email content
Im trying to sen an email with content is picked up from a rtf-file (file_get_contents('*.rtf'). Mai

Filtering an Array Based on Value
I have a very simple script set up that pulls data from a database and is output using this code:

returning data from an ssh2_exec()
here's what i got.


$conn = ssh2_connect($this->_host);
ssh2_auth_password($c

Transferring session variables into MySQL
I am trying to transfer $_SESSION variables into MySQL. However there is an error in my MySQL statem

read integers that returns a negative or prints the average
Im trying to finish this homework assignment by tommarow afternoon and I keep getting stuck.
Wr

Why does this file not return file names that start with numbers?
This file returns a list of filenames to help populate a drop down in my form. For some reason it ig

Multiple submit forms inside a mysql array page
Hi all,

Im having trouble to get the beneath script to work the thing i can't seem to get wor