PHP - Reloading Problem

I have a form where people have to fill in some fields and send an email. When there is an error the user has to go back to the form with:
Code: [Select]
if (!isset($_POST['checkbox'])) { 
$msgToUser = '<br /><br /><font color="#FF0000">You did not add any recipients!<br><a href="javascript: history.go(-1)">Go Back</a></font>';
    include_once 'msgToUser.php';
    exit();
} 
I want to save the data that has been filled in the textarea so he doesn't have to type eveything again.
I tried several options but the textarea keeps getting blank.

Code: [Select]
<?php
$message = isset($_POST['message']) ? $_POST['message'] : '';

$fhtml = "<p>Welcome <b>'$logOptions_username'</b> write your email here.&nbsp;&nbsp; <a href=\"#\" onclick=\"return false\" onmousedown=\"javascript:toggleViewFlags('country_flags');\">Add Recipients</a>
<br>
</p><input type=hidden name=post value=yes><p>
Subject:<br>
<input type=text name=name size=100>
</p>
<p>
Message:<br>
<textarea name=message rows=10 cols=75>$message</textarea>
</p>
<p>
<input type=submit name=submit value=\"Send\">
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;$sendMsg
</p>
";
echo $fhtml;
?>
This code is apparently not working.

Marco

Hi everybody

I am a PHP rookie for now, and
I want to reload the same dynamic page - it's content in several languages - by clicking little flags which are located at some point on the page - AND ITS NOT WORKING.

Clicking on the flag triggers a PHP script which basically says

Code: [Select]

]$_SESSION['lang'] = <Some_language>;
require ('webpage.php');


where webpage.php is the dynamic page, in different languages, with it's content drawn out from a database (which contains the content in all languages I chose to display, blah, blah)
Funny thing - when I look at the page html (View Page Source) - it seems OK (identical from one page to the next) ! But WHAT is displayed after the first attempt to change the language is not.
Is something fundamentally wrong with my approach ?

Mike

What is the best function to use to ensure an order is not re-entered when the user selects reload page? I can link code if you'd like but I'm only looking for a direction to go in and search google with. 'reload current page inserts extra' that google search hasn't been fruitful.

Currently, I'm trying to write a contact form, and perhaps I'm overcomplicating it, but I have a public variable called $EquationAnswer that stores the answer to the Captcha method (randomised maths question) and whenever the page reloads, it creates a new instance of the Contact class, which then erases the value that has been stored in that variable.   What I'm trying to achieve is keeping the value stored even after a new instantiation of the class. I remember from a class at University that static was a way to do this, but this was in C#.

<?php

class Contact
{
	public $EquationAnswer;

	public function CaptchaCreation()
	{
		$SignArray = array('+', '&times;', '-');

		$NumberOne = rand(1, 9);
		$NumberTwo = rand(1, 4);

		if($NumberOne < $NumberTwo)
			$SignIndex = rand(0, 1);
		else
			$SignIndex = rand(0, 2);

		$Sign = $SignArray[$SignIndex];

		$EquationString = $NumberOne." ".$Sign." ".$NumberTwo;

		switch($Sign)
		{
			case "+":
				$Answer = $NumberOne + $NumberTwo;
				break;
			case "-":
				$Answer = $NumberOne - $NumberTwo;
				break;
			case "&times;":
				$Answer = $NumberOne * $NumberTwo;
				break;
		}

		$this->EquationAnswer = $Answer;

		return $EquationString;
	}

	public function EchoContactForm()
	{
		$CaptchaMessage = $this->CaptchaCreation();

		echo "<form method='POST' action=''>\n\n";
		echo "\t\t\t\t\t<table>\n\n";
		echo "\t\t\t\t\t\t<tr><td>Name: </td><td><input type='text' name='name' /></td></tr>\n";
		echo "\t\t\t\t\t\t<tr><td>Email: </td><td><input type='text' name='email' /></td></tr>\n";
		echo "\t\t\t\t\t\t<tr><td>Subject: </td><td><input type='text' name='subject' /></td></tr>\n";
		echo "\t\t\t\t\t\t<tr><td>Message: </td><td><textarea rows=5 name='message'></textarea></td></tr>\n";
		echo "\t\t\t\t\t\t<tr><td>What is: ".$CaptchaMessage."?</td><td><input type='text' name='captcha' /></td><td></td></tr>\n";
		echo "\t\t\t\t\t\t<tr><td colspan=2 style='text-align: right'><input type='submit' name='submit' value='Send' /></td></tr>\n\n";
		echo "\t\t\t\t\t</table>\n\n";
		echo "\t\t\t\t</form>\n";
	}

