PHP - I Am Having Trouble Incorporating This Code...

I am trying to insert into my database and it's just not having non of it. No errors are comming up at all, but no data is getting passed through.

Code: [Select]
if(isset($_POST['sub'])) {

include("../scrips/php/cms/database.insert.class.php");
$table = "blog_posts";
$title = $_POST['ArticleTitle'];
$img = "2";
$post = $_POST['ArticleBody'];
$aurthor_id = "1";
$category_id = "4";
$date_posted = "NOW()";
$values = array("$title","$img","$post","$aurthor_id","$category_id","$date_posted");
$fields = array('title','img','post','aurthor_id','category_id','date_posted');
//echo $values['0']."<br/>".$fields['0'];
//$obj->ArticleInsert($table,$fields,$tvalues);

$values_imploded = implode("','",$values);
$fields_imploded = implode(",",$fields);
$i = "INSERT INTO $table ($values_imploded) VALUES ($fields_imploded)";
mysql_query($i) or die( "<br>Query string: <br>Produced error: " . mysql_error() );;

}

$query  = "SELECT * FROM name_list WHERE Name= '$_POST[Name]' ";
$result = mysql_query($query);
while($row = mysql_fetch_array($result, MYSQL_ASSOC)){
if ( ($row['Name']) == $_POST['Name'] ) 
      echo "ERROR";
  else echo "rest of the code";
  }


So this code compares (or it should) the name entered by the user in the form to the list of names already in database. If the user enters a name in the form that is in the database I get and "ERROR" as I should. But is they enter a name that is not in the database I am not getting "rest of the code."

Why?

