Jump to content

Making multiple rows with one query


Xtremer360

Recommended Posts

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?

<?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);  

	}
}
?>

Link to comment
https://forums.phpfreaks.com/topic/185455-making-multiple-rows-with-one-query/
Share on other sites

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.