Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- <?php
- $mysql_db_hostname = "localhost";
- $mysql_db_user = "root";
- $mysql_db_password = "password";
- $mysql_db_database = "dynamic";
- $dbc = mysql_connect($mysql_db_hostname, $mysql_db_user,
- $mysql_db_password) or die("Could not connect database");
- mysql_select_db($mysql_db_database, $dbc) or die("Could not select database");
- ?>
- <?
- if (isset($_POST['add_account'])) {
- if ($_POST['fields']) {
- foreach( $_POST['fields'] as $key=>$fieldArray ) {
- $keys = array_keys($fieldArray);
- $values = array_map("mysql_real_escape_string",$fieldArray);
- $q = "INSERT INTO accounts (".implode(',',$keys).") VALUES ('".implode('','',$values)."')";
- $r = mysql_query($q, $dbc );
- }
- }
- echo "<i><h2><strong>" . count($_POST['fields']) . "</strong> Account(s) Added</h2></i>";
- }
- ?>
- <?php if (!isset($_POST['add_account'])) { ?>
- <form method="post" action="" enctype="multipart/form-data">
- <p id="add_field"><a class="btn btn-default" href="#">Add Rows</a></p>
- <table id="myTable">
- <thead>
- <tr>
- <th>#</th>
- <th>First Name:</th>
- <th>Last Name:</th>
- <th>E-mail:</th>
- <th>Upload file</th>
- <th></th>
- </tr>
- </thead>
- <tbody id="container">
- </tbody>
- </table>
- <input class="btn btn-default" type="submit" name="add_account" value="Submit" />
- </form>
- <?php } ?>
- <script src="https://ajax.googleapis.com/ajax/libs/jquery/1.11.3/jquery.min.js"></script>
- <script type="text/javascript">
- $(function(){
- var counter = 0;
- $('p#add_field').click(function(){
- counter += 1;
- $('#container').append(
- '<tr><td>' + counter + '</td><td><input id="field_' + counter + '" name="fields['+counter+'][first]" type="text" placeholder="First Name" required/></td><td><input id="field_' + counter + '" name="fields['+counter+'][last]" type="text" placeholder="Last Name" required/></td><td><input id="field_' + counter + '" name="fields['+counter+'][email]" type="email" placeholder="email" required/></td><td><input id="field_' + counter + '" name="fields['+counter+'][file_uploaded]" type="file" /></td><td><input button" value="Remove" onclick="delRow(this)"></td></tr>');
- });
- });
- function delRow(currElement) {
- var parentRowIndex = currElement.parentNode.parentNode.rowIndex;
- document.getElementById("myTable").deleteRow(parentRowIndex);
- }
- </script>
- id | first | last | email | file_uploaded
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement