PHP - Chubbychub (no, This Thread Isn't Spam)

finally got some time to code   anyway i cant figure out why this doesnt work, i think its an error in my logic...

<?php
$db = new PDO('mysql:host=localhost; dbname=test;', 'root', '');
$db2 = new PDO('mysql:host=localhost; dbname=test2;', 'root', '');
foreach($db->query('SELECT * FROM database1 LIMIT 1') as $row) {
$thing1 = $row['COL 1'];
$thing2 = $row['COL 2'];
$thing3 = $row['COL 4'];
$thing4 = $row['COL 6'];
$thing5 = $row['COL 7'];
$content = "\"big text with $things\"";
addslashes($content);
$db2->exec("INSERT INTO database2(col1,col2,col3) VALUES ('$thing1','text','$content')");
}
?>

my foreach command should read all lines from database one and write one by one on database two? thx in advance

Mmm i'm not sure if i'm approaching this correctly.

Anyways, I wanted to create a multi-level thread, Where the child thread would be after the parent thread.

Something like this:

Hello World
       - Hello World
               - Hi!
               - What's up?
       - Hi Bob!
Goodbye World
       - ....This guy got issues
       - Dude! You should watch Despicable Me! "It's so fuzzy i'm going to dieee!"


Anyways, so my table looks something along the line of this:

|    post id   |    parent_id    |            title            |      body    |   date      |
      1                |       NULL        |    Hello                  | Hi, i'm K    |   date
      2                |       NULL        |    Thread One       | Body One  |   date
      3                |          1           |    Hello World | Body One  |   date
      4                |          2           |    Thread post 4   | Body One  |   date
      5                |          1           |    Thread post 5   | Body One  |   date
      6                |          1           |    Thread post 6   | Body One  |   date
      7                |          3           |    Hi What's up    | Body One  |   date


And here's the PHP code, although it's not very neat I want to clean it up and make it neater.  I can only go two level deep so far.   Any suggestion or recommendations? 

Using while & for:


// Select * Threads
$q = "SELECT * FROM test_db ORDER BY post_id ASC";
$r = @mysql_query($q);



while ($pid_row = @mysql_fetch_object($r)) {

// Array
$pid_arr[] = $pid_row->post_id; // Assign Indexes to Post ID
$ppid_arr[] = $pid_row->parent_id; // Assign Indexes to ParentID
$md_arr = array($pid_arr, $ppid_arr);  // Create multi-dimensional array matrix

$parent_id = $pid_row->parent_id;




}

for ($i = 0; $i < count($pid_arr); $i++) {

for ($a = 0; $a < count($ppid_arr); $a++) {
$pid = $pid_arr[$i]; // pid = post id
$ppid = $ppid_arr[$i]; // ppid = parent id

//echo "<div>~~ PID $pid ~~ PPID $ppid ~~</div>";

if ($ppid === NULL) {
$ppid_is_null = " & parent_id is NULL";
} else {
$ppid_is_null = NULL;
}

// Select Top level Thread
$z = "SELECT * FROM test_db WHERE post_id = '$pid'";
$y = @mysql_query($z);

while ($t_row = @mysql_fetch_object($y)) 
{

$title = $t_row->title;  // title of child thread
$level = $t_row->level;  // level of child thread...is this useful?
}




// Display top level thread lvl 1
if ($ppid === NULL) {  // If the parent_id is NULL, display top level thread
echo '<div>PID: ' . $pid . ' || PPID: ' . $ppid . " || Title: " . $title . "</div><br>\n";

$post = $pid; // PostID = 1
$parent = $ppid; // Parent ID ex: [1]

// Get child id, where parent id = [1]
// trying to get the child thread here...but it's not working
$child_q = "SELECT * FROM test_db WHERE parent_id = '$post'";
$child_r = @mysql_query($child_q);

while($c_row = @mysql_fetch_object($child_r)) {
$c_arr[] = $c_row->post_id;
$c_ppid_arr[] = $c_row->parent_id;
}
for ($n = 0; $n < count($c_arr); $n++) {
if ($c_ppid_arr[$n] === $post) {
echo "<div>$c_arr[$n]</div>";



}

}
break;

//echo "<div>PID: $pid</div>";




} 




break;
}

}



Using While:

<?php 
require_once('db_connection');
echo '<hr><hr><br>';

// I just realized that selecting * where parent id is null might limit the amount of rows retrieved.

// Query to select threads
$n = NULL;
$q = "SELECT * FROM test_db WHERE (test_db.parent_id is NULL) Order By date ASC";
$r = @mysql_query($q);

while ($threads = @mysql_fetch_object($r)){
$pid = $threads->post_id;
$sid = $threads->subject_id;
$parent_id = $threads->parent_id;
$title = $threads->title;
$body = $threads->body;



echo '<div>PostID: ' . $pid . ' || Parent: ' . $parent_id . ' || SubjectID: ' . $sid . ' || Title: ' . $title . ' || Body: ' . $body . '</div>';

$q2 = "SELECT * FROM test_db WHERE parent_id = '$pid' Order by date DESC";
$r2 = @mysql_query($q2);

while ($level2 = @mysql_fetch_object($r2)) {
$level2_pid = $level2->post_id;
$level = 1.5 *($level2->level); // lvl 2: 3em


echo '<div style="text-indent:' . $level . 'em">' . 'PostID: ' . $level2->post_id . ' || ParentID: ' . $level2->parent_id . '</div>';


$q3 = "SELECT * FROM test_db WHERE parent_id = '$level2_pid'";
$r3 = @mysql_query($r3);
while ($level3 = @mysql_fetch_object($r3)) {

$level3 = 1.5 + $level;

echo '<div style="text-indent:' . $level3 . 'em">' . 'PostID: ' . $level3->post_id . ' || ParentID: ' . $level3->parent_id . '</div>';

}






}


}


?>


I'm not a comp. sci major or anything, so I'm learning this as I go.  Any help would be greatly appreciated.   It seems like the while & for is more practical, but i'm not quiet sure.  What am I doing wrong?

- K

I just joined this forum today ^_^  Hope to be good friends with you guys and gals

ive been geting attacked by a spam bot

it is inserting gibrish in one of my contact forms.

i managed to block it with
Code: [Select]
if (empty($_POST['Email']) && !empty($_POST['CustomerEmail']))
Email is an empty  text field with display:none

for sometime it was clean and now it succeeds once in a while to insert a form.

i dont want to use captcha , i think i will loose clients

your advise

Hey

My site is getting alot of spam and i need a way to keep up with what is being sent with some kinda system that will flag things which contain urls and chosen keywords.

Problem i faced though was lets say a keyword was:

skyspider

Now some one could say sky or spider (as seperate words) but they still flagged. So "theres a spider in the sky" would be flagged when i only want "skyspider" flagged... does that make sense?

What php function do i require to do such string checks like this?


Thanks

Hi..

I want to implement a program for identifying spam emails using an algorithm naive bayes
in php..

How to implement this ..can any one help me..

thanks in advance

A form is filled and the information is emailed to my address.

The problem is it goes to the spam folder.

Is it a problem with the email filter?

I suppose I could whitelist the email address the server uses to email the info, but then spam would get through as well.

Any ideas?

Hi This subject doesn't really have a category but is driving me mad. I use the mail() function to send out emails to a news group forum that I have created. This forum does the same. I am getting the emails placed in a spam folder. Is there any way around this. I have been told that it has something to do with no reverse DNS. I get emails like DoNotReply@bt.com. This email address doesn't exist. How does the email system know this, and is there a way around it.

TIA

Desmond.

I 'm having some problem while sending mails . i am sending bulk mails using php script, der is no problem in the script. i hope some guys have faced similar issue.
while i am sending bulk emails, i figured out that - few mails are going to spam not into their INBOX.
can you guys pls give some hint to resolve this issue. ..

Hi;

I had an email from my hosting company which said that my account was hacked and one script in images folder is trying to send thousands of spams(file name : "/public_html/images/sm5vy7.php"). they blocked my account and asked me to check if there is any script or code that may cause this problem.
The only server side page I had was a contact.php file that has mail() function in it. the code is like this;

"if( isset($_POST['submit'])) {
$name=$_POST['name'];
$comment=$_POST['comment'];
$email=$_POST['email'];
$phone=$_POST['phone'];
$to = "sample@gmail.com";
$subject = "sample";
$message = "sample";
$from = "$email";
$headers = "Content-type:text;charset=utf-8" . "\r\n";
$headers .= "From: $from" . "\r\n";
mail($to,$subject,$message,$headers);
}"

