Learn VBA & Macros in 1 Week!

PHP - Executing Form And Staying On The Same Page?

Full Excel VBA Course - Beginner to Expert

Executing Form And Staying On The Same Page?	View Content

Looking to INSERT a row in a data table and keeping the User on the current page.

Will it work like what I have below, or do I need to send it to its own page then return the User back to where he started?

What I have below isn't inserting a row. No errors showing.

function bookmark_add () {

if (isset($_POST['submit'])) {

include("/home2/csi/public_html/resources/con.php");


	$query = "INSERT INTO a_player_bookmark (bookmark)
				VALUES ('1')";
	
	$results = mysqli_query($con,$query);
	echo mysqli_error($con);


}

	$output = '<form name="bookmark_add" method="post" action="" class="bookmark-plus">';
    $output .= '<span><input type="submit" name="Bookmark"></span>';
	$output .= '</form>';
	
	return $output;	



}

Full Excel VBA Course - Beginner to Expert

Php Ordering Form Help Please. Variables Staying The Same After Submit

Similar Tutorials

View Content

So I'm making an ordering form for pizza, and it works fine and im using two separate pages: 1- display the form where the user can select the pizza, and 2-display the order and the price, and user can go back and edit

the problem im having is when i got back from the 2nd page to the 1st page, to edit the data, I want the variables to stay the same. For example, if the user selected a medium cheese pizza, i want the values of cheese and pizza to still be there, so the user doesnt have to fill the entire form out again.

ive done this before, but now when i try it doesn''t work and Ive tried everything. Thanks in advance

If the code is needed, I'll post it here
Code: [Select]
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Frameset//EN" "http://www.w3.org/TR/html4/frameset.dtd">
<html>
<head>
<title>Title of the document</title>
<meta name="description" content="Type a Short Description Here" />
<meta name="keywords" content="type, keywords, here" />
<meta name="author" content="Your Name" />
<meta http-equiv="content-type" content="text/html;charset=UTF-8" />
<link rel="stylesheet" type="text/css" href="mystyle.css" />
</head>

<body>
<?php

print_r ($_REQUEST) ;

if(isset($_POST['ORDER'])) {
$ORDER = $_POST['ORDER'];
}
if(isset($_POST['PTYPE'])) {
$PTYPE = $_POST['PTYPE'];
}
if(isset($_POST['DTYPE'])) {
$DTYPE = $_POST['DTYPE'];
}
if(isset($_POST['PSIZE'])) {
$PSIZE = $_POST['PSIZE'];
}
if(isset($_POST['DSIZE'])) {
$DSIZE = $_POST['DSIZE'];
}
if(isset($_POST['PTYPE2'])) {
$PTYPE2 = $_POST['PTYPE2'];
}
if(isset($_POST['DTYPE2'])) {
$DTYPE2 = $_POST['DTYPE2'];
}
if(isset($_POST['PSIZE2'])) {
$PSIZE2 = $_POST['PSIZE2'];
}
if(isset($_POST['DSIZE2'])) {
$DSIZE2 = $_POST['DSIZE2'];
}
if(isset($_POST['PTYPE3'])) {
$PTYPE3 = $_POST['PTYPE3'];
}
if(isset($_POST['DTYPE3'])) {
$DTYPE3 = $_POST['DTYPE3'];
}
if(isset($_POST['PSIZE3'])) {
$PSIZE3 = $_POST['PSIZE3'];
}
if(isset($_POST['DSIZE3'])) {
$DSIZE3 = $_POST['DSIZE3'];
}

echo "Order Type: <br/> \n";
echo"<form method='post' action='project2.php'>";

}if ($ORDER=='delivery') {
$DEL='checked' ;
}elseif ($ORDER=='takeout') {
$TAKE='checked';
}elseif ($ORDER=='eatin') {
$EAT='checked';
}

echo"Delivery <input type='radio' name='ORDER' value='delivery' $DEL> \n";
echo"Take Out <input type='radio' name='ORDER' value='takeout' $TAKE> \n";
echo"Eat in <input type='radio' name='ORDER' value='eatin' $EAT> \n";

if ($PTYPE==='no pizza') {
$NOPIZZA='selected' ;
}elseif ($PTYPE=='cheese') {
$CHEESE='selected' ;
}elseif ($PTYPE=='pepporoni') {
$PEPPORONI='selected' ;
}elseif ($PTYPE=='veggie') {
$VEGGIE='selected' ;
}elseif ($PTYPE=='meat lovers') {
$MEAT='selected' ;
}

echo $CHEESE ;

echo"<br/>Pizza: <select name='PTYPE'>\n";
echo"<option></option>";
echo"<option $NOPIZZA>no pizza</option>";
echo"<option $CHEESE>cheese</option>";
echo"<option $PEPPORONI>pepporoni</option>";
echo"<option $VEGGIE>veggie</option>";
echo"<option $MEAT>meat lovers</option>";
echo"</select> ";