Building a website for work. I am struggling with the login for some reason. I`m using a lot of the same code as I did for my personal site and a few other websites I`ve programmed which has always worked. But for some reason, it isn`t working now. I`ve already told it to display to me the information that`s being processed and that is all correct (it even updates the database like it`s supposed to). It just won`t show the person being logged in, which defeats the purpose of logging in, yanno?

Here are all the files in question.

login.php
<?php
include "file_calls.php";
$title = "Business Name (Beta): Log In";
include "functions.php";
session_start();
echo "$title";
echo "<p>";
echo "Log into the Business Name website. Only authorized members of the Business Name Staff can log into the website.";
echo "<p>";
include "login_form.php";
?>

login_form.php
<?php
echo "<form action='logging.php' method='post'>";
echo "E-Mail Address:";
echo "<br><input type='text' name='email' size=60 maxlength=100>";
echo "<p>";
echo "Password:";
echo "<br><input type='password' name='pass' size=60 maxlength=25>";
echo "<p>";
$buttonlabel = "Log In";
include "formbutton_format.php";
echo "</form>";
?>


logging.php
<?php
include "file_calls.php";
$title = "Business Name (Beta): Logging In";
include "functions.php";
session_start();
echo "$title";
echo "<p>";
echo "Logging into the Business Name website. Only authorized members of the Business Name Staff can log into the website.";
echo "<p>";
$email = $_POST['email'];
$pass = $_POST['pass'];
$entry_date = strftime("%B\ %e\,\ %Y %I:%M:%S %p", time());

$res = mysql_query("SELECT id, memlev, pwd1, pwd2, email, name FROM user_data WHERE email='$email'");
$by = mysql_fetch_row($res);
mysql_free_result($res);

$log = $by[4];
$pas = $by[2];
$pas2 = $by[3];

if ($email && $pass) {
if ($by[0]) {
if ($by[1] == 2) {
$passwd = crypt($_REQUEST['pass'],$by[5]);
if ($pass == $pas2) {
mysql_query("UPDATE user_data SET lastlogin='$entry_date' WHERE email='$email'");
mysql_close($con);
header("Location: index.php");
}
elseif ($passwd != $pas) {
header("Location: nolog.php?logout=1&m=4");
}
}
elseif ($by[1] == 1) {
header("Location: nolog.php?logout=1&m=2");
}
elseif ($by[1] == 0) {
header("Location: nolog.php?logout=1&m=3");
}
}
elseif (!$by[0]) {
header("Location: nolog.php?logout=1&m=1");
}
}
elseif (!$email || !$pass) {
echo "<b>Error:</b> Both username and password must be entered in order to log in.";
echo "<p>";
include "login_form.php";
}
?>[/php

index.php
[php]<?php
include "file_calls.php";
$title = "Business Name (Beta)";
include "functions.php";
session_start();
echo "$title";
echo "<p>";
echo "This website is currently under construction. Thank you for your patience.";
echo "<p>";
if ($lev > 1) {
echo "Hello, $loggeduser !";
}
elseif ($lev < 2) {
echo "Not logged in.";
}
echo "<p>";
echo "$lev";
echo "<br>$loggeduser<br>$email";
?>

auth.php

<?php
  // Defines
 
  DEFINE('SESSION_MAGIC','sadhjasklsad2342');

  // Initialization
  @session_start();
  @ob_start();
  
 
    /*
      Redirects to another page
    */
    function Redirect($to) {

   @session_write_close();
   @ob_end_clean();
   @header("Location: $to");
    } 
 
     /*
        Deletes existing session
    */
function RemoveSession() {
$_SESSION = array();
if (isset($_COOKIE[session_name()])) {
   @setcookie(session_name(), '', time()+(60*60*24*365), '/');
}
}
    
/*
  Checks if user is logged in
*/ 
function isLoggedIn() {

return(isset($_SESSION['magic']) && ($_SESSION['magic']==SESSION_MAGIC));
}


 
    /* 
      read message count
    */
    function CountMessages($id) {
    
   if ($res=mysql_query("SELECT * FROM user_data WHERE email='$email'"))
   {
   $count=mysql_num_rows($res);
   mysql_free_result($res);    
   return($count);
   }
   return 0; 
    }
    
    /*
      Go login go!
    */
    function Login($email,$pass) {
   
    global $nmsg, $rows;
   
   $ok=false;
   if ($res=mysql_query("SELECT id, email, name, pwd1, pwd2, memlev FROM user_data WHERE email='$email' AND pwd2='$pass'"))
   {
   if ($rows=mysql_fetch_row($res)) {
    $_SESSION['sess_name'] = $rows[2];
$_SESSION['pass'] = $pass;
$_SESSION['gal'] = $rows[0];
$_SESSION['level2'] = $rows[5];
$_SESSION['email'] = $rows[1];
    $_SESSION['magic'] = SESSION_MAGIC;
    $nmsg = CountMessages($rows[0]);
    $ok=true;
   } else {
   include('login_failed.php');
   }
   mysql_free_result($res);
   }
   return($ok);
   }
   
       /*
      Terminates an existing session
    */
    function Logout() {
    @RemoveSession();
    @session_destroy();
    }

    /*
      Escape array using mysql
    */   
function Escape(&$arr)
{
 if (Count($arr)>0) {
    foreach($arr as $k => $v) {
        if (is_array($v)) {
            Escape($arr[$k]);
        }
        else {
            if (function_exists('get_magic_quotes')) {
                if(!get_magic_quotes_gpc()) {
                    $arr[$k] = stripslashes($v);
                }
            }
            $arr[$k] = mysql_real_escape_string($v);
        }
   }
      }
}

// -----------------------------------------------    
// Main
// -----------------------------------------------    

   Escape($_POST);
   Escape($_GET);
   Escape($_COOKIE);
   Escape($_REQUEST);
   Escape($_GLOBALS);
   Escape($_SERVER);
   
?>


file_calls.php
<?php
include "info_con.php";
include "auth.php";
?>


functions.php

<?php
echo "<title>$title</title>";




$lev=isset($_SESSION['level2'])?$_SESSION['level2']:0;
$logged=isset($_SESSION['gal'])?$_SESSION['gal']:0;
$loggeduser=$_SESSION['sess_name'];
$nmsg = 0;
$rows = isset($_SESSION['rows'])?$_SESSION['rows']:array();
$email = isset($_SESSION['email'])?$_SESSION['email']:'';
$pass = isset($_SESSION['pass'])?$_SESSION['pass']:'';






function rand_chars($c, $l, $u = FALSE) {
  if (!$u) for ($s = '', $i = 0, $z = strlen($c)-1; $i < $l; $x = rand(0,$z), $s .= $c{$x}, $i++);
  else for ($i = 0, $z = strlen($c)-1, $s = $c{rand(0,$z)}, $i = 1; $i != $l; $x = rand(0,$z), $s .= $c{$x}, $s = ($s{$i} == $s{$i-1} ? substr($s,0,-1) : $s), $i=strlen($s));
  return $s;
}






function ShowLoggedInBar() {
global $email,$pass,$rows,$logid;

   $nmes="";
   if($nmsg){
 $nmes="($nmsg New)";
   }
   echo "Hello, $loggeduser !";
}








/* check if we are logging out */
if (isset($_REQUEST['logout'])) {
Logout();
}

/* check if already logged in */
if (isset($_SESSION['magic']) && ($_SESSION['magic']==SESSION_MAGIC)) {   
   ShowLoggedInBar();
}
else {

/* not logged in, is it a form post? */
if (isset($_REQUEST['email']) && isset($_REQUEST['pass'])) {
$email = $_REQUEST['email'];
$pass = crypt($_REQUEST['pass'],$email);
Login($email,$pass);
} else {

}
}
?>


Can anyone see why it works on everything but getting the person logged in?

Hello everyone,

I am new to this forum and PHP world. Doing my first project, a pretty complicated one to start with. I will be needing your help a lot to accomplish it.
Here is the first one.

1. I have a certain field called 'country'
2. I have small flag icons for every country.

WHAT DO I WANT TO DO?

Example - If the country is U.S.A., the U.S. flag shows up and is a link to www.domain.com/usa
If the country is Germany, the German flags shows up and is a link to www.domain.com/germany
If the country is not set, no flag shows up. END.

How do I execute this?

This is what I am doing to get the image
<img src="images/flags/<?php echo $row_rsPilots['country']; ?>.gif" alt="" name="Flag" width="20" height="20" id="Flag" />

How do make it a link to www.domain.com/'country'

Thanks in advance

Hi Chaps,

I have a PHP FTP App, where users can log in using a unique code and a password.

Their unique code corresponds to an FTP folder, e.g.
Quote

\FTP_Root\Customer A & Co\


So when the user logs in, they can see their FTP directory and contents, in this case an Inbox and an Outbox.
This works as the FTP folder contains both an Inbox and an Outbox.

The problem I am having is when I try browsing within this directory (say the Inbox), ftp-chdir fails.

I have a hyperlink that sends a 'dir' parameter to the same ftp.php page, and if set, will attempt to change to the given directory.

So even though the URL Hyperlink reads:
Quote

....server.co.uk/ftp.php?dir=/FTP_Root/Customer A & Co/Inbox


When you click on this link, the page tries to load:
Quote

....server.co.uk/ftp.php?dir=/FTP_Root/Customer A


So my question is what do I need to change, the Hyperlink to read something like:
Quote

....server.co.uk/ftp.php?dir=/FTP_Root/Customer%20A%20&%20Co/Inbox



Do something to the ftp-chdir function, where I encode/decode/whatever to make sure it tries to change to the correct FTP directory?

Or exclude all ampersand entirely?

Hi,

My mother-in-law asked me to check on her laptop (win8) and I tried but was unable to find a solution.

The problem is that the hard-drive is at a constant 100% which makes the laptop really slow except in safe mode.

Process list shows no process using 100% of the hdd, I already did a chkdsk and it returned no errors.

I suspect it's due to the task scheduler and stopping the active tasks indeed lowers the hdd usage to 6-11% but it does not remain there probably because new tasks are started. I also removed several software which I suspected were the ones creating the tasks to no avail.

It appears as if Windows itself is running tasks that slow down the laptop to a crawl, but disabling task scheduler does not seem a good idea.

Any ideas?

This topic has been moved to CSS Help.

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

I created an array using the array_diff function and it worked fine.  My resulting array has lots of keys/values (like teamid, teamname, teamcity). I want to now display the teamid and teamcity as options in an HTML SELECT menu.  I thought I would do something like this below, but it's only giving me the teamid (NOTE, I left out the Select tags because I'm good with that part of it ). 

How do I write the code to get the teamcity to show as well?

Obviously doing something very wrong

Code: [Select]
$remainingteams = array_diff($allteams, $chosenteams);
foreach($remainingteams as $teamid => $value){
echo "<option>" . $teamid . "-" . $remainingteams['teamcity'] . "</option>";
}

Hey everyone im having a little trouble with my forum pagination on the replies. I am using the the id of the topic as the page so this is what it looks like for the link:
"   echo "  <tr><td height='50' align='center' valign='top' bgcolor='#AAAAAA'><b>$username</b><br />$date<br />$time</td>
  <td height='50' align='center' bgcolor='#AAAAAA'><b><a href='viewtopic.php?id=$id'>$topic</a></b></td></tr>";"
so the link is http://...........viewtopic.php?id=1
I am using this pagination
  <?
//display data
$get = mysql_query("SELECT * FROM reply WHERE reply_id='$id' LIMIT $start, $per_page");
while ($row = mysql_fetch_assoc($get))
  {
   //get data
   $a_username = $row['a_username'];
   $a_date = $row['a_date'];
   $a_time = $row['a_time'];
   $a_reply = $row['a_reply'];
   
   echo "  <tr><td height='50' align='center' valign='top' bgcolor='#AAAAAA'><b>$a_username</b><br />$a_date<br />$a_time</td>
  <td height='50' align='center' bgcolor='#AAAAAA'>$a_reply</td></tr>";
   
  }

  ?>

  </table>
  <p />
 
  <div align='center'>
  <?
//setup prev and next variables
$prev = $start - $per_page;
$next = $start + $per_page;

//show prev button
if (!($start<=0))
      echo "<a href='viewtopic.php?start=$prev'>Prev</a> ";
      
//show page numbers

//set variable for first page
$i=1;

for ($x=0;$x<$record_count;$x=$x+$per_page)
{
   if ($start!=$x)
      echo "<a href='viewtopic.php?start=$x'>$i</a> ";
   else
      echo "<a href='viewtopic.php?start=$x'><b>$i</b></a> ";
$i++;
}

//show next button
if (!($start>=$record_count - $per_page))
      echo " <a href='viewtopic.php?start=$next'>Next</a>";

?>

but then when I click on the next page or one of those links it comes out like this http://...........viewtopic.php?id=1?start=2
then click it again http://...........viewtopic.php?id=1?start=2?start=2 and adds that every time I click it
can anyone help its the last part of making my forum, please?

I'm not sure if this is a php issue or jquery issue. When I complete the form and hit submit it puts the successful message up like its supposed to but also with the fields still filled in the form which it shouldn't be doing and it doesn't actually post in the database so I'm not sure if its a php issue or jquery issue.

Code: [Select]
<script type="text/javascript">
    $(document).ready(function() {
    $('div.message-error').hide();
    $('div.message-success').hide();
    $("input.submit").click(function() {
        $('div.message-error').hide();
        var templatename = $("input#templatename").val();
  if (templatename == "") {
        $("div.message-error").show();
        $("input#templatename").focus();
        return false;
      }
      var headercode = $("textarea#headercode").val();
  if (headercode == "") {
        $("div.message-error").show();
        $("textarea#headercode").focus();
        return false;
      }
      var footercode = $("textarea#footercode").val();
  if (footercode == "") {
        $("div.message-error").show();
        $("textarea#footercode").focus();
        return false;
      }
     
        var dataString = 'templatename='+ templatename+ '&headercode=' + headercode + '&footercode=' + footercode;
        $.ajax({
        type: "POST",
        url: "processes/template.php",
        data: dataString,
        success: function() {
        $("div.message-success").show();
        return true;
    }
  });
  return false;   
    });
  });
 
</script>
<!-- Form -->
<form action="#" name="templateform" >
<fieldset>
<legend>Add New Template</legend>

<div class="field required">
<label for="templatename">Template Name</label>
<input type="text" class="text" name="templatename" id="templatename" title="Template Name"/>
<span class="required-icon tooltip" title="Required field - This field is required, it cannot be blank, and must contain something that is different from emptyness in order to be filled in. ">Required</span>
</div>
        <div class="field required">
<label for="headercode">Header Code</label>
<textarea name="headercode" id="headercode" title="Header Code"></textarea>
<span class="required-icon tooltip" title="Required field - This field is required, it cannot be blank, and must contain something that is different from emptyness in order to be filled in. ">Required</span>
</div>
        <div class="field required">
<label for="footercode">Footer Code</label>
<textarea name="footercode" id="footercode" title="Footer Code"></textarea>
<span class="required-icon tooltip" title="Required field - This field is required, it cannot be blank, and must contain something that is different from emptyness in order to be filled in. ">Required</span>
</div>
        <input type="submit" class="submit" name="submittemplate" id="submittemplate" title="Submit Template" value="Submit Template"/>
</fieldset>
</form>
<!-- /Form -->

<!-- Messages -->
<div class="message message-error">
    <h6>Required field missing</h6>
    <p>Please fill in all required fields. </p>
</div>

<div class="message message-success">
    <h6>Operation succesful</h6>
    <p>Template was added to the database.</p>
</div>
<!-- /Messages -->

validation page
<?php

// Include the database page
include ('inc/dbconfig.php');

if ((isset($_POST['templatename'])) && (strlen(trim($_POST['templatename'])) > 0)) {
$templatename = stripslashes(strip_tags($_POST['templatename']));
} else {$templatename = 'No name entered';}

if ((isset($_POST['headercode'])) && (strlen(trim($_POST['headercode'])) > 0)) {
$headercode = stripslashes(strip_tags($_POST['headercode']));
} else {$headercode = 'No name entered';}

if ((isset($_POST['footercode'])) && (strlen(trim($_POST['footercode'])) > 0)) {
$footercode = stripslashes(strip_tags($_POST['footercode']));
} else {$footercode = 'No name entered';}

 $query = "INSERT INTO `templates` (templatename, header, footer, creator_id, datecreated) VALUES ('".$divisionname."','".$headercode."','".$footercode."' 1, NOW())";
 mysql_query($query);

?>

I have this as my code:


if(!empty($stipulation)){
if($stipulation == "Championship Title Match"){
print "<h3 class=title>".$title." Match</h3>";
}
else{
 print "<h3 class=stipulation>".$stipulation."</h3>";
}
}


however I'm wanting to make it to where if it $stipulation has a value then it echos it and nothing if it doesn't have a value then don't nothing else happens. I also need a similiar if statement that will check to see if there is a value for $title and if there is then it echos $title Championship Match and again if no value exists it does nothing.

I wrote a simple sales tax function but it keeps come back with a sales tax of 0 the price is coming from a database. 

Code: [Select]

function TotalSalesTax($price)
{
$salesTax = .07;
$TotalSalesTax = $price * $salesTax;
    number_format($TotalSalesTax, 2);
return $TotalSalesTax;
}


Code: [Select]
<tr> 
    <td></td> 
    <td>Sales Tax:  </td>
    <td><?php echo TotalSalesTax($price);?>  </td>
</tr>

product page that the price comes from
Code: [Select]
<?php
session_start();
if(!isset($_SESSION['quantity']))

{
  $_SESSION['quanity']=array(); //if there are no quantities selected, the array is empty
  if(is_array($_POST['quantity']))//if there are items in the cart
{
  echo $quantity;
  header("location: checkOut.php");
}
}
require_once("functions.php");
?> 
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<title>Untitled Document</title>
<style type="text/css">
td {
border-top-style: solid;
border-right-style: solid;
border-bottom-style: solid;
border-left-style: solid;
border-top-color: #30C;
border-right-color: #30C;
border-bottom-color: #30C;
border-left-color: #30C;
}
#productCatalog {
width:400px;   
margin-right: auto;
margin-left: auto;
}
</style>
<link href="doggyTreats.css" rel="stylesheet" type="text/css" />
</head>

<body>
<?php
logo();
navBar();
echo "<div id=\"productCatalog\">";
echo "<form action=\"checkOut.php\" method=\"post\" name=\"catalog\">";
  
DatabaseConnection();  

  $query = "SELECT * FROM treats"; 
        $result_set = mysql_query($query) or die(mysql_error());
$i = 0;

        echo "<table>";
        while ($row = mysql_fetch_array($result_set))
        {
echo"<tr><td width=\"2s00px\"><img src=\"{$row['product_pic']}\" /></td><td width=\"200px\">{$row['product_title']}.<br /><br />{$row['product_Description']}.<br /> Price:  \${$row['price']}.<br /><br />Quantity <input name=\"quantity\" type=\"text\" size=\"2\" /></td></tr>";
        }
  echo "<tr>"; 
echo "<td><input name=\"submit\" type=\"submit\" value=\"Proceed to Checkout\" />"; 
echo "</table>";    
echo "</form>";
echo "</div>";
footer();
?>
</body>
</html>

Trying to get my output to to show 2 decimal places but keep getting syntax errors please help.
Here's the code i have.

Code: [Select]
<?php
// Input Data From Form
$Cost = $_POST['fielda'];
//$Cost2 = number_format(,2);
//Set Current Date & Shipping Date (15 days)
$Date = date('l, F d, Y');
$ShipDate = date('F d, Y',strtotime('+ 15 days'));

$Tax = ($Cost * .06);
$Ship = 0;
//$Sub = ($Cost + $Tax);

//Calculate Shipping
if ($Cost <= 25.99 ){
   $Ship = 3.00; }
if ($Cost >= 26.00 && $Cost <= 50.99 ){
   $Ship = 4.00;}
if ($Cost >= 51.00 && $Cost <= 75.00) {
   $Ship = 5.00;}
if ($Cost > 75.00) {
   $Ship = 6.00;}
   
   //Calculate Order Total
$Total = ($Cost + $Tax + $Ship);

print " Date: $Date<br><br>";
print " Cost : $$Cost<br><br> Tax: $$Tax<br><br> Shipping: $$Ship<br><br> Total: $$Total<br><br>";
print "Estimated Ship Date is $ShipDate<br> " ;

?>

MOD EDIT: code tags added.

Alright when I run this query in MySQL everything goes smoothly: Code: [Select]
INSERT INTO accounts (id, password, email) VALUES ('1022911', 'blahblah7', 'zzz@zzz.com')
But when this runs in my script: Code: (php) [Select]
$sql = "INSERT INTO accounts (id, password, email) VALUES ('
{$account_number}', '{$account_password}', '{$email}')";
the id changes from the users input, I believe because the field is set to auto-increment but, I don't understand why the query works correctly through MySQL and not my script.