Array function questions?

[jjoves]

How can I modify this so I can allow any username to post notes. I dont need the password .

---

$allowed = array("username"=>"password);

mysql_free_result($result);
if ($mynotes && $user && $pass) {
if ($allowhtml == "0") {
$mynotes = str_replace("<", "&lt;", "$mynotes");
$mynotes = str_replace(">", "&gt;", "$mynotes");
}
if ($mydate && $todayonly == "0") {
$sql = "insert into notes (notes_date,notes_note,notes_time,notes_user) values ('$mydate','$mynotes',NOW(),'$user')";
} else {
$mydate = date("Y-m-d");
$sql = "insert into notes (notes_date,notes_note,notes_time,notes_user) values ('$mydate','$mynotes',NOW(),'$user')";
}

					while (list ($key, $val) = each ($allowed)) {
					    if ($key == "$user" && $val == "$pass") {

							mysql_query($sql) or die("error 324343");
						}

[jjoves]

Ok I narrowed it down to this - But I still need to enable any user to post notes

---

$allowed = array("username"=>"password");

if ((!$day || !$year || $month) && !$mydate) {
$mydate = date("Y-m-d");
} else {
$month = $month+1;
if ($month && $year && $day) {
$mydate = "$year-$month-$day";
}
}
echo "<strong style='font-size: 13px;color:#666699;'>$mydate</strong><br /><br />";
echo "<input type=\"hidden\" name=\"mode\" value=\"gowrite\">";
echo "<input type=\"hidden\" name=\"mydate\" value=\"$mydate\">";

				$sql = "select * from notes where notes_date='$mydate' order by notes_time asc";
				$result = mysql_query($sql);
				while ($row=mysql_fetch_array($result)) {
					echo "
						$row[notes_date]<br> 	  	
						<strong style='font-size: 11px;'>
						$row[notes_user]</strong> 
						$row[notes_time]
						<br/>".nl2br(stripslashes($row[notes_note]))."<br /><br />
					";
				}
				mysql_free_result($result);
				 if ($mynotes && $user && $pass) {

					while (list ($key, $val) = each ($allowed)) {
					    if ($key == "$user" && $val == "$pass") {
							mysql_query($sql) or die("error 324343");
						}
					}

					$adate = explode("-", $mydate);
					$mymonth = $adate[1]-1;
					header("Refresh:0;url=$PHP_SELF?day=$adate[2]&month=$mymonth&year=$adate[0]");
				}

[amchargue]

If you don't want password protection, just remove the loop that checks the $user / $pass combo against the $allowed array

while (list ($key, $val) = each ($allowed)) { 
if ($key == "$user" && $val == "$pass") { 
mysql_query($sql) or die("error 324343"); 
} 
}

Just replace with

mysql_query($sql) or die("error 324343");

and I think that should work.

Looks to me like the $allowed array at the top is designed to be filled in by possible user/pass combinations (which seems like a bad way to do it, but anyway). So if you're not going to use it, you could probably delete that.

If on the form that submits to this page, you don't even prompt the user for a password, you should delete all references to $pass too, or you'll get 'undefined' errors.

[jjoves]

THANK YOU!!! VERY MUCH!!!

[jjoves]

Thank you very much for the help - now with the time thing
Im in California would like the time to display accordingly. I am currently using the CURTIME() function but not displaying the correct time.

This is the output:

USER [19:31:55 ] ----> should be 5:35pm
blah blah blah message

---

$sql = "select * from notes where notes_date='$mydate' order by notes_time desc";
$result = mysql_query($sql);
while ($row=mysql_fetch_array($result)) {
echo "

						<strong style='font-size: 11px;'>
						$row[notes_user]</strong>
						$row[notes_time]
                        <br/>".nl2br(stripslashes($row[notes_note]))."<br /><br />

					";
				}
				mysql_free_result($result);
				 if ($mynotes && $user) {
					if ($allowhtml == "0") {
						$mynotes = str_replace("<", "&lt;", "$mynotes");
						$mynotes = str_replace(">", "&gt;", "$mynotes");
					}
					if ($mydate && $todayonly == "0") {
						$sql = "insert into notes (notes_date,notes_note,notes_time,notes_user) values ('$mydate','$mynotes',CURTIME(),'$user')";
					} else {
						$mydate = date("Y-m-d");
						$sql = "insert into notes (notes_date,notes_note,notes_time,notes_user) values ('$mydate','$mynotes',CURTIME(),'$user')";
					}

---

[amchargue]

Might be easier to look at PHP time functions, then set a PHP var to a time value, then insert that into the database instead of messing with mysql functions. Either way, I'd have to check the docs -- which you can do for yourself 😃
http://php.net
http://mysql.com