[[SOLVED] Loops and arrays... problem]

I'll get right down to the problem. First of all, here's one of the part's I'm having trouble with.

<?php
// Above contains the SELECT query
if(mysql_num_rows($query) > 0) {
    while($row = mysql_fetch_array($result)) {
        echo '<form action="result.php" method="POST">
<input name="pm_delete[]" type="checkbox" value="' . $row['msg_id'] . '"><br />
<input type="submit" name="submit" value="Submit">
</form>';

 

As you can see, for each of the results, it displays a checkbox.

 

Here's result.php:

<?php
// All the checks go above here
$query = DELETE $privmsgs_tbl_name, $privmsgs_spec_tbl_name FROM $privmsgs_tbl_name, $privmsgs_spec_tbl_name WHERE ";

foreach($_POST['pm_delete'] as $arr => $pid) {
    $query .= "$privmsgs_tbl_name.msg_id = '$pid'
    AND $privmsgs_tbl_name.recipient_uid = '$session_uid'
    AND $privmsgs_spec_tbl_name.msg_id = '$pid'
    AND $privmsgs_spec_tbl_name.user_id = '$session_uid'
}

 

Ok. Let me explain. I put the selected checkbox(es) in an array. Now, for each of the checkboxes, I want to delete the row associated with it (with the "$row['msg_id']" being the common "thing" between them). But, I need an AND statement at the end of each query (otherwise, it would look like this:

AND $privmsgs_spec_tbl_name.user_id = '$session_uid'$privmsgs_tbl_name.msg_id = '$pid'

... which of course, would throw an error).

 

But if I just add an " AND " at the end, the last element would look like this:

AND $privmsgs_spec_tbl_name.user_id = '$session_uid' AND

... which will also throw an error.

 

So how would I configure the code so that it adds an " AND " at the end of each pass without adding one at the last pass?

[find URL in code]

Use strpos().

[[SOLVED] Registration form help]

Yep, and also validating the e-mail address. This is just a function that I wrote a long time ago that validates the e-mail address..

 

<?php
function validate_email ($email) {
// First, we check that there's one @ symbol, and that the lengths are right
if (!ereg("^[^@]{1,64}@[^@]{1,255}$", $email)) {
	// Email invalid because wrong number of characters in one section, or wrong number of @ symbols.
	return false;
}
// Split it into sections to make life easier
$email_array = explode("@", $email);
$local_array = explode(".", $email_array[0]);
for ($i = 0; $i < sizeof($local_array); $i++) {
	if (!ereg("^(([A-Za-z0-9!#$%&'*+/=?^_`{|}~-][A-Za-z0-9!#$%&'*+/=?^_`{|}~\.-]{0,63})|(\"[^(\\|\")]{0,62}\"))$", $local_array[$i])) {
		return false;
	}
}
if (!ereg("^\[?[0-9\.]+\]?$", $email_array[1])) {
	// Check if domain is IP. If not, it should be valid domain name
	$domain_array = explode(".", $email_array[1]);
	if (sizeof($domain_array) < 2) {
		// Not enough parts to domain
		return false;
	}
	for ($i = 0; $i < sizeof($domain_array); $i++) {
		if (!ereg("^(([A-Za-z0-9][A-Za-z0-9-]{0,61}[A-Za-z0-9])|([A-Za-z0-9]+))$", $domain_array[$i])) {
		return false;
		}
	}
}
return true;
}
?>

[[SOLVED] PHP and MySQL error]

I figured it out.

 

<?php
$query = "DELETE
                  $privmsgs_tbl_name,
                  $privmsgs_spec_tbl_name
              FROM
                  $privmsgs_tbl_name,
                  $privmsgs_spec_tbl_name
              WHERE
                  $privmsgs_tbl_name.msg_id = '$pm_id'
                  AND $privmsgs_tbl_name.recipient_uid = '$session_uid'
                  AND $privmsgs_spec_tbl_name.msg_id = '$pm_id'
                  AND $privmsgs_spec_tbl_name.user_id = '$session_uid'
                  AND $privmsgs_tbl_name.msg_id = $privmsgs_spec_tbl_name.msg_id
                  AND $privmsgs_tbl_name.recipient_uid = $privmsgs_spec_tbl_name.user_id
                  AND $privmsgs_tbl_name.author_uid = $privmsgs_spec_tbl_name.author_id";
$result = mysql_query($query) OR DIE (mysql_error());
?>

 

Thank you to everyone who helped.

[image to swf]

Not that I know of. I believe you'll need Macromedia Flash for that. 

[Extract image and save to directory.]

Please bump your topic after at least an hour has passed. We all have lives, you know...

[[SOLVED] Registration form help]

From what I can see, register2.php doesn't even check that all the fields were filled in.

 

register2.php

<?php
$pagename = "Registration";
include "session2.inc.php";
include "../config.inc.php";
include "top.txt";
//Connect to mySQL Database
mysql_connect("$host", "$username", "$password")or die("Can't connect");
mysql_select_db("$db_name")or die("Can't connect");

// Get the information the user submitted for registration
$uname=$_POST['uname'];
$pass=$_POST['pass'];
$email=$_POST['email'];

if(empty($uname)) {
    echo 'You did not fill in your username';
}
elseif(empty($pass)) {
    echo 'You did not fill in your password.';
}
elseif(empty($email)) {
    echo 'You did not fill in your e-mail.';
}

// Encrypt the password using MD5, to safely store the password.
$md5pass=md5($password);

$tbl_name = "admins";
$sql = "INSERT INTO $tbl_name (`uname` , `pass` , `email`) VALUES ('$uname' , '$md5pass' , '$email')";
$result=mysql_query($sql) or die("Error: ". mysql_error(). " with query ". $sql);

if($result){
echo "Thank you for registering, $uname. You may now <a href=\"index.php\">Login</a>";
}
else {
echo "There was a mistake processing your registration. Go <a href=\"register.php\">back</a> and try again. ^^;";
}
mysql_close();
include "bottom.txt";
?>

 

For each of the fields that are required, do what I have done. If a field is optional, ignore it.

[[SOLVED] PHP and MySQL error]

[b]@ corillo181:[/b]
So then, it would look something like this?

[code]
<?php
$query = "DELETE
                  $privmsgs_tbl_name,
                  $privmsgs_spec_tbl_name
              FROM
                  $privmsgs_tbl_name
              LEFT JOIN
                  $privmsgs_spec_tbl_name
              ON
                  $privmsgs_tbl_name . '.msg_id' = $privmsgs_spec_tbl_name . '.msg_id'
              WHERE
                  pm.recipient_uid = $session_uid
              AND pm_spec.msg_id = $pm_id
              AND pm_spec.user_id = $session_uid
              AND pm.msg_id = pm_spec.msg_id
              AND pm.recipient_uid = pm_spec.user_id
              AND pm.author_uid = author_id";
$result = mysql_query($query) OR DIE (mysql_error());
?>

 

@ skali:

The printed query looks like this:

DELETE FROM privmsgs AS pm, privmsgs_spec AS pm_spec WHERE pm.msg_id = '3' AND pm.recipient_uid = '4' AND pm_spec.msg_id = '3' AND pm_spec.user_id = '4' AND pm.msg_id = pm_spec.msg_id AND pm.recipient_uid = pm_spec.user_id AND pm.author_uid = author_id

 

So the variables are all there. It fails in phpMyAdmin also.[/code]

[[SOLVED] PHP and MySQL error]

Yes.

[[SOLVED] Form that writes url]

Make a form.

<form action="result.php" method="GET">
<b>Email Address:</b> <input type="text" name="emailpassword"><br />
<input type="submit" value="submit">
</form>

 

Submit a e-mail address. It shows in the URL.

[[SOLVED] PHP and MySQL error]

Does anyone know what's wrong with this?

 

<?php
$query = "DELETE FROM
                  $privmsgs_tbl_name AS pm,
                  $privmsgs_spec_tbl_name AS pm_spec
              WHERE
                  pm.msg_id = $pm_id
              AND pm.recipient_uid = $session_uid
              AND pm_spec.msg_id = $pm_id
              AND pm_spec.user_id = $session_uid
              AND pm.msg_id = pm_spec.msg_id
              AND pm.recipient_uid = pm_spec.user_id
              AND pm.author_uid = author_id";
$result = mysql_query($query) OR DIE (mysql_error());
?>

 

MySQL keeps on giving me this error:

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'WHERE pm.msg_id = '3' AND pm.recipient_uid = '4' A' at line 4

 

I checked the manual and I believe I'm doing this correctly... but apparently, I'm not. Help, please. Oh, and btw, I got all the variables defined, so that's not the problem.

[[SOLVED] PHP and option list]

Oh, right. It's just an echo statement. I'm not used to short-hand tags. Sorry. Now I get it. Thank.

[[SOLVED] PHP and option list]

Even though I saw a lot of these

<?=$variable?>

 

floating around, I still have no idea what it does. Can you explain it for me?

[[SOLVED] PHP and option list]

I just want a simple drop-down list where a specific value is automatically selected according to the data stored in the database.

 

Ex:

<select name="select_blah_1">
    <option name="1" value="1" selected="true">
    <option name="2" value="2" selected="false">
</select>

 

How would I go about doing that?

 

[lushnews - Php News System]

Then let them register themselves.

[Clan CMS]

When logged in, it says

"Thankyou for logging in huggy1"

 

when it should be

"Thank you for logging in, huggy1".

 

Also, you should not give out a username and password with admin privileges.

 

Overall, nice layout.

 

[[SOLVED] Display HTML Code if URL = ""]

Can you show us the code that you've used to do what Dragen told you to do?

[Can you check my Website in Opera]

Where's the link? The link to your website?

[[SOLVED] a few php questions]

The form I've posted is the main one (where the user types in their username to be redirected to your password script.

[Question]

If you want someone else to build it for you, please post your request in the Freelancing area. It's better to try to make your own script and stumble on every step of the way than to copy and paste a code off of a cra*py tutorial and expect it to work.

[Tell me what your think!]

Just tested your registration script. It does not check if the password 1 field matches the password 2 field. You might want to fix that.

[[SOLVED] a few php questions]

I'm not very experienced with iframes, so I can't say exactly. I'll let the other users answer that.

 

For your second question, I'm assuming you have one page that displays the form, and another page which processes the form. If my assumption is correct, put that code near the top on the processing page. So it'll look something like this:

 

form:

<form action="process.php" method="POST">
<input name="username" type="text">
</form>

 

processing page:

<?php
$username = $_POST['username'];
// If the form wasn't submitted, redirect the user to the form page
if(!isset($username)) {
   header('Location: form.php');
   exit();
}
else {
   header('Location: /' . $username . '/');
}
?>

 

Note that I haven't tested this yet. But the layout of the code should look similar to this.

[[SOLVED] a few php questions]

For your first question...

I don't really recommend it, but use iframes.

 

For your second question...

header('Location: users/ ' . $username);

[my website, please critique]

Pretty neat! I'm glad you used CSS.

 

Ok. First of all, your top banner (a part of it, anyways) needs to link back to the main page (even though you have the nav at the top).

On forums/index.php, have the pics AND the title of the category be links. Also on that same page, "Healthy Eating Advice" and "Contact" overlap (in the top nav).

[PHP Calendar]

Looks cool. But when I scroll my mouse over the back/forward (and the x at the top right corner), it says "[object HTMLelement]" (as the title attribute). You might want to remove that.