	public function ContactFormValidation($Name, $Email, $Subject, $Message, $CaptchaInput, $CaptchaAnswer)
	{
		echo $CaptchaAnswer;

		$ErrorsArray = array();

		if(strlen($Name) == 0)
			array_push($ErrorsArray, "You must provide a name.");
		if(strlen($Email) == 0)
			array_push($ErrorsArray, "You must provide an email.");
		if(strlen($Message) == 0)
			array_push($ErrorsArray, "You must provide a message.");
		if(strlen($CaptchaInput) == 0)
			array_push($ErrorsArray, "You must provide an answer to the maths question.");
		if($CaptchaInput != $CaptchaAnswer)
			array_push($ErrorsArray, "Incorrect captcha answer.");

		if(count($ErrorsArray) > 0)
		{
			echo "There are ".count($ErrorsArray)." Errors: <br />";

			foreach($ErrorsArray as $E)
				echo $E."<br />";
		}
		else
		{
			return true;
		}
	}
}

?>

^ That's the Contact class, and the main function that I want to focus on is the last one, "ContactFormValidation()".   From the contact form page (which is within a template), I want it to send the EquationAnswer variable to that function so that it can compare what the user has input.

<?php

//Instantiate the contact class
include './inc/PHP/classes/ContactClass.php';
$ContactClass = new Contact;

if(!isset($_POST['submit']))
{
	$ContactClass->EchoContactForm();
}
else
{
	$NameInput = $_POST['name'];
	$EmailInput = $_POST['email'];
	$SubjectInput = $_POST['subject'];
	$MessageInput = $_POST['message'];
	$CaptchaInput = $_POST['captcha'];
	$CaptchaAnswer = $ContactClass->EquationAnswer;

        //Tried echoing out what is in the variable but it produces nothing because the contact class is a new instance.
	//echo $CaptchaAnswer;

	if($ContactClass->ContactFormValidation($NameInput, $EmailInput, $SubjectInput, $MessageInput, $CaptchaInput, $CaptchaAnswer) == true)
	{
		//Mail function
	}
}

?>

Any help would be appreciated.   Cheers.

I'm trying to show the same data, but updated right away. For example. I want to update my coords on a map and refresh a div to show the new data, but as the code now, it keeps the same data until I reload the page. Here is the code I have now.


if ($north)
{
$ylocation = $users['y'] + 1;
if ($ylocation > 5)
{
$ylocation = 0;
}
$locationyupdate = ("UPDATE players SET y = '$ylocation' WHERE name='$users[name]'");
mysql_query($locationyupdate) or die("could not register");?>
<script type="text/javascript">
$('#npc').load('npc.php');
$('#description').load('description.php');
</script><?}

The update code is before the reload script for the two div's. The data DOES change in the database, but the two div's won't display the new data until it is refreshed again.

Do I need to reactivate fetch to get the new data?

This topic has been moved to Ajax Help.

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

This topic has been moved to Ajax Help.

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

This topic has been moved to Ajax Help.

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

Guys thanks for helping me solve the problem i had but now i have another problem and i am lost. i have included the code below for you to have overview.

On the home page the url shows how it should be: http://localhost/board/italian.php?country=Italian
BUT 
When you mouse over the NEXT link to go to next page you get this : http://localhost/board/?page=1&country=Italian  and then an error 404 when you click on the link
page = 1  no matter if you are mousing over link for page 5 or 2

This is the code:

