PHP - Moved: What Do You Dread Dealing With Most In Php?

This topic has been moved to Application Design.

http://www.phpfreaks.com/forums/index.php?topic=347191.0

So if I have this code (while working on my local machine )...
Code: [Select]
for ($i=1; $i<=15; $i++) {
if ($timelimit == $i) {
${"time".$i}="selected='selected'";
}
}

<select name="timelimit">
<option value="1" <?php echo $time1;?>>1</option>
<option value="2" <?php echo $time2;?>>2</option>
<option value="3" <?php echo $time3;?>>3</option>
<option value="4" <?php echo $time4;?>>4</option>
<option value="5" <?php echo $time5;?>>5</option>
<option value="6" <?php echo $time6;?>>6</option>
<option value="7" <?php echo $time7;?>>7</option>
<option value="8" <?php echo $time8;?>>8</option>
<option value="9" <?php echo $time9;?>>9</option>
<option value="10" <?php echo $time10;?>>10</option>
<option value="11" <?php echo $time11;?>>11</option>
<option value="12" <?php echo $time12;?>>12</option>
<option value="13" <?php echo $time13;?>>13</option>
<option value="14" <?php echo $time14;?>>14</option>
<option value="15" <?php echo $time15;?>>15</option>
</select>
When I view the select menu in the browser, all but one of the options says "Notice:  Undefined variable: time1 in C:\wamp\www\yyyyyy\create.php on line 112".

It doesn't say this if I publish everything to the internet.

So the question is, should I put code in to eliminate those Notices, or does it not matter.   In other words, if I add this snippet below to declare all the other variables, it eliminates all the Notices. But is this necessary/good practice to do?..
Code: [Select]
for ($i=1; $i<=15; $i++) {
${"time".$i}="";
}

Hi

I found a tutorial on dealing with databases he http://www.phpfreaks.com/tutorial/php-basic-database-handling

It's great, except that I need it to do more than just a name; I need first, last, dob and email. I have it figured out how to order, insert and delete, but can someone help me figure out how to do the updating?

The tutorial creates an array called cname and loops through it to do the update, but when I add more fields, it only holds the last fileds (emails in this case)

I just need to be able to update all the fields for each user instead of just the name. Sounds easy but I've gotten nowhere

Everything I have tried is posted below.

Any help? Thanks

