PHP - Need Help With A Php Program Using Mysql?

I'd like to put a password requirement in this program & an expiration date (database record)so that at 11 months I output an alert and at the end of one year it shuts down. ?
The below code works for the password but I can't find how to link to my main page?
PHP Code:
<?php
mysql_connect(localhost,root,"");
mysql_select_db(entrydb) or die( "Unable to select database");
if(!empty($_POST["submit"]))
{
 $password = $_POST['password'];
$expdate = $_POST['expdate'];
$query="SELECT password, expdate FROM entrydata Where password='$password'";
$result=mysql_query($query);
if(mysql_num_rows($result))
{
  echo "<form action='#' method='post'>";
       
  echo "</form>";
}
  else{echo "Access denied<br />";}
 }
?>
<form method="post" action="#"><br />
 <input type="text" name="password"/><p>
<input type="submit" name="submit" value="enter password"/>
</form> 

I stumbled across this site after being slammed hard elsewhere for being a novice and really not knowing what I am doing.  What I have read so far is more encouraging.  I just wrote my first program in php and it is not working at all right now.  All it keeps doing is opening window after window until I force the browser to close.  I am using a Mac running Yosemite and using MAMP.  Hopefully that is enough background.    I know this is an introduction area, so I will also post this in another forum in case this is closed for being off topic.   This is a login file to connect to the server:

<?php // login.php
// Get connection information

echo <<<_END
    <form method = "post" action = "login.php">
    <pre>
    <input type = "text" name = "localhost" />host server<br />
    <input type = "text" name = "username" />Username<br />
    <input type = "text" name = "password" /><br />
    <br />
    <input type = "submit" value = "submit" />
    </form>
_END

$db_server = sanitize_string($localhost);
$db_username = sanitize_string($username);
$db_password = sanitize_string($password);

/*
$user = 'root';
$password = 'root';
$db = 'rpsls';
$host = 'localhost';
$port = 3306;

$link = mysql_connect(
"$host:$port",
$user,
$password
);
$db_selected = mysql_select_db(
$db,
$link
);
*/

mysql_connect($db_server, $db_username, $db_password) or die(mysql_error());

// Create rpsls table if it does not exist

$tbl = "rpsls";
$query = "CREATE TABLE rpsls(human VARCHAR(10), computer VARCHAR(10), outcome VARCHAR(5),
    action VARCHAR(15));

INSERT INTO rpsls (human, computer, outcome, action) VALUES ("Rock", "Paper", "Lose", "Covers");
INSERT INTO rpsls (human, computer, outcome, action) VALUES ("Rock", "Scissors", "Win", "Crushes");
INSERT INTO rpsls (human, computer, outcome, action) VALUES ("Rock", "Lizard", "Win", "Crushes");
INSERT INTO rpsls (human, computer, outcome, action) VALUES ("Rock", "Spock", "Lose", "Vaporizes");
INSERT INTO rpsls (human, computer, outcome, action) VALUES ("Paper", "Rock", "Win", "Covers");
INSERT INTO rpsls (human, computer, outcome, action) VALUES ("Paper", "Scissors", "Lose", "Cuts");
INSERT INTO rpsls (human, computer, outcome, action) VALUES ("Paper", "Lizard", "Lose", "Eats");
INSERT INTO rpsls (human, computer, outcome, action) VALUES ("Paper", "Spock", "Win", "Disproves");
INSERT INTO rpsls (human, computer, outcome, action) VALUES ("Scissors", "Lizard", "Win", "Decapitates");
INSERT INTO rpsls (human, computer, outcome, action) VALUES ("Scissors", "Spock", "Lose", "Smashes");
INSERT INTO rpsls (human, computer, outcome, action) VALUES ("Scissors", "Rock", "Lose", "Crushes");
INSERT INTO rpsls (human, computer, outcome, action) VALUES ("Scissors", "Paper", "Win", "Cuts");
INSERT INTO rpsls (human, computer, outcome, action) VALUES ("Lizard", "Spock", "Win", "Poisons");
INSERT INTO rpsls (human, computer, outcome, action) VALUES ("Lizard", "Rock", "Lose", "Crushes");
INSERT INTO rpsls (human, computer, outcome, action) VALUES ("Lizard", "Paper", "Win", "Eats");
INSERT INTO rpsls (human, computer, outcome, action) VALUES ("Lizard", "Scissors", "Lose", "Decapitates");
INSERT INTO rpsls (human, computer, outcome, action) VALUES ("Spock", "Rock", "Win", "Vaporizes");
INSERT INTO rpsls (human, computer, outcome, action) VALUES ("Spock", "Paper", "Lose", "Disproves");
INSERT INTO rpsls (human, computer, outcome, action) VALUES ("Spock", "Scissors", "Win", "Smashes");
INSERT INTO rpsls (human, computer, outcome, action) VALUES ("Spock", "Lizard", "Lose", "Poisons");";