My question is "can the code I used cause any security problem that someone be able to create a php file in my images folder or someone has accessed my account?"

Thank you in advance
I'm really in a big trouble

i am using mail functions in php and i am sending mails but the mails are going to spam in gmail and for yahoo its going to inbox. my problem is i want to send the email to inbox only as most of them use gmail ....should i use any smtp or any other mail library functions?
can anyone guide me?

Ok, so I want to make a comment spam filter for my site.  I know the basic logic, but have yet to figure out how to write the functions.  I have a database table called comments that has a column called "time", which contains a unix timestamp value of when it was posted.  Basically what I want to do is this:

When a user tries to post a comment, the script determines with a database query if they have posted a comment in the last 120 seconds.

So basically I have to find the current time, and the time it was 120 seconds before the current time.  Then I have to find any comments posted by the user that were made after the 120 second mark.

My database query should then look something like this, right?

Code: [Select]
$query = mysql_query("SELECT * FROM comments WHERE author = ".$_SESSION['id']." AND time > '".$120secondsago"'");

Please correct me if my logic is wrong, which it very well may be, but how would I find the unix timestamp code from 120 seconds before the current time?  Note that 120 seconds is just an example and also that I have not worked with dates in mysql very often.

$query = mysql_query("SELECT * FROM comments WHERE author = ".$_SESSION['id']." AND time

The script below works but it goes straight to the junk folder only since i added the parts below to the form. (the form is in another file)
How do i stop it from going to the junk folder.

Quote

$error = $_GET['error'];
$httpagent = getenv ('HTTP_USER_AGENT');
$url = $_SERVER['HTTP_REFERER'];


Code: [Select]
<?php
 require_once "Mail.php";
  $optional = $_POST['optional'];
$error = $_POST['error'];
$url = $_POST['url'];
$httpagent = $_POST['browser'];
$ip = isset($_SERVER['REMOTE_ADDR']) ? $_SERVER['REMOTE_ADDR'] : '';
 
 $from = "Web server <removed>";
 $to = "Admin <removed>";
 $subject = "Someone has submitted an error.";
 $body = "Someone has submitted an error.\n".
"Error: $error\n".
"URL: $url\n".
"Web browser: $httpagent\n".
"Anything else you want to add?: $optional\n".
"IP: $ip\n";
 
 $host = "removed";
 $username = "removed";
 $password = "removed";
 
 $headers = array ('From' => $from,
   'To' => $to,
   'Subject' => $subject);
 $smtp = Mail::factory('smtp',
   array ('host' => $host,
     'auth' => true,
     'username' => $username,
     'password' => $password));
 
 $mail = $smtp->send($to, $headers, $body);
 
 if (PEAR::isError($mail)) {
   echo("<p>" . $mail->getMessage() . "</p>");
  } else {
   header('Location: thank-you.html');
  }
 ?>

This topic has been moved to Miscellaneous.

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

This topic has been moved to Miscellaneous.

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

im having some robots injecting gibberish

i wnat to deny amy links in the requesttext of the form
for some reason i tested it and it accepted a http link
Code: [Select]
if (preg_match("/http/i","$RequestText")){ exit();}

thanks