$SMALL='selected' ;

if (isset ($_POST['PSIZE']) && ($PSIZE=='Small')) {
$SMALL='selected' ;
}elseif (isset ($_POST['PSIZE']) && ($PSIZE=='Medium')) {
$MEDIUM='selected' ;
}elseif (isset ($_POST['PSIZE']) && ($PSIZE=='Large')) {
$LARGE='selected' ;
}

echo "$SMALL";

echo"    Pizza size: <select name='PSIZE'>\n";
echo"<option></option>";
echo"<option $SMALL>Small</option>";
echo"<option $MEDIUM>Medium</option>";
echo"<option $LARGE>Large</option>";
echo"</select>";

echo"<br/>Pizza2: <select name='PTYPE2'>\n";
echo"<option></option>";
echo"<option >no pizza</option>";
echo"<option >cheese</option>";
echo"<option >pepporoni</option>";
echo"<option >veggie</option>";
echo"<option >meat lovers</option>";
echo"</select> ";

echo"    Pizza size2: <select name='PSIZE2'>\n";
echo"<option></option>";
echo"<option>Small</option>";
echo"<option>Medium</option>";
echo"<option>Large</option>";
echo"</select>";

echo"<br/>Pizza3: <select name='PTYPE3'>\n";
echo"<option></option>";
echo"<option >no pizza</option>";
echo"<option >cheese</option>";
echo"<option >pepporoni</option>";
echo"<option >veggie</option>";
echo"<option >meat lovers</option>";
echo"</select> ";

echo"Pizza size3: <select name='PSIZE3'>\n";
echo"<option></option>";
echo"<option>Small</option>";
echo"<option>Medium</option>";
echo"<option>Large</option>";
echo"</select>";

echo"</br> <br/>What drink would you like? <select name='DTYPE'>";
echo"<option></option>";
echo"<option>No drink</option>";
echo"<option>Bottled Pepsi</option>";
echo"<option>Bottled Fanta</option>";
echo"<option>Bottled Sprite</option>";
echo"<option>Bottled RootBeer</option>";
echo"</select>";

echo"Drink size: <select name='DSIZE'>";
echo"<option></option>";
echo"<option>.5 liter</option>";
echo"<option>1 liter</option>";
echo"<option>2 liter</option>";
echo"</select>";

echo"</br> <br/>What second drink would you like? <select name='DTYPE2'>";
echo"<option></option>";
echo"<option>No drink</option>";
echo"<option>Bottled Pepsi</option>";
echo"<option>Bottled Fanta</option>";
echo"<option>Bottled Sprite</option>";
echo"<option>Bottled RootBeer</option>";
echo"</select>";

echo"Drink size2: <select name='DSIZE2'>";
echo"<option></option>";
echo"<option>.5 liter</option>";
echo"<option>1 liter</option>";
echo"<option>2 liter</option>";
echo"</select>";

echo"</br> <br/>What third drink would you like? <select name='DTYPE3'>";
echo"<option></option>";
echo"<option>No drink</option>";
echo"<option>Bottled Pepsi</option>";
echo"<option>Bottled Fanta</option>";
echo"<option>Bottled Sprite</option>";
echo"<option>Bottled RootBeer</option>";
echo"</select>";

echo"Drink size3: <select name='DSIZE3'>";
echo"<option></option>";
echo"<option>.5 liter</option>";
echo"<option>1 liter</option>";
echo"<option>2 liter</option>";
echo"</select>";

echo"<br/> <br/> <input type='submit' value='submit your order' name='submit'>";
echo"</form>";

?>
</body>
</html>
and the second page
Code: [Select]
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Frameset//EN" "http://www.w3.org/TR/html4/frameset.dtd">
<html>
<head>
<title>Title of the document</title>
<meta name="description" content="Type a Short Description Here" />
<meta name="keywords" content="type, keywords, here" />
<meta name="author" content="Your Name" />
<meta http-equiv="content-type" content="text/html;charset=UTF-8" />
<link rel="stylesheet" type="text/css" href="mystyle.css" />
</head>

<body>
<?php

print_r ($_REQUEST) ;

$ORDER = $_POST['ORDER'];
$PTYPE = $_POST['PTYPE'];
$DTYPE = $_POST['DTYPE'];
$PSIZE = $_POST['PSIZE'];
$DSIZE = $_POST['DSIZE'];
$PTYPE2 = $_POST['PTYPE2'];
$DTYPE2 = $_POST['DTYPE2'];
$PSIZE2 = $_POST['PSIZE2'];
$DSIZE2 = $_POST['DSIZE2'];
$PTYPE3 = $_POST['PTYPE3'];
$DTYPE3 = $_POST['DTYPE3'];
$PSIZE3 = $_POST['PSIZE3'];
$DSIZE3 = $_POST['DSIZE3'];