check_table($tbl, $query);

// Create choices table if it does not exist

$tbl = "choices";

$query = "CREATE TABLE choices(id SMALLINT, choice VARCHAR(10));

INSERT INTO choices (id, choice) VALUES (1, "Rock");
INSERT INTO choices (id, choice) VALUES (2, "Paper");
INSERT INTO choices (id, choice) VALUES (3, "Scissors");
INSERT INTO choices (id, choice) VALUES (4, "Lizard");
INSERT INTO choices (id, choice) VALUES (5, "Spock");";

check_table($tbl, $query);

// Sanitize user input

function sanitize_string($var)
{
$var = stripslashes($var);
$var = htmlentities($var);
$var = strip_tags($var);
return $var;
}

function check_table($tbl, $query){

$db = new mysqli(...);
$result = $db->query("SHOW TABLES LIKE "$tbl);
if ($result->num_rows == 0){
    mysql_query($query);
    }
}

?>

and this is the program:

<?php

// log into server and database

require_once 'login.php';
$db_server = mysql_connect($db_hostname, $db_username, $db_password);
if (!$db_server) die("Unable to connect to MySQL: " . mysql_error());
$conn = mysql_connect($db_server, $db_username, $db_password) or die(mysql_error());
$db_database = 'rpsls';
mysql_select_db($db_database) or die("Unable to select database: " . mysql_error());

// Start Game

ready_to_play();


// Rock Paper Scissors Lizard Spock game
function rock_paper_scissors_lizard_spock()
{
$human = human_play();
$computer = computer_play();
game_outcome($human, $computer);
play_again();


// Start Game Function

function ready_to_play(){
echo <<<_END
    <form method = "post" action = "rpsls.php">
    <h2>Ready to play Rock, Paper, Lizard, Spock?</h2>
    <hr>
    <table>
    <tr>
        <td><input type = "radio" name = "ready" value = "Yes" />Yes</td>
        <td><input type = "radio" name = "ready" value = "No" />No</td>
    </tr>
        <tr>
        <td colspan = "2"><input type = "submit" value = "Play!" /></td>
    </tr>
    </table>
    </form>
_END
    
    if ($ready == "Yes"){
        $query = "CREATE TABLE gameResults (
            games SMALLINT NOT NULL,
            win SMALLINT NULL,
            loss SMALLINT NULL,
            draw SMALLINT NULL,
            PRIMARY KEY (games))";
            
        mysql_query($query);    
        
        rock_paper_scissors_lizard_spock();
    }else{
        close_rpsls();
    }
}

// Play Again

// Start Game Function

function play_again()
{
echo <<<_END
    <form method = "post" action = "rpsls.php">
    <h2>Play Again?</h2>
    <hr>
    <table>
    <tr>
        <td><input type = "radio" name = "ready" value = "Yes" />Yes</td>
        <td><input type = "radio" name = "ready" value = "No" />No</td>
    </tr>
        <tr>
        <td colspan = "2"><input type = "submit" value = "Play!" /></td>
    </tr>
    </table>
    </form>
_END
    
    if ($ready == "Yes"){
        rock_paper_scissors_lizard_spock();
    }else{
        close_rpsls();
    }
}

