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
need help with php get
i have a option box that gets filled with dates, but how do i get once the option value has been cli
How to ask a regex question?
Hi, I thought I'd share some of my insight after seeing too many bad questions that either get ignor
Material xxx does not exist in plant xxx
Dear All,
I am working for a steel project which is repetitive manufacturing.
pagination numbering pattern
Hello,
I have following code which works great for pagination. but i have small issue now.Working with Dates, help.
Sooo to make a long story short, here's what im trying to accomplish.
I need to create a drop
Help With editting and deleting form
Hallo !!
So look at this image :
http://img194.imageshack.us/img194/8272/snapshot5f.pn
parsing error
can anyone explain this syntax error:
Parse error: syntax error, unexpected T_IF
The e
PHP4 to PHP5 Conversion
Hi Everyone,
I am working on a site that is built up on PHP4 and each page is being started f
pageination not working right... coping images over 4 pages
Code: <?php //This code will obtain the required page number from the $_GET array. Note that
Weird MySQL error, why am I recieving this?
PHP Code:
<?php require "global_settings.php"; ?>
<titl