if (($PTYPE=='cheese')and($PSIZE=='Small')) {
$PCOST=10 ;
}elseif (($PTYPE=='cheese')and($PSIZE=='Medium')) {
$PCOST=13 ;
}elseif (($PTYPE=='cheese')and($PSIZE=='Large')) {
$PCOST=15 ;
}elseif (($PTYPE=='pepporoni')and($PSIZE=='Small')) {
$PCOST=12 ;
}elseif (($PTYPE=='pepporoni')and($PSIZE=='Medium')) {
$PCOST=14 ;
}elseif (($PTYPE=='pepporoni')and($PSIZE=='Large')) {
$PCOST=16 ;
}elseif (($PTYPE=='veggie')and($PSIZE=='Small')) {
$PCOST=12 ;
}elseif (($PTYPE=='veggie')and($PSIZE=='Medium')) {
$PCOST=14 ;
}elseif (($PTYPE=='veggie')and($PSIZE=='Large')) {
$PCOST=16 ;
}elseif (($PTYPE=='meat lovers')and($PSIZE=='Small')) {
$PCOST=13 ;
}elseif (($PTYPE=='meat lovers')and($PSIZE=='Medium')) {
$PCOST=15 ;
}elseif (($PTYPE=='meat lovers')and($PSIZE=='Large')) {
$PCOST=17;
}else {
$PCOST=0 ;
}

if (($PTYPE2=='cheese')and($PSIZE2=='Small')) {
$PCOST2=10 ;
}elseif (($PTYPE2=='cheese')and($PSIZE2=='Medium')) {
$PCOST2=13 ;
}elseif (($PTYPE2=='cheese')and($PSIZE2=='Large')) {
$PCOST2=15 ;
}elseif (($PTYPE2=='pepporoni')and($PSIZE2=='Small')) {
$PCOST2=12 ;
}elseif (($PTYPE2=='pepporoni')and($PSIZE2=='Medium')) {
$PCOST2=14 ;
}elseif (($PTYPE2=='pepporoni')and($PSIZE2=='Large')) {
$PCOST2=16 ;
}elseif (($PTYPE2=='veggie')and($PSIZE2=='Small')) {
$PCOST2=12 ;
}elseif (($PTYPE2=='veggie')and($PSIZE2=='Medium')) {
$PCOST2=14 ;
}elseif (($PTYPE2=='veggie')and($PSIZE2=='Large')) {
$PCOST2=16 ;
}elseif (($PTYPE2=='meat lovers')and($PSIZE2=='Small')) {
$PCOST2=13 ;
}elseif (($PTYPE2=='meat lovers')and($PSIZE2=='Medium')) {
$PCOST2=15 ;
}elseif (($PTYPE2=='meat lovers')and($PSIZE2=='Large')) {
$PCOST2=17;
}else {
$PCOST2=0 ;
}

if (($PTYPE3=='cheese')and($PSIZE3=='Small')) {
$PCOST3=10 ;
}elseif (($PTYPE3=='cheese')and($PSIZE3=='Medium')) {
$PCOST3=13 ;
}elseif (($PTYPE3=='cheese')and($PSIZE3=='Large')) {
$PCOST3=15 ;
}elseif (($PTYPE3=='pepporoni')and($PSIZE3=='Small')) {
$PCOST3=12 ;
}elseif (($PTYPE3=='pepporoni')and($PSIZE3=='Medium')) {
$PCOST3=14 ;
}elseif (($PTYPE3=='pepporoni')and($PSIZE3=='Large')) {
$PCOST3=16 ;
}elseif (($PTYPE3=='veggie')and($PSIZE3=='Small')) {
$PCOST3=12 ;
}elseif (($PTYPE3=='veggie')and($PSIZE3=='Medium')) {
$PCOST3=14 ;
}elseif (($PTYPE3=='veggie')and($PSIZE3=='Large')) {
$PCOST3=16 ;
}elseif (($PTYPE3=='meat lovers')and($PSIZE3=='Small')) {
$PCOST3=13 ;
}elseif (($PTYPE3=='meat lovers')and($PSIZE3=='Medium')) {
$PCOST3=15 ;
}elseif (($PTYPE3=='meat lovers')and($PSIZE3=='Large')) {
$PCOST3=17;
}else {
$PCOST3=0 ;
}

if((($DTYPE=='Bottled Pepsi')or($DTYPE=='Bottled Fanta')or($DTYPE=='Bottled Sprite')or($DTYPE=='Bottled RootBeer'))and($DSIZE=='.5 liter')) {
$DCOST=.69 ;
}elseif((($DTYPE=='Bottled Pepsi')or($DTYPE=='Bottled Fanta')or($DTYPE=='Bottled Sprite')or($DTYPE=='Bottled RootBeer'))and($DSIZE=='1 liter')) {
$DCOST=.99 ;
}elseif((($DTYPE=='Bottled Pepsi')or($DTYPE=='Bottled Fanta')or($DTYPE=='Bottled Sprite')or($DTYPE=='Bottled RootBeer'))and($DSIZE=='2 liter')) {
$DCOST=1.69 ;
}elseif($DTYPE=='No drink'){
$DCOST=0 ;
}