<table style="width:100%; margin-left:auto; margin-right:auto">
        <?php    
            
            $items_per_page = 5;//how many records/rows to display per page
                        
            $page_url      = "http://".$_SERVER['HTTP_HOST'].$_SERVER['REQUEST_URI'];
                                    
            $cleaned_current_page_country = htmlspecialchars($_GET["country"]);
                        
            $page_number = (isset($_GET['page']))? filter_var($_GET['page']) : 1;
            //$page_number = filter_var($_GET['page']);
            //$page_number = $_GET['page'];
                
            $selected_restaurant_type = $_GET['country'];
                                                            
            // find number of rows in the db
                $query = "SELECT * FROM menu_update WHERE special_of_theday = 1 AND restaurant_type = '".$selected_restaurant_type."' ";
                $query_result = mysqli_query($connection, $query); 
                $row_count = mysqli_fetch_array($query_result);
                $total_rows = mysqli_num_rows($query_result);
                                                
            $expected_number_of_pages = ceil($total_rows/$items_per_page); //expected number of pages 
                                                
            $page_position = (($page_number - 1) * $items_per_page); //get starting position to fetch record
                        
            //fetch a group of records using sql LIMIT clause
                $query = "SELECT * FROM menu_update WHERE special_of_theDay = 1 AND restaurant_type = '".$selected_restaurant_type."' LIMIT " .$page_position. ',' .$items_per_page;
                $query_result = mysqli_query($connection, $query);
        ?>
                        
            <table width="100%" border=0>
                <tr bgcolor = "#cccccc">
                    <td>Meal</td>
                    <td>Meal name</td>
                    <td>Meal Price</td>
                    <td>Order Now</td>
                    <td>Full Menu</td>
                    <td>Our Gallery</td>
                    <td>Find Us</td>
                    <td>Our Chef</td>
                    <td>Our Manager</td>
                </tr>
        <?php
                while($row_count = mysqli_fetch_array($query_result)){
                    echo "<tr>";
                        echo"
                            <td style ='width:200px; text-align:center; height:120px; background:#eaedf2'><a href='meal_fullPic.php'><img src= ".$row_count['img']." /></a></td>
                            <td style ='width:119px; text-align:center; height:120px; background:#eaedf2'> ".$row_count['meal_name']."</td>
                            <td style ='width:100px; text-align:center; height:120px; background:#eaedf2'>".$row_count['price']."</td>
                            <td style ='width:100px; text-align:center; height:120px; background:#eaedf2'><a href='order_processor.php'><img src= ".$row_count['order_now']." /></a></td>
                            <td style ='width:100px; text-align:center; height:120px; background:#eaedf2'><a href='full_menu.php'><img src= ".$row_count['full_menu_img']." /></a></td>
                                    
                            <td style ='width:170px; text-align:center; height:120px; background:#eaedf2'><a href='restaurant_gallery.php'><img src= ".$row_count['restaurant_pic']." /></a></td>
                            <td style ='width:100px; text-align:center; height:120px; background:#eaedf2'><a href='restaurant_location.php'><img src= ".$row_count['location_pic']." /></a></td>
                            <td style ='width:119px; height:120px; background:#eaedf2'> ".$row_count['chef_name']."</td>
                            <td style ='width:119px; height:120px; background:#eaedf2'> ".$row_count['admin']."</td>
                        "; 
                    echo "</tr>";
                }
                mysqli_close($connection);
        ?>    
            </table>
        <div class="board_pagination">
        <?php
            //display the links to the pages
            for($current_page = 1; $current_page <= $expected_number_of_pages; $current_page++){
                 if ($page_number != $expected_number_of_pages){
                    $data = array(
                        'page' => $page_number,
                        'country' => $cleaned_current_page_country,
                    );
                    $the_query = http_build_query($data);
                    $page_url .= '?' . $the_query;
                    echo '<li><a href=" '.$the_query.' ">'.$current_page.'</a></li> ';
                }
            }
        ?>
        </div>
    </table>
 

I do not receive email for my published php file which is:

<?php

///// easend.php /////

$youremail = "acdelco40108@yahoo.com"; /*put the email address here, between quotes,
the email address you want the message sent to*/

$to = $youremail;
$email = $_POST['EMail'];
$name2 = $_POST['Name'];
$street2 = $_POST['Street'];
$city2 = $_POST['City'];
$state2 = $_POST['State'];
$zip2 = $_POST['Zip'];
$Phone = $_POST['Home_Phone'];
$Cell = $_POST['Cell_Phone'];
$education = $_POST['email1'];
$comments = $_POST['email2'] ;

$headers = "From:" . $email;

$fields = array();
$fields{"Name"} = "Name";
$fields{"Street"} = "Street";
$fields{"City"} = "City";
$fields{"State"} = "State";
$fields{"Zip"} = "Zip";
$fields{"Home_Phone"} = "Home Phone";
$fields{"Cell_Phone"} = "Cell Phone";
$fields{"EMail"} = "Email";
$fields{"email1"} = "Education";
$fields{"email2"} = "Comments";

$subject = "We have received the following information from your employment application";
$body = "We have received the following information from your employment application:\n\n"; foreach($fields as $a => $b)
{ $body .= sprintf("%20s: %s\n",$b,$_POST[$a]); }

mail ($to, $subject, $body, $headers); //send mail to owner
#end create email vars

$headers = "From:" . $to;

mail ($email, $subject, $body, $headers); //send mail to user
#end create email vars

echo "<head><META HTTP-EQUIV=\"Refresh\" CONTENT=\"2;
URL=ThankYou.html\"></head>";

?>

Hows it going guys.

I am currently having a problem. I had a program that worked. I migrated the website and now the program is broken.

Any time i try to run it, i get this error:

Quote

Warning: mysql_fetch_array() expects parameter 1 to be resource, boolean given in /home/thegoo20/public_html/class/wordgame/wordgame.php on line 31



Here is the code at that point:

Code: [Select]
function changeword(){
  $result = mysql_query("Select words from CurrentWords");
  $totalwords = array();
 
   while ($row = mysql_fetch_array($result)){
      $totalwords[] = $row["words"];
   }
  $_SESSION['word'] = $totalwords[rand(0, count($totalwords)-1)];
 
  $_SESSION['scrambled'] = str_shuffle($_SESSION['word']);
 
 
}

where line 31 is the while statement.

Any help would be appreciated.

Thanks

Hi,
i use mysql_real_escape_string() function when insert in db, but when echo i use htmlentities($var, ENT_QUOTES, "UTF-8")
Now problem is '\ in that text.

In db it write text with single quote with \, example That\'s wrong, and when echo it show just the same like in db..
How can i fix this ?

I have having a problem getting a mysql query to work.

If I just use mysql_query it looks like this and works fine:
INSERT INTO schedule (schedule_pk, schedule_month, schedule_day, schedule_year, schedule_hour, schedule_minute, schedule_type, employeenumber) VALUES ( NULL, 10, 10, 1999, 12, 6, 'DayIn', 3);

If I put it through mysql_real_escape_string it turns it to this and does not work when I put it into mysql_query:
INSERT INTO schedule (schedule_pk, schedule_month, schedule_day, schedule_year, schedule_hour, schedule_minute, schedule_type, employeenumber) VALUES ( NULL, 10, 10, 1999, 12, 6, \'DayIn\', 3);

aka:
$query = "INSERT INTO...."
mysql_query($query);

that works, but:
$query = "INSERT INTO...."
$sqlQuery = mysql_real_escape_string($query, $con);
mysql_query($sqlQuery);

results in the error.
mysql_query($query);


The error is:
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 '\'DayIn\', 3)' at line 1

Okey so i made a table that you put your name,author,and message

when you submit it , it echoes a table with the name,author and message written  (and it also echoes a delete buttom,so delete this post oif necessary)


im new to php and i have been with this problem for a couple of weeks so i guess its time to ask for some help

the problem is that i dunnot know how to make my delete buttom work! i tried if statement but it dosent work i also tried ternary operation and dint work :S

i read that there is  something like $post[ID](and this is supposed to get the ID of the post submmited, and delete it) im not sure, im so confused! help! XD

this is the code



<?php 

$tittle=$_POST['tittle'];
$author=$_POST['author'];
$message=$_POST['message'];

if ($_POST['submitnews']){



$currentdate= date("y-m-d");
$currenttime=date("H:i:s",strtotime("-6 hours"));

$post=mysql_query("INSERT INTO news VALUES('','$tittle','$author','$message','$currentdate','$currenttime')");
echo"Posted!";

}




$select=mysql_query("SELECT * FROM news ORDER BY id DESC");

while ($row= mysql_fetch_assoc($select))

{
$id=$row['id'];
$tittle=$row['tittle'];
$author=$row['author'];
$message=$row['message'];
$date=$row['date'];
$time=$row['time'];



if ($_SESSION['admin'])

{

echo "


<table width='488px' id='news_table'>
<tr>
<td>
</td>
<td>
<center><font size='5'>$tittle</font></center><br>
</td>
</tr>
<tr>
<td>
</td>
<td>
$message
</td>
</tr>
<tr>
<td>
</td>
<td>
<font size='1'>Posted By:<font color='green'>$author</font> on <font color='gray'>$date</font> at <font color='gray'>$time</font></font>
<input name='delete' type='submit' value='delete'>
<td>
</td>
</tr><br><br>
</table>";