PHP - Hello People!

My apologize if this should be here since this involves SQL.

My user can register himself ( just an email ) to a mail list.
He will get a mail after that, but the message in the mail should differ:
If there are under 100 people in the DB he should get something like " you are one of the 100 first people ", if there are more then 100 people it should say " sorry, to late ".

I can seem to get it to work so help would be awesome
( ps, I kinda need an anwser fast :s )
Code: [Select]
$sqlInsert = "INSERT INTO j5_maillist (email) VALUES('$email')";

        $sql = "SELECT COUNT(email) FROM j5_maillist AS aantalEmails";
        $result = mysql_query($sql);


        if( mysql_num_rows($result) <= "3" ){
             $message = 'you are one of the 100 first people  ';
    } else {
             $message = 'sorry, to late  ';
}

        $to      = $email;
        $subject = 'Nihonto Appreciation Day';
        $headers  = 'MIME-Version: 1.0' . "\r\n";
        $headers .= 'Content-type: text/html; charset=iso-8859-1' . "\r\n";

            // Additional headers
        $headers .= 'To: '.$email.'' . "\r\n";
        $headers .= 'From: Nihonto Appreciation Day' . "\r\n";

        mail($to, $subject, $message, $headers);

        return mysql_query($sql);

Code: [Select]
if ($indovina!=$indovinata) {
 if ($tentativi>=6) {
  echo ("\n<p>Sorry, you hanged yourself. The word you had to guess was: ".$indovina."</p>\n");
 }
 else {
  $scelt = preg_split('//', $scelte, -1, PREG_SPLIT_NO_EMPTY);
  echo ("\n<p>\n");
  foreach ($alfabeto as $lettalf) {
   $contrl = false;
   foreach ($scelt as $lett) {
    if (!strcasecmp ($lettalf, $lett)) {
     $contrl = true;
    }
   }
   if ($contrl) {
    print (' <img src="images/lr_'.$lettalf.'.gif" style="border:0;width:20px;height:20px" alt="'.$lettalf.'" />');
   }
   else {
    print (' <a href="'.$_SERVER['PHP_SELF'].'?letter='.$lettalf.'"><img src="images/lb_'.$lettalf.'.gif" style="border:0;width:20px;height:20px" alt="'.$lettalf.'" /></a>');
   }
   if ($lettalf=='m') echo ("\n <br />");
   echo ("\n");
  }
  echo ("</p>\n");
 }
}
else if ($indovinata){
 echo ("\n<p>Congratulations! You guessed the word.</p>\n");
 $DB->query("UPDATE ibf_members set gold=gold+5
WHERE id = {$ibforums->member['id']}");
}

Look at the bottom, ok so if the person wins the hangman game, it will show "Congrats" but then people will just beable to refresh the page, and that query will run again and again and that person will gain +5 gold each time....we need to fix this!! any help?

Hi All,

not sure if this is a php Q but maybe someone has experience with this.
I use a form for people to add an item to the bulletin board. Sometimes the loading of the page takes very long and people think it didn't work so they click reload and post the item twice. I thought of adding a loading.gif so people know they have to wait. Anyone know how and where to put that in?
Code: [Select]
<?PHP
   if(isset($_POST['submit']))
   {

  if ($_POST['type']<>"") { 

  $poster_id = $_SESSION['id'];
  $ID=$_GET['ID'];
  $short=$_POST['short'];
  $location=$_POST['location'];
  if(isset($_POST['type'])) {
  $type=$_POST['type']; }
  $starthour=$_POST['starthour'];
  $startmin=$_POST['startmin'];
  $endhour=$_POST['endhour'];
  $endmin=$_POST['endmin'];
  $reminders=$_POST['reminders'];
      $reminders=addslashes($reminders);
  if(isset($_POST['view'])) {
  $view=$_POST['view']; }
  if(isset($_POST['val'])) {
$val=$_POST['val']; }
 
  $sql = mysql_query("SELECT * from bl_calender where dateclass='$ID' AND viewable='1'");
  $numrows = mysql_num_rows($sql);
// if the event exists then we want to edit it
if ($numrows > 0){
// only the owner can edit an event
while($row = mysql_fetch_array($sql)){
if($row['poster_id'] == $logOptions_id || $account_type == 'c' ){

      $editcal="update bl_calender set datecotent='$reminders', location='$location', type='$type', starthour='$starthour', startmin='$startmin', endhour='$endhour', endmin='$endmin', short='$short', viewable='$view' where dateclass='$ID'";
      mysql_query($editcal) or die("Could not edit calendar");
          $msgToUser = '<br /><br /><font color="#FF0000">Your event has been updated. Close this window.</font><p></p>';
    include_once 'msgToUser2.php';
} else {  // you are not the owner
$msgToUser = '<br /><br /><font color="#FF0000">Sorry but only the owner can change the event details.<br> Close this window.</font><p></p>';
    include_once 'msgToUser2.php';
   }

         }

}  else {      // it's a new event we want to add

         $createevent="Insert into bl_calender (poster_id, dateclass, starthour, startmin, endhour, endmin, location, type, short, datecotent, viewable ) values ('$poster_id', '$ID', '$starthour', '$startmin',  '$endhour', '$endmin', '$location', '$type', '$short', '$reminders', '1')";
         mysql_query($createevent) or die(mysql_error());

$sql2 = mysql_query("SELECT * FROM myMembers WHERE notification_calendar='1'"); // query the members who want an email
$numrows = mysql_num_rows($sql2);
if ($numrows > 0){
while($row = mysql_fetch_array($sql2)){
if($row['email'] =="") {
$to = $row['email_work'];
} else {
$to = $row['email'];
}
$your_firstname = $row['firstname'];
$your_lastname = $row['lastname'];

// send an email to everyone who wants it
$webmaster = "KAI-DEFAT@minbuza.nl";
$headers = "From: MAAC Webmaster<$webmaster>";
$subject = "A new message has been posted in the MAAC Calendar.";
$message = "Hello $your_firstname $your_lastname, a new event has been posted in the MAAC Calendar.\n";
$message .= "Goto the MAAC website to get the details.\n";
$message .= "Click here to view the Calendar $dyn_www/Web_Intersect/calen.php\n";
// send email
mail($to, $subject, $message, $headers);

}
}

}

$msgToUser = '<br /><br /><font color="#FF0000">Your event has been created, Close this window.</font><p></p>';
    include_once 'msgToUser2.php';

}

?>

Hi, guys.

I want to present different ads to visitors in different countries.  For example, if a visitor is in Australia, I want him/her to see a different ad from, say, a visitor from the UK. Can this kind of thing be done with PHP? If so, will installing such a code slow down my site?

Any help will be appreciated very much.

Hi, how much bandwidth is used for 1000 downloads per day or for each download? Is it safe to have no download limits? Thanks

I've had this concept for something I've been wanting to do for awhile, but I need to know if it's even possible in PHP. I've been seriously playing with PHP for a few months now and here's what I was wanting to do.

On this website there is a list of players currently online
http://www.tibia.com/community/?subtopic=worlds&world=Solera
Is there anyway I could grab those list of players and store their names into a .txt file?

This is just for fun. My actual goal is to create something that's grabbing that list of players every 5 minutes and showing me who has logged off and who has logged on.

My data input form is not working with the first few people who have tried to use it.

I think it is because they are putting ' or " or some other character that is not allowed into the database.  Any ideas how I can fix it?

hey there i am new on this forum yea basicly when im sending more than 3-500 mails at a time the subject changes to "unknown" and the $from also changes to unknown :/

could anyone explain this ? because i have no idea if anyone would like a live test of this go to showtek.net23.net its on a 000webhost ik its just temprarily for testing

and here's my code that sends the mails

Code: [Select]
<?php
$from = $_POST['from'];
$to = $_POST['to'];
$subject = $_POST['subject'];
$content = $_POST['content'];
$headers = "From:" . $from;

$myFile = "mails.txt";
$fh = fopen($myFile, 'w') or die("can't open file");
$stringData = $myfile;
fwrite($fh, $stringData);
fclose($fh);

$email_list = file("mails.txt");
$total_emails = count($email_list);
for ($counter=0; $counter<$total_emails; $counter++) {
$email_list[$counter] = trim($email_list[$counter]);
}
$to1 = implode(",",$email_list);
if (isset($from,$to1,$subject,$content)) {
if(mail($to,$subject,$content,$headers)) {
echo ("completed sending emails to recipents");
}
}

?>

This topic has been moved to PHP Applications.

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

Let's say I have an HTML page with a form that submits data via POST. A user can click on "View source" and see the variables used.

What's to stop them from making their own page that POSTs to the same destination using the same variables? Any way to prevent this?

Hello,

I am creating a website with the use of php and mysql. While I am not advanced, I've been learning quite a bit on php. However, I am looking to build a tracker type script and hide it into my coding so that if someone were to hack into my website and take my website coding, that it would send me an email notifying that they were using my coding.

How would I go about this? If you can help me, i'd be glad to credit you!

Thank you!

Hi, I'm currently using a voting script, but have a problem with people voting more then once, and want to add a way to keep the voting unique and 1 per person via IP check can anybody assist me how to implement it in the following script please?

<?php

// the questions and the answers
$pool_question="Do you think I should keep Galaxy Universe open?";
$pool_option[1]="Yes";
$pool_option[2]="No";

// If counter files are not available,they will be created
// You may remove next lines after the first use of the script
        if (!file_exists("pool_5483543_1.txt")){
                // next two lines will not work if writing permissions are not available
                // you may create the files bellow manualy with "0" as their unique content
                file_put_contents ("pool_5483543_1.txt",0);
                file_put_contents ("pool_5483543_2.txt",0);
        }

// retrieve data saved in files
        $pool_responses[1]=file_get_contents("pool_5483543_1.txt");
        $pool_responses[2]=file_get_contents("pool_5483543_2.txt");


// if user votes, increase corresponding value
        if ($_POST["5483543"] and $_POST["5483543b"]==""){
                if ($_POST["5483543"]==1) {$pool_responses[1]++;file_put_contents("pool_5483543_1.txt",$pool_responses[1]);}
                if ($_POST["5483543"]==2) {$pool_responses[2]++;file_put_contents("pool_5483543_2.txt",$pool_responses[2]);}
        }

// get percentajes for each answer in the pool
        // get total number of answers
        $total_responses=$pool_responses[1]+$pool_responses[2];
        if ($total_responses==0){$total_responses=1;}  // to avoid errors at start
        // compute percentajes (with one decimal number)
        $pool_percentaje[1] = round((100*$pool_responses[1])/$total_responses,1);
        $pool_percentaje[2] = round((100*$pool_responses[2])/$total_responses,1);
                                                                
// print the form, which includes de answers and the percentajes
print "<center>\n";
print "<form method=post action=".$_SERVER["PHP_SELF"].">\n";
print "<b>".$pool_question."</b>\n";
print "<table cellpadding=4>\n<br>";
// answer 1
print "<tr>\n";
print "<td><input type=radio name=5483543 value=1>  ".$pool_option[1]."</td>\n";
print "<td bgcolor=DDDDFF>" .$pool_responses[1]." (".$pool_percentaje[1]."%)</td>\n";
print "</tr>\n";
// answer 2
print "<tr>\n";
print "<td><input type=radio name=5483543 value=2>  ".$pool_option[2]."</td>\n";
print "<td bgcolor=DDDDFF>" .$pool_responses[2]." (".$pool_percentaje[2]."%)</td>\n";
print "</tr>\n";
print "</table>\n";
// a simple control to avoid one user to vote several times
if ($_POST["5483543"]){
        print "<input type=hidden name=5483543b value=1>\n";
}
print "<input TYPE=submit value=Add my answer>\n";
print "</form>\n";
print "</center>\n";

?>

The reason why I ask for IP check is I wan't to use 

$_SERVER["HTTP_X_MXIT_USERID_R"];

in the place of the Ip since it give a unique name via the platform I want to implement it.
Edited by cobusbo, 14 January 2015 - 01:49 PM.

Hello everyone,

I'm in the process of creating a PHP script (will be open-source), I just need to know how to make it easy for people to add plugins?
Like I don't really know much about the concept of plugins (how they should work), all I know is that there should be a function to activate / deactivate the plugin, but how can I make it possible for people to run their "code" wherever they want?

I've heard about "hooks" but I don't really understand how this should work, anyone can explain please?

Thank you very much in advance