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> <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);
}
}
?>
120 
27 
Other php-forum
button help
i originally had this but realised it is much easier to have a button.
Code: <?php
How do I give a developer access to a specific directory and nothing else?
I want to give a develop access to a specific directory and nothing else
I can give them an F
storing results of a function - previous result overwritten with new result
I have created a function to validate input.
function validate_dimension($value,$name) {
<
'grab_files', multiple extension?
hey guys,
can anyone suggest a way to make to following line of code look for files with more
Custom CMS
This is a big custom CMS script I'd like to develop and would like some help atleast figuring out wh
There was a problem with the request. (Code: 0)
Any Idea what could cause this? I get it randomly at best. But with both IE and FF. It derives from
simple ping code
been searchin the site/web and found code thats simple but doesnt work.
I have a personal we
adding up might be solved tell us cheers.
i think i finally solved this anybody.
last time i was getting the wrong results.
Code
Drawing Images in classes
I'm quite new to Object Oriented PHP. What I'm trying to do is draw some images but also have other
PHP FTP Can't upload Big FIles
Anyone had any success using FTP to upload a file say 90m?
im using ftp_put and it returns fa
