PHP - MySQL Fail
Posted on
16th Feb 2014 07:03 pm by
admin
My PHP code will only execute the first part of my code...
Code: <?php
session_start();
?>
<html>
<head>
<title> Create a Character</title>
<style type="text/css">
body{
background-color: #000;
font-family: Arial, Tahoma;
font-size: .78em;
}
fieldset{
padding: 10px;
margin: 10px;
border: 1px solid #57626B;
width: 70%;
float: left;
}
legend{
background-color: #6A8CA5;
border: 1px solid #000;
padding: 5px;
}
input{
font-style: italic;
-moz-border-radius: 5px;
-webkit-border-radius: 5px;
}
#tester{
background-color: #333;
margin: 0 auto;
padding: 10px;
width: 70%;
height: 80%;
}
#stats{
float: left;
width: 25%;
font-style: italic;
color: #000;
padding: 5px;
border: 1px dashed #999;
}
</style>
</head>
<body>
<div id="tester">
<?php
//Creation script designed by Cetanu of http://mythscape.freezoka.com and http://tehfreerpg.proboards.com
//This script is licensed by the Creative Commons for: Sharing, Attribution, Non-derivative, and non-commercial.
//You MUST leave these notices in for LEGAL use of this script. YOU MAY NOT EDIT THIS SCRIPT LEGALLY.
//For more: http://creativecommons.org/licenses/by-nc-nd/3.0/us/
if(empty($_SESSION['user_id'])){
die("<strong>You are not logged in. Please do so to access the RPG Sector.</strong>");
}
if(empty($_POST['cont'])){
echo " Time to create your character!<br/>
<form action='create.php' method='post'>
<fieldset>
<legend>Create Character for <strong>".$_SESSION['user_id']."</strong></i></u></legend>
<p>Please choose a species.</p>
<input type='radio' name='Species' id='pred' value='Predator'/>Predator (Yautja)<br/>
<input type='radio' name='Species' id='alien' value='Alien'/>Alien (Xenomorph)<br/>
<input type='radio' name='Species' id='human' value='Marine'/>Marine<br/> <br/>
<label for='name'>Character Name</label>
<input type='text' maxlength='25' id='name' name='name'/><br/>
<input type='hidden' maxlength='30' value='{$_SESSION['user_id']}' id='player' name='player' readonly='readonly'/><br/>
<input type='submit' name='cont' id='cont' value='Continue On'/>
</fieldset>
</form>";
}
echo "<br/>";
if(!empty($_POST['cont'])){
$species = $_POST['species'];
include "db.php";
if(empty($_POST['name']) || empty($_POST['Species'])){
echo "<script>document.write('You must input a species and a name!'); setTimeout("window.location.reload()", 350);</script>";
}
if ($species== "Predator" || "Alien" || "Marine" && !empty($_POST['name'])){
mysql_query("INSERT INTO rpg (name, species, player) VALUES ('{$_POST['name']}' , '{$_POST['Species']}' , '{$_POST['player']}')")
or die(mysql_error());
}
elseif($species=="Predator"){
mysql_query("UPDATE rpg SET max_health=25, health=25, attack=25, defense=25, honor=20 WHERE player='{$_POST['player']}')");
}
elseif($species=="Alien"){
mysql_query("UPDATE rpg SET health=20, max_health=20, attack=20 , defense=20 , stealth=20 WHERE player='{$_POST['player']}");
}
elseif($species=="Marine"){
mysql_query("UPDATE rpg SET health=15, max_health=15 , attack=20 , defense=20 , melee=20 WHERE player='{$_POST['player']}");
}
else{
echo "Invalid Species. Try again!";
}
mysql_query("INSERT INTO bank (player , amount) VALUES('{$_SESSION['user_id']}' , 5)");
header('Location: statadd.php');
}
?>
</div>
</body>
</html>
The part starts here...When it gets to the three elseif statements, they are the only things that won't execute. Everything else works. I don't get errors.
Code: <?php
if(!empty($_POST['cont'])){
$species = $_POST['species'];
include "db.php";
if(empty($_POST['name']) || empty($_POST['Species'])){
echo "<script>document.write('You must input a species and a name!'); setTimeout("window.location.reload()", 350);</script>";
}
if ($species== "Predator" || "Alien" || "Marine" && !empty($_POST['name'])){
mysql_query("INSERT INTO rpg (name, species, player) VALUES ('{$_POST['name']}' , '{$_POST['Species']}' , '{$_POST['player']}')")
or die(mysql_error());
}
elseif($species=="Predator"){
mysql_query("UPDATE rpg SET max_health=25, health=25, attack=25, defense=25, honor=20 WHERE player='{$_POST['player']}')");
}
elseif($species=="Alien"){
mysql_query("UPDATE rpg SET health=20, max_health=20, attack=20 , defense=20 , stealth=20 WHERE player='{$_POST['player']}");
}
elseif($species=="Marine"){
mysql_query("UPDATE rpg SET health=15, max_health=15 , attack=20 , defense=20 , melee=20 WHERE player='{$_POST['player']}");
}
else{
echo "Invalid Species. Try again!";
}
mysql_query("INSERT INTO bank (player , amount) VALUES('{$_SESSION['user_id']}' , 5)");
header('Location: statadd.php');
}
?>
No comments posted yet
Your Answer:
Login to answer
157 
10 
Other forums
Grabbing Values From an Array for Posting
I have a grid array that I am using with a form that when it hits the currently named test.php it lo
need help with this contact form
I made this form and I need it to read the data and write the data to a table and its not working ca
Grids not displaying decimals, and behaving differently on different PCs?
Hello,
I coded a relatively simple MII application that allows data from a form to be add
OPINIONS WANTED
This is my login page code, and I want your opinion on it please!
Code: // Login ~ CHECKS
comparing tables across databases sql refinement ideas required
Hi all
Via pl/sql I need to ensure that data between tables in different databases match
Why Are These Functions Causing MASSIVE Memory Problems? Please Help!
Hi,
I have a script with some options.
I use regex to replace patterns in strings, but
mail with attachment problems
Hi. I have the following code:
Code: else if(file_exists("site".$timp.".zip")
Compare user input to flat file data
Help...Am a complete newbie to programming so my code is prolly quite long. Am trying to verify a us
Product categories for registration
Dear all,
We are going live with the Supplier registered next week. At standard, the 'sel
Working with Global Variables
hi, I'm not really sure why the following code is returning a "Call to a member function getBan