if((($DTYPE2=='Bottled Pepsi')or($DTYPE2=='Bottled Fanta')or($DTYPE2=='Bottled Sprite')or($DTYPE2=='Bottled RootBeer'))and($DSIZE2=='.5 liter')) {
$DCOST2=.69 ;
}elseif((($DTYPE2=='Bottled Pepsi')or($DTYPE2=='Bottled Fanta')or($DTYPE2=='Bottled Sprite')or($DTYPE2=='Bottled RootBeer'))and($DSIZE2=='1 liter')) {
$DCOST2=.99 ;
}elseif((($DTYPE2=='Bottled Pepsi')or($DTYPE2=='Bottled Fanta')or($DTYPE2=='Bottled Sprite')or($DTYPE2=='Bottled RootBeer'))and($DSIZE2=='2 liter')) {
$DCOST2=1.69 ;
}elseif($DTYPE2=='No drink'){
$DCOST2=0 ;
}

if((($DTYPE3=='Bottled Pepsi')or($DTYPE3=='Bottled Fanta')or($DTYPE3=='Bottled Sprite')or($DTYPE3=='Bottled RootBeer'))and($DSIZE3=='.5 liter')) {
$DCOST3=.69 ;
}elseif((($DTYPE3=='Bottled Pepsi')or($DTYPE3=='Bottled Fanta')or($DTYPE3=='Bottled Sprite')or($DTYPE3=='Bottled RootBeer'))and($DSIZE3=='1 liter')) {
$DCOST3=.99 ;
}elseif((($DTYPE3=='Bottled Pepsi')or($DTYPE3=='Bottled Fanta')or($DTYPE3=='Bottled Sprite')or($DTYPE3=='Bottled RootBeer'))and($DSIZE3=='2 liter')) {
$DCOST3=1.69 ;
}elseif($DTYPE3=='No drink'){
$DCOST3=0 ;
}

$TOTAL=($PCOST+$PCOST3+$PCOST3+$DCOST+$DCOST2+$DCOST3) ;

echo "<br/><br/>Your Order is:<br/>" ;
echo " $PSIZE $PTYPE ($PCOST),$PSIZE2 $PTYPE2 ($PCOST2),$PSIZE3 $PTYPE3 ($PCOST3),  <br/>" ;
echo " $DSIZE $DTYPE ($DCOST),$DSIZE2 $DTYPE2 ($DCOST2),$DSIZE3 $DTYPE3 ($DCOST3), <br/> <br/>" ;
echo"<br/><br/>Your total price is: $TOTAL <br/> <br/>";

if ($ORDER=='delivery') {
echo"Please enter the information required for delivery <br/>" ;
echo "Address: <input type=text><br/>";
echo "City: <input type=text><br/>";
echo "Zip Code: <input type=text><br/>";
} elseif ($ORDER=='takeout') {
echo "Your order will be ready for pickup in 30 min";
} elseif ($ORDER=='eatin') {
echo "Your order will be ready in 30 min";
}

echo"<form action=asdf.php>";
echo"<br/> <input type=submit value='confirm this order'>";
echo"</form>";

echo "<form action=project.php>";
echo "<br/> <br/><input type=submit value='edit this order'>";
echo "<input type='hidden' name='ORDER' value='$ORDER'>";
echo "<input type='hidden' name='PTYPE' value='$PTYPE'>";
echo "<input type='hidden' name='PTYPE2' value='$PTYPE2'>";
echo "<input type='hidden' name='PTYPE3' value='$PTYPE3'>";
echo "<input type='hidden' name='PSIZE' value='$PSIZE'>";
echo "<input type='hidden' name='PSIZE2' value='$PSIZE2'>";
echo "<input type='hidden' name='PSIZE3' value='$PSIZE3'>";
echo "<input type='hidden' name='DTYPE' value='$DTYPE'>";
echo "<input type='hidden' name='DTYPE2' value='$DTYPE2'>";
echo "<input type='hidden' name='DTYPE3' value='$DTYPE3'>";
echo "<input type='hidden' name='DSIZE' value='$DSIZE'>";
echo "<input type='hidden' name='DSIZE2' value='$DSIZE2'>";
echo "<input type='hidden' name='DSIZE3' value='$DSIZE3'>";
echo "</form>";

?>
</body>
</html>

Php Authentication Page Executing Without Being Called

Similar Tutorials

View Content

Hello all, I have been working with PHP for almost a year now, so somewhat still new to it all.

OK, this may be an Apache issue, but this involves a php script I wrote that tries to execute on pages that do NOT call it (via the include command).

So, here is a little info on how I have set things up.