// Human Play Selection

function human_play()
{
echo <<<_END
    <form method = "post" action = "rpsls.php">
    <h2>Let's Play Rock, Paper, Lizard, Spock</h2>
    <hr>
    <table>
    <tr>
        <td><input type = "radio" name = "human" value = "Rock" />Rock</td>
        <td><input type = "radio" name = "human" value = "Paper" />Paper</td>
    </tr>
    <tr>
        <td><input type = "radio" name = "human" value = "Scissors" />Scissors</td>
        <td><input type = "radio" name = "human" value = "Lizard" />Lizard</td>
    </tr>
    <tr>
        <td colspan = "2"><input type = "radio" name = "human" value = "Spock" />Spock</td>
    </tr>
    <tr>
        <td colspan = "2"><hr></td>
    </tr>
    <tr>
        <td colspan = "2"><input type = "submit" value = "Play!" /></td>
    </tr>
    </table>
    </form>
    
_END
    
    return $human;
}

// Computer Play Selection

function computer_play()
{
    $play = rand(1,5);
    $query = "SELECT choice FROM choices WHERE number = $play";
    $computer = mysql_query($query);
    
    return $computer;
}

// Game Outcome Function

function game_outcome($human, $computer)
{
    $win = $loss = $draw = 0
    
    if ($human == $computer){
        echo "Draw<br />";
        echo "We both played ".$human;
        $draw = 1;
    }else{
        $query = "SELECT outcome, action FROM rpsls WHERE human = $human AND computer = $computer";
        $results = mysql_query($query);
        $results2 = mysql_fetch_array($results);
        $outcome = $results2[0];
        $action = $results2[1];
        
        if ($outcome == "Win"{
            echo "You Win!!!<br />"
            echo "Your ".$human. " ".$action." my ".$computer."<br />";
            $win = 1;
        }else{
            echo "You Lose/.<br />
            echo "My ".$computer." ".$action." your ".$human."<br />";
            $loss = 1;
            }
        }
        $query = "INSERT INTO gameResults VALUES".(NULL, '$win', '$loss', '$draw')";
        mysql_query($query);
}

// Game Statistics Function

function game_statistics ()
{
    $query = "SELECT * FROM gameResults";
    $result = mysql_query($query);
    $rows = mysql_num_rows($result);
    $games = $rows;
    $win = $loss = $draw = 0;
    
    for ($index = 0; $index < $rows; ++$index){
        $row = mysql_fetch_row($result);
        $win = $win + $row[1];
        $loss = $loss + $row[2];
        $draw = $draw + $row[3];
    }
    
echo <<<_END
    <table>
    <tr>
        <td>Games</td>
        <td>Win</td>
        <td>Loss</td>
        <td>Draw</td>
    </tr>
    <tr>
        <td>$games</td>
        <td>$win</td>
        <td>$loss</td>
        <td>$draw</td>
    </tr>
    </table>
_END
}

// Print Statistics and close the game

function close_rpsls(){
echo <<<_END
    <form method = "post" action = "rpsls.php">
    <h3>Are you sure you want to quit?</h3>
    <hr>
    <table>
    <tr>
        <td><input type = "radio" name = "ready" value = "Yes" />Yes</td>
        <td><input type = "radio" name = "ready" value = "No" />No</td>
    </tr>
        <tr>
        <td colspan = "2"><input type = "submit" value = "Play!" /></td>
    </tr>
    </table>
    </form>
_END
    
    if ($ready == "No"){
        rock_paper_scissors_lizard_spock();
    }else{
        $query = "DROP TABLE gameResults";
        mysql_query($query);
    }    
}

// close connection
mysql_close($conn);
?>

Please forgive my novice errors and help me figure out what is wrong with this program.   Thank you. Here is the contents of the error log:   141104 18:36:26 mysqld_safe Starting mysqld daemon with databases from /Applications/MAMP/db/mysql
141104 18:36:28 [Warning] Setting lower_case_table_names=2 because file system for /Applications/MAMP/db/mysql/ is case insensitive
141104 18:36:28 [Note] Plugin 'FEDERATED' is disabled.
141104 18:36:28 InnoDB: The InnoDB memory heap is disabled
141104 18:36:28 InnoDB: Mutexes and rw_locks use GCC atomic builtins
141104 18:36:28 InnoDB: Compressed tables use zlib 1.2.3
141104 18:36:28 InnoDB: Initializing buffer pool, size = 128.0M
141104 18:36:28 InnoDB: Completed initialization of buffer pool
141104 18:36:28 InnoDB: highest supported file format is Barracuda.
141104 18:36:32  InnoDB: Waiting for the background threads to start
141104 18:36:33 InnoDB: 5.5.38 started; log sequence number 1711074
141104 18:36:33 [Note] Server hostname (bind-address): '0.0.0.0'; port: 8889
141104 18:36:33 [Note]   - '0.0.0.0' resolves to '0.0.0.0';
141104 18:36:33 [Note] Server socket created on IP: '0.0.0.0'.
141104 18:36:35 [Note] Event Scheduler: Loaded 0 events
141104 18:36:35 [Note] /Applications/MAMP/Library/bin/mysqld: ready for connections.
Version: '5.5.38'  socket: '/Applications/MAMP/tmp/mysql/mysql.sock'  port: 8889  Source distribution

Hello phpFreaks!

I want to ask you if there are some ways to make your php program works with serial number (that you give in people that bought it). So the one that buy it can't copy and give it to his friend..Or something...

Is there any way to make this with php ?

Thanks alot!

I recently converted my business to an ip-pbx that has lots of capabilites.  Among them is a feature I would like to use called http_notify.  It sends a post to a url with parameters such as caller id number, caller id name etc..  
  I need to write a simple program to accept these parameters and write them to a csv file along with a date/time stamp.  This seems like a super easy, short piece of code to come up with and as a noob I was hoping to write this myself.  I have found a few examples where the post is for a form but I can't find any examples where the data is coming in as part of the url.     This is the description of the feature on the phone system site:   HTTP Notify Sends notifications to a remote web server through a URL. This allows allows an event in a Jive Core PBX to trigger an action on a remote system. Simply enter a URL in the node, and that URL will be hit with an HTTP POST as calls 'pass through'. Multiple variables are available and all variables are also included in the post body. URL Defines the URL to be used (limit of 255 characters). Next Node Connects nodes together to create a call flow. Drag and drop  on the next node in the dial plan.

I'm just trying to incorporate some of what I've learned into practice and I can't believe I'm having problems with this but I really want to figure it out.

I'm trying to create a simple program where a user enters the name of a song, and gives it a rating (out of 5), and it displays the output first by song rating then (if the ratings are the same) displays it by the name of the song alphabetically. The idea in practice would work like this...user enters:

Quote

Song Name: My Song
Rating: 3

Song Name: His Song
Rating: 5

Song Name: Her Song
Rating: 5

Your list so far is:

Her Song - 5 stars
His Song - 5 stars
My Song - 3 stars



I just keep undoing things and clearly I'm not getting it. I had many ideas making it so I'll show you what I wrote (which isn't much): http://pastebin.com/2AGqgxQd

It looks terrible I know, I was just trying to find out how to put things from the form INTO an array and trying to output the array as I described above. If I could figure out how to use these session arrays to hold the entries from the post, then I'd be able to sort them properly, I'm just lost right now because everything I've read online and tried wasn't fixing the problem.

Thank you so much for the help!

<?xml version="1.0" encoding="ISO-8859-1"?>

<Note>
<from>
Ahmad
</from>
<to>
Yasir
</to>
<body>
hello yasir.

</Note>


Above is my xml file which misses the ending tag of <body>.
i want a php program that will detect this error and also fix the error and place the ending tag.
can someone help me?

Hi guys,

Can anyone help me about please.

I tried to google free open source for "Banner Affiliate Code Tracking" to put on my website but I can't find any.

Can anyone suggest or tell me how I can do this?

Cheers,
siabanie

1. Create a denomination program. See the example below. Input amount: 3897

1000: 3

500: 1

200: 1

100: 1

50: 1

20: 2

10:0

5:1

1: 2

2. Create a program that will compute the ideal age of a man's wife. See the example below.

Input Man's Age: 27

Formula: Man'sAge/2 + 7

Your ideal Wife's age is: 20 

 

Please send the Output as reply and please include the codes

Edited June 14 by Given-kun
Edit

I need a way to start a program and store the PID, then manage to stop it at the users request later.

Im not sure how i would go about this. It has to work on Windows,

Any help?
Thanks.

I am passing the variable $searchno from form1.html using

<form action="display1.php" method="post"
Display1.php reads my database and displays the data. Now I want to link from the displayed page to display2.php and pass and capture the same variable $searchno.

How do I do that?

hi !

I'm not a PHP master, now i'd like to program an online calculator on my website.
it's not the classical calculator with + / - / x / ln etc... but a specific, simple though, calculator.
I'd like even to be able to export the results of the calculations into a xls or csv file (that would be the next step)

Is that possible to do that with PHP ? or i should look more at javascript or java (dont like that idea) or flash etc...

Thanks for your replies !

Hi. I'm trying to make a open source kiosk like system. When the web browser starts all programs, it will run in the browser using PHP. I've found this link: Program execution Functions. It's using:

<?php
  $WshShell = new COM("WScript.Shell");
  $oExec = $WshShell->Run("WINWORD.exe", 7, false);
?>

I was able to start Microsoft Word on Windows, but I need to be able to do this on Linux. This is what I've tried on my Linux server:

<?php
  exec("/var/www/test.sh");
?>

But nothing happens. I know that test.sh works because I ran if from the terminal. I use test.sh to start a Python script. The Python script starts a text editor. I've tested the Python script and it works. All I need know is how to start the script from PHP on Linux.

Hi Guys

We have had a holiday program written in php in the past by an experienced developer but we are experiencing problems now.   So I am curious to try and resolve the best approach

Here goes

1:  We query multiple APIs to return holiday results to our users

2:  This can take up to 20 seconds to return results but sometimes its much quicker depending on the volume of API returned results

3:  Other users seem to be locked out of even visiting our website if an API call is running

So initially without posting any code, I have a couple of questions which are

A:  Is there a way to maybe poll a process or allow partial results to the users browser while things run in the background ( similar to what other holiday providers seem to be doing )

B:  Is there a way to speed this up or maybe some sort of better technology to utilise

 

Many thanks professionals

Hi, this is my first post but I hope it's fruitful. First, I am running PHP 5.1.6 on my VPS and I am trying to write a Leaderboard script for a game that takes place on my server. The game was not written by me and I know it works perfectly. I have also accessed the database through shell multiple times, so I know that works fine. Here is the code for my leaderboard script:
Code: [Select]
<html>
<title>Middle Cup Leaderboard</title>
<body>
<?php
echo "about to connect\n";
$dbc = mysqli_connect ('localhost','root', 'password', 'shoddybattle') OR die ('sql error:' . mysqli_connect_error() );
echo "Debugging point: connected\n";
//$query = "SELECT estimate FROM users";
//$result = mysqli_query($dbc,$query) or die ('Could not retrieve ratings!');
//echo 'Debugging point: requested\n';
//mysqli_close($dbc);
//echo 'Debugging Point: closed\n';
//echo 'Middle Cup Leaderboard Results\n';
//echo $result;
?>
</body>
</html>
Here is the source code of the output when I navigate to it:
Code: [Select]
<html>
<title>Middle Cup Leaderboard</title>
<body>
about to connect
As you can see, it looks as if the program stops indefinitely when I try to connect to the database. Does anyone know what could be wrong with this? Any help would be greatly appreciated!