PHP & MySQL - saving and looping problems.

Posted by R.I.P.coalMINERS on Stack Overflow See other posts from Stack Overflow or by R.I.P.coalMINERS
Published on 2010-04-26T10:18:06Z Indexed on 2010/04/26 10:23 UTC
Read the original article Hit count: 195

Filed under:
|
|

I'm new to PHP and MySQL I want a user to be able to store multiple names and there meanings in a MySQL database tables named names using PHP I will dynamically create form fields with JQuery every time a user clicks on a link so a user can enter 1 to 1,000,000 different names and there meanings which will be stored in a table called names.

Since I asked my last question I figured out how to store my values from my form using the for loop but every time I loop my values when I add one or more dynamic fields the second form field named meaning will not save the value entered also my dynamic form fields keep looping doubling, tripling and so on the entered values into the database it all depends on how many form fields are added dynamically. I was wondering how can I fix these problems?

On a side note I replaced the query with echo's to see the values that are being entered.

Here is the PHP code.

<?php
if(isset($_POST['submit'])) {
$mysqli = mysqli_connect("localhost", "root", "", "site");
$dbc = mysqli_query($mysqli,"SELECT * FROM names WHERE userID='$userID'");

$name = $_POST['name'];
$meaning = $_POST['meaning'];

if(isset($name['0']) && mysqli_num_rows($dbc) == 0 && trim($name['0'])!=='' && trim($meaning['0'])!=='') {

for($n = 0; $n < count($name); $n++) {
    for($m = 0; $m < count($meaning); $m++) {
        echo $name[$n] . '<br />';
        echo $meaning[$m] . '<br /><br />';
        break;
    }
}

}

}
?>

And here is the HTML code.

<form method="post" action="index.php">
<ul>
    <li><label for="name">Name: </label><input type="text" name="name[]" id="name" /></li>
    <li><label for="meaning">Meaning: </label><input type="text" name="meaning[]" id="meaning" /></li>
    <li><input type="submit" name="submit" value="Save" /></li>
</ul>
</form>



If needed I will place the JQuery code.

© Stack Overflow or respective owner

Related posts about php

Related posts about mysql