I use WAMP Server to test php and MySQL code for myself (for fun and for practice) and for clients and their web sites. I run WAMP Server off of my laptop, so I can code on the go and because it is on my laptop, I decided to create a PHP & MySQL user authentication setup to keep out unwanted visitors, but allow trusted friends and fellow developers to view my work on client web sites. Let's say the authentication script is called "auth.php" and for all of the pages I want private, I include that script at the top of those pages, if the visitor is not logged in, redirect them to the login page, otherwise, let them view the page (provided their permission level is adequate).

Now, for the client web sites that I am working on, I do not call auth.php anywhere on those pages. Now, the problem I notice is that when I visited a client's web site that I am working on (on my WAMP Server), I reviewed my Apache error log and it gave me a PHP error stating the following:

Code: [Select]
Maximum execution time of 60 seconds exceeded in E:\\wamp\\www\\assets\\auth.php on line 3, referer: http://192.168.1.4/Web_Projects/NCCCLP/home.php
Of course I am able to view the client web site pages without having to login, however, the auth.php script tries to run nonetheless.

So my question is, does anyone know why this is happening and if and how I can stop it? This is not a serious (urgent) issue, but it does clog up my error logs and so forth and I prefer to have as few errors as possible. Plus, I would just like to know why and how it is running without being called.

Any and all help is greatly appreciated and if I need to provide anymore details or be more specific, please let me know.
Also, if an issue like this has already been solved and I missed that thread, please let me know and have my apologies.

Thanks in advance.

Executing A Query Without Page Reloading

Similar Tutorials

View Content

hey guys im sure this is possible im wondering how a user can execute a mysql query by a click of a button but without the page reloading...thanks guys

Displaying The Next Record On Web Page Without Executing Query Again

Similar Tutorials

View Content

What is the best way to display the next record on a web page, from a list of records, without executing the query over and over again each time you display the next record?

For example, imagine my user has a list of messages displayed on a web page, and the user filters that list to display all messages with the title "Test", and let's say that returns 12 records.

He then clicks on record 1 to read that message. Once he is done reading it, he then wants to read msg 2, and then msg 3 etc.

He could hit the Back button in his browser and click on the next record from the list, but it would be more useful to just click on a link that says "Next" which displays the next message in the filtered list of messages (without having to go back to the list).

A lot of web sites do this sort of thing, but what is the best way to do it? Do you have to run the original query again each time a new message is loaded, so you know which message is next, or can you somehow store the query to save the server from having to run the same query over and over again?

If a user is viewing a list of pictures for example, they could be flicking through the pictures quite quickly, and I would not like to have the server running the same query over and over again every few seconds when it doesn't need to.

Advice? (Thanks.)

Re-executing Mysql Query After Submission - Two Forms One Page

Similar Tutorials

View Content

Hi, I know this has to be possible but I have been unable to get this to work properly.

I have a page with two forms. The first form is a list of sources associated with a subject, with checkboxes, so that it is possible to remove these associations, like so:

Code: [Select]
$qs = "SELECT s.source_id, s.source_name
from source s, source_subject ss, subject sb
where s.source_id = ss.source_id
and sb.subject_id = ss.subject_id
and sb.subject_id = $subject_id
order by source_name";
$rs = mysqli_query($dbc, $qs)
or die ('Error querying database');

while($row = mysqli_fetch_array($rs)) {

echo '<input type="checkbox" value="' . $row['source_id'] . '" name="markdelete[]">' . $row['source_name'] . '<br />' ;

}

The second form is a list of sources that are not associated with this subject, with checkboxes enabling the addition of more sources to this subject, like so:

Code: [Select]
$r = "SELECT source_id, source_name
FROM source
WHERE source_id NOT IN
(select s.source_id
from source s, source_subject ss
where s.source_id = ss.source_id
and ss.subject_id = '$subject_id')";

$r1 = mysqli_query($dbc, $r)
or die ('Update Error: '.mysqli_error($dbc));

while ($row = mysqli_fetch_array($r1)) {
echo '<input type="checkbox" id="source_id" name="source_id[]" ' ;

echo 'value="'. $row['source_id'] .'"';

echo '> ' . $row['source_name'] . '<br />';

}

The first form works fine... when the "remove" submit button is clicked, it successfully removes any selected sources and then shows the remaining sources still associated, and then automatically populates this source in the below list (form 2) as one that is not selected.

On the second form, when adding a new source to the subject, it successfully enters the data into the database, and removes this source from the list of unselected sources, but it does not seem to re-populate in the first form.

The data is correct on the tables, but the page needs to reload the first query... how do I get it to do this? I'd like to be able to make this page editable, and re-editable (in case someone makes a mistake) without having to go back and reload the entire page.

Note, both forms call the page itself; not sure if this is part of it. Using this:
Code: [Select]
<form method="POST" action="<?php echo $_SERVER['PHP_SELF'].'?subject_id='.$subject_id ; ?>">
Does anyone have any ideas?