Code: [Select]
// INSERT: if we have a name to add...
if($_POST['fname']) {   
// little bit of cleaning...   
$fname = mysql_real_escape_string($_POST['fname']);
$lname = mysql_real_escape_string($_POST['lname']);
$dob = mysql_real_escape_string($_POST['dob']);
$email = mysql_real_escape_string($_POST['email']);
// check for previous entry
$sql_check = "SELECT id FROM test WHERE fname='$fname' AND lname='$lname'";
$res_check = mysql_query($sql_check, $conn) or trigger_error("SQL", E_USER_ERROR);
if (mysql_num_rows($res_check) == 1) {
while ($row = mysql_fetch_assoc($res_check)) {
$id = $row['id'];
}
// update
$sql = "UPDATE test SET Current=1 WHERE id='$id'";
$res = mysql_query($sql, $conn) or trigger_error("SQL", E_USER_ERROR);
} else {
// insert new name into table   
$sql = "INSERT INTO test (id, fname, lname, dob, email) VALUES ('', '$fname', '$lname', '$dob', '$email')";   
$result = mysql_query($sql, $conn) or trigger_error("SQL", E_USER_ERROR);
}
} // end if
// UPDATE: if we have name(s) to change...
if($_POST['udata']) {   
/*
// for each name to change...   
foreach ($_POST['udata'] as $input => $v) {
echo "$input = $v<br />";
$sql = "UPDATE test SET ";
foreach ($v as $id => $value) {
echo "$id = $value<br />";
}
$sql .= "WHERE ...";
}
echo "<hr />$sql<hr />";
print_r($_POST['udata']);
*/

for ($i = 0; $i < count($_POST['udata']['fname']); $i++) {
$fname = $_POST['udata']['fname'][$i];
echo "$i = $fname<br />";
}

/*
foreach($_POST['cname'] as $cid => $cname) {     
// little bit of cleaning...     
$id = mysql_real_escape_string($cid);     
$fname = mysql_real_escape_string($cname);
$lname = mysql_real_escape_string($cname);
$dob = mysql_real_escape_string($cname);
$email = mysql_real_escape_string($cname);
// update name in the table       
$sql = "UPDATE test SET fname = '$fname', lname='$lname', dob='$dob', email='$email' WHERE id = '$id'";     
$result = mysql_query($sql, $conn) or trigger_error("SQL", E_USER_ERROR);   
} // end foreach
*/
} // end if         
// DELETE: if we have a name to delete...
if($_GET['id']) {   
// little bit of cleaning...   
$id = mysql_real_escape_string($_GET['id']);   
// delete name from table   
$sql = "UPDATE test SET Current=0 WHERE id= '$id'";   
$result = mysql_query($sql, $conn) or trigger_error("SQL", E_USER_ERROR);
} // end if
// ORDERBY: if one of the links was clicked..
if ($_GET['orderby']) {   
// make an aray of allowed names   
$allowed = array('id','fname', 'lname', 'dob', 'email');   
// bit of cleaning...   
$order = mysql_real_escape_string($_GET['orderby']);   
// is it a valid column name? yes: use it. no: default to 'id'   
$order = (in_array($order, $allowed))? $order : "id";
// if no link clicked, default to 'id'
} else {   
$order = "id";
} // end else
// SELECT: get the list of names from database
$sql = "SELECT id, fname, lname, dob, email FROM test WHERE Current=1 ORDER BY $order";
//$result = mysql_query($sql, $conn) or trigger_error("SQL", E_USER_ERROR);
$result = mysql_query($sql, $conn) or die(mysql_error());
/**** end deal with the database ****/
/**** list everything out ****/
// list columns
echo "<form action = '{$_SERVER['PHP_SELF']}' method = 'post'>\r\n";
echo "<table border = '1'>\r\n";
echo "<tr>\r\n";     
echo "<td><a href = '{$_SERVER['PHP_SELF']}?orderby=id'>id</a></td>\r\n";     
echo "<td><a href = '{$_SERVER['PHP_SELF']}?orderby=fname'>fname</a></td>\r\n";   
echo "<td><a href = '{$_SERVER['PHP_SELF']}?orderby=lname'>lname</a></td>\r\n";   
echo "<td><a href = '{$_SERVER['PHP_SELF']}?orderby=dob'>dob</a></td>\r\n";     
echo "<td><a href = '{$_SERVER['PHP_SELF']}?orderby=email'>email</a></td>\r\n";   
echo "<td>delete</td>\r\n";   
echo "</tr>\r\n";
// loop through list of names
while ($list = mysql_fetch_assoc($result)) {
echo "<tr>\r\n";     
echo "<td>{$list['id']}</td>\r\n";     
echo "<td><input type = 'text' name = 'udata[fname][{$list['id']}]' value = '{$list['fname']}' />\r\n";
echo "<td><input type = 'text' name = 'udata[lname][{$list['id']}]' value = '{$list['lname']}' />\r\n";
echo "<td><input type = 'text' name = 'udata[dob][{$list['id']}]' value = '{$list['dob']}' />\r\n";
echo "<td><input type = 'text' name = 'udata[email][{$list['id']}]' value = '{$list['email']}' />\r\n";
echo "<td><a href = '{$_SERVER['PHP_SELF']}?id={$list['id']}'>delete</a></td>\r\n";   
echo "</tr>\r\n";
} // end while
// list input box for adding new entry
echo "<tr>";     
echo "<td bgcolor = 'gray'></td>\r\n";     
echo "<td><input type = 'text' name = 'fname' /></td>\r\n"; 
echo "<td><input type = 'text' name = 'lname' /></td>\r\n";
echo "<td><input type = 'text' name = 'dob' /></td>\r\n";
echo "<td><input type = 'text' name = 'email' /></td>\r\n";
echo "<td bgcolor = 'gray'></td>\r\n";   
echo "</tr><tr>\r\n";     
echo "<td></td>\r\n";
echo "<td align = 'center'><input type = 'submit' value = 'submit' /></td>\r\n";     
echo "<td></td>\r\n";
echo "</tr></table></form>\r\n";
/**** end list everything out ****/

I am using file_get_contents to get file off the internet for  further processing but somtetimes there is error fetching that file off the web in which case it would be nice to try to reload it again but I am not sure what would be best way to do it? How can I jump back on error? I guess there would have to be some jump to label condition, but how do I implement this?

<?php
if ($beyondportal % 26 == 0 || $beyondportal == 0){ ?>
MY CONTENT
<?php } ; ?>


This code compares my variable $beyondportal and if it is a multiple of 26 counting up from 0, it prints my content.

This is great but sometimes the number comes up a negative that is a multiple counting down from 0 like  -26, -52, etc..

if I could do the opposite of a modulus I would think it would work but I'm not sure how to in php. any suggestions?