Staying Logged In

Similar Tutorials

View Content

Hi guys,

Im building a website for a company http://www.eminence-logistics.co.uk and the client wants a log in system which im having problems with. The registration system is all working fine.

If you go to the website you can see where the login form is.

Now when the user isn't logged in i need the form to show, but when the user IS logged in i would like a message replacing the form saying welcome, along with a log out button.

How do i do this?

Thankyou very much

Enlighten

Login Help: Staying Logged In

Similar Tutorials

View Content

Hi. I'm new to php. I created a register, log in, welcome, and log out page for my site. They are all working accordingly. I'm having one problem that I can't seem to fix. I would like to stay logged in as I navigate other pages of my site. Everytime i click on a link to another page within my site I get logged out. I know this issue might pertain to using session but thats all I was able to find using google search. Can anyone help? Much appreciated.

Moved: Radio Buttons Staying Selected.

Similar Tutorials

View Content

This topic has been moved to HTML Help.

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

My Validation Scripts Are Not Outputting The Errors To My Form Page, I Have Added The Scripts Of The Validation Page And The Form Page

Similar Tutorials

View Content

Executing The Query Once

Similar Tutorials

View Content

I have the following query where $userid is about 100,000 userids separated by commas.

Code: [Select]
<?
$getpostid=mysql_query("SELECT DISTINCT post.username,post.threadid,thread.threadid,thread.forumid from post,thread WHERE post.username='$username' AND post.threadid=thread.threadid AND post.userid IN ($userid) AND thread.forumid IN ($forumids)") or die (mysql_error());
?>can i just print all the usernames from above result separated by ';' without looping it multiple times?

Could someone help me out how to do above in an efficient manner?

Php Don't Stop Executing After $i < 3

Similar Tutorials

View Content

I'm tired and want to sleep so my mistakes are getting lots now. Anybody awake that can explain my problem with the code below.

<?

function directoryToArray($directory, $recursive) {
        $array_items = array();
        $i = "0";
        if ($handle = opendir($directory)) {
                while (false !== ($file = readdir($handle)) && $i < "3") {
                        if ($file != "." && $file != "..") {
                                if (is_dir($directory. "/" . $file)) {
                                        if($recursive) {
                                                $array_items = array_merge($array_items, directoryToArray($directory. "/" . $file, $recursive));
                                        }
                        } else {
                                        $file = $directory . "/" . $file;
                                        $array_items[] = preg_replace("/\/\//si", "/", $file);
                                        $i++;
                                }
                        }
                }
                closedir($handle);
        }
        natsort($array_items);
        return array_reverse($array_items);
}
$data = directoryToArray('images/screenshot/', TRUE);
print_r($data);
?>

What I want is for the while loop to stop after 4 hits and exit and give me the return results. But now it continue until readdir end.

Php Code Not Executing

Similar Tutorials

View Content

I am trying to use some php code inside of an html document and it does not work. I have a script.php file that executes perfectly when I try and use it. Here is the code I am currently using:

Code: [Select]
<?php
echo "<title>";
echo "the Homepage!";
echo "</title>";
?>
Any suggestions would be great.

Executing Elf File With Exec()

Similar Tutorials

View Content

Hey guys!
My current employer contracted someone to create a script for him. (The script itself is to create a serial number for a piece of software) It's just a PHP script that executes a file and retrieves its output.
Now I've never worked with exec() in PHP, and I don't have a reliable environment to test it in. I compiled apache2 and php 5.0.4 and set them to run on a Macintosh (10.3.9) in the office, but I'm sure I've missed some crucial setup stage (mainly, I'm missing php.ini. I did a php -i | grep php.ini to find it, and it says it is in /etc/, but when I look in my PHP/etc folder, only pear.conf is there!). PHP and apache both appear to be working fine, though.

When I try and run the PHP script that executes the .ELF file, I get a blank page. Is this because I'm running it in OS X? should I be running it in Linux?
Also, I don't know how to Enable exec() on my server, or to see if it's enabled. Basically, I just need someone to walk me through the basics of this. The script and executable SHOULD work fine because the contractor got it working fine.
Below is the script, and attached is the executable.
Thanks! :3

<?php

/*
inUID = 456890
inSerialNumUID = 123456
inMachineID_s = &6dA-8P@K-Xsq
*/

$p1 = "456890";
$p2 = "123456";
$p3 = "\&6dA-8P@K-Xsq";

exec("./create_activation_code.elf $p1 $p2 $p3", $output);

foreach ($output as $output_str)
{
echo $output_str."<br>";
}

?>

Calculator Script Not Executing

Similar Tutorials

View Content

Hey there, I recently started working on a PHP calculator, I tryed testing it out and the script is not executing... *NOTE* I found the error, I forgot to assign values to the options, all is good now

Code: [Select]
<?php
/*
Script Created by: Far Cry
Started: August 20th, 2010 10:51 PM PST
Completed
*/

$title = "Calculator";

$form = "<form action='calculator.php' method='POST'>
<table>
    <tr>
    <td><input name='firstnumber' type='text'></td>
</tr>

<tr>
   <td><input name='secondnumber' type='text'></td>
</tr>

<tr>
   <td><select name='operation'>
       <option name='multiply'>*</option>
   </select></td>
</tr>

<tr>
<td><input name='submitbtn' type='submit' value='Calculate!'></td>
</tr>
</table>
</form>";

if ($_POST['submitbtn']){

$first = ($_POST['firstnumber']);
$last = ($_POST['secondnumber']);
$operation = ($_POST['operation']);
}
if ($operation == 'multiply'){
echo"The answer is " . $first * $last . $form;
}
echo $form;
?>
Thanks in advance.

Executing Powershell Script From Php

Similar Tutorials

View Content

Hello,

PowerShell script stored locally can never be executed after I click on button:

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<title>Testing PowerShell</title>
</head>
<body>
<?php
 
// If there was no submit variable passed to the script (i.e. user has visited the page without clicking submit), display the form:
if(!isset($_POST["submit"]))
{
    ?>
    <form name="testForm" id="testForm" action="get-process.php" method="post" />
        Your name: <input type="text" name="username" id="username" maxlength="20" /><br />
        <input type="submit" name="submit" id="submit" value="Do stuff NowNew" />
    </form>
    <?php    
}
// Else if submit was pressed, check if all of the required variables have a value:
elseif((isset($_POST["submit"])) && (!empty($_POST["username"])))
{
   // Display the alert box 
   echo '<script>alert("Welcome to Geeks for Geeks")</script>';
   
   // Get the variables submitted by POST in order to pass them to the PowerShell script:
    $username = $_POST["username"];
    // Best practice tip: We run out POST data through a custom regex function to clean any unwanted characters, e.g.:
    // $username = cleanData($_POST["username"]);
         

$psPath = "C:\\Windows\\SysWOW64\WindowsPowerShell\\v1.0\\powershell.exe";
$psDIR = "C:\\TestNew\\";
$psScript = "pscripta.ps1";
$runScript = $psDIR. $psScript;
$runCMD = $psPath." ".$runScript." 2>&1"; 

echo "\$psPath  $psPath <br>";
echo "\$psDIR  $psDIR <br>";
echo "\$psScript  $psScript <br>";
echo "\$runScript  $runScript <br>";
echo "\$runCMD   $runCMD  <br>";

exec( $runCMD,$out,$ret);

echo "<pre>";
print_r($out);
print_r($ret);
echo "</pre>";

}
// Else the user hit submit without all required fields being filled out:
else
{
    echo "Sorry, you did not complete all required fields. Please go back and try again.";
}
?>
</body>
</html>

Thank you for your help!

Function By Reference Not Executing

Similar Tutorials

View Content

OK, so I have the following file that has database functions:

<?php

function dbDelete($param){
$conDelete = mysql_connect($url,'username','password',true);
mysql_select_db('my_db',$conDelete);
mysql_query($param,$conDelete);
mysql_close();
   if(isset($conDelete)){
   mysql_close($conDelete);
   }
}
?>

I include the above file in a session handling file. But for some reason the new file can't call the above function as follows:
<?php
include_once 'the above stated file';
function timeOut(){
dbDelete("DELETE FROM acctussessi WHERE acctussessi_usid = '$sessius[0]'");
   $_SESSION = array();
   setcookie(session_name(),'',time()-4200);
   session_destroy();
}
//CHECK FOR TIMEOUT REQUEST
switch($_GET['xyz']){
   case 'timeout':
   timeOut();
   header("Location: /?xyz=timedout");
   break;
   case 'logout':
   timeOut();
   header("Location: /?xyz=loggedout");
   break;
   case 'refresh':
   dbUpdate("UPDATE acctussessi SET acctussessi_time = ".time()." WHERE acctussessi_unid ='".$token."'");
   break;
}
?>

dbDelete isn't being called inside of the TimeOut() function. The only way it works is by doing the following:

<?php
function timeOut(){
   $_SESSION = array();
   setcookie(session_name(),'',time()-4200);
   session_destroy();
}
//CHECK FOR TIMEOUT REQUEST
switch($_GET['xyz']){
   case 'timeout':
      dbDelete("DELETE FROM acctussessi WHERE acctussessi_usid = '$sessius[0]'");
   timeOut();
   header("Location: /?xyz=timedout");
   break;
   case 'logout':
      dbDelete("DELETE FROM acctussessi WHERE acctussessi_usid = '$sessius[0]'");
   timeOut();
   header("Location: /?xyz=loggedout");
   break;
   case 'refresh':
      dbUpdate("UPDATE acctussessi SET acctussessi_time = ".time()." WHERE acctussessi_unid ='".$token."'");
   break;
}
?>
But this is annoying and repetitive. What is going on?

Thanks in advance.

Code Not Executing Beyond A Point

Similar Tutorials

View Content

I am playing around with php but the script doesnt execute to the last point and with no error...

What i am trying to do is checking the input of the user and comparing it what is in db and then applying conditions. So i have 2 files. update.php and home.php.

home.php is my html form page and i included 'update.php' in it

In my update.php, i have these codes

<?php

error_reporting(E_ALL);


include_once('database.php');

if(isset($_POST['submit']))

{

$q = $_GET['q'];

$next = $q + 1;

if($q == 26)
{
echo '<h2>You have Completed the Exam.Congrats!!</h2>';


}
elseif($q <= 25){
    
$sql = "SELECT * FROM Students WHERE Email=?";
$stmt = $conn->prepare($sql); 
$stmt->bind_param('s', $_SESSION['login']);
$stmt->execute();
$result = $stmt->get_result(); $row = $result->fetch_assoc();

$Mark = $row['Mark'];


$Correct = $Mark + 1;


$Fail = $Mark + 0;

  
$sqlb = "SELECT * FROM Answers WHERE qid = ?";
$stmtb = $conn->prepare($sqlb); 
$stmtb->bind_param('s', $q);
$stmtb->execute();
$resultb = $stmtb->get_result();

$rowb = $resultb->fetch_assoc();

$Answer = $rowb['Answer'];

$Pick = $_POST['ans'];

if($Pick ==  $Answer)

{
  
  
    
  $sqld = "UPDATE Students SET Mark=? WHERE Email = ?";
$stmtd = $conn->prepare($sqld); 
$stmtd->bind_param('ss', $Correct,$_SESSION['login']);
$stmtd->execute();
$resultd = $stmtd->get_result();  


   echo "correct" ;
}

}
else

{
    
    echo 'Ate';
echo "<script type='text/javascript'>document.location.href='home.php?q='.$next.';</script>";
}

}//post submit

?>

The else statement doesnt run. so it keeps reloading the same page.

Also i want to ask why i keep getting the value of 2 for my $Correct variable stored on the database into column Mark for a single correct question instead of 1. What could be wrong?

Lastly, i dont want the script to run if the browser is edited by the user by changing the value of $q from the browser, because i am using get method, is there a way to do that.

Please be nice with your comments. Thanks in advance.!!!

Stop Executing Required Script

Similar Tutorials

View Content

Is there a way or function that stops the execution of a required script but continues to execute the parent script, for example:

if this is a.php

<?php
echo "<br>Good morning";

// function to stop execution of only this script to appear here

echo "<br>Good Afternoon";
?>

and then this is b.php

<?php

require("a.php');

echo "<br>Good Evening";
?>

So if the file b.php is called it is supposed to display:

Good morning
Good evening

So it has to skip "Good afternoon" because of the anonymous function which I need

Executing A Query Stored In A Variable..

Similar Tutorials

View Content

Hi, In some cases I need to execute a default query , so I am storing the SELECT statement in a variable like this and executing it:

Code: [Select]
$default_query="SELECT * from user where userid='$userid'";
$user_query=mysql_query($default_query);
The above code returns an empty results.
But if I execute it without the variable it works fine.
Code: [Select]
$user_query=mysql_query("SELECT * from user where userid='$userid'");
Am I syntatically wrong somewhere?

Executing Php Within User-supplied Content

Similar Tutorials

View Content

i'm creating a small app for someone who wants to control the content of each page from a DB.

effectively it'd be a template file with header, footer, etc all pre-built, and the content area supplied from a TEXT field in a MySQL table - basically the same idea wordpress uses.

this is all fine, but a couple pages would require some php - e.g., a list of events or users or articles, whatever, that are managed in different tables.

i can do this with eval - something like:

Code: [Select]
function render_content($string) {
ob_start();
eval("?>$string<?php ");
$returns = ob_get_contents();
ob_end_clean();
return $returns;
}
but i wonder if there's a better way. i can probably limit whatever code needs to be executed in include files, so i thought maybe include some arbitrary tag and use regexp to parse it out... maybe modeled after a conditional comment, e.g.,

Code: [Select]

// or even...
<include>some-file.inc.php</include>

but, again, not thrilled with the approach, and wondered if anyone had a better idea.

i should probably mention that it's not going to be a "content or include" setup - it probably won't be one or the other, exclusively, and is likely to be a mix on those pages that require it - the php might need to appear before, after, or in the middle of whatever arbitrary markup the user happens to supply, e.g.

Code: [Select]
<h1>This is a list of stuff</h1>
<p>Some explanation lorem ipsum dolor sit ahmet.</p>
<?php include('some-file.inc.php'); ?>
<em>But this caveat applies to the above list.</em>
<div>
Something totally unrelated.
<img src="pic.jpg" />
</div>
not sure I explained that very well, but hopefully the concept comes across.

TYIA