PHP - Wont Echo

i need help trying to get this delete feature to work its not deleting from the database (by the way i took out my database names and passwords at the top of the file)

is it possible someone could help me, ive been working on this for like a week and cant figure out the problem. thanks! you can email me at spr_spng@yahoo.com


picture 2.png is showing what it looks like




Code: [Select]
<?php
$host="localhost"; // Host name
$username="username"; // Mysql username
$password="password"; // Mysql password
$db_name="database_name"; // Database name
$tbl_name="table_name"; // Table name

// Connect to server and select databse.
mysql_connect("$host", "$username", "$password")or die("cannot connect");
mysql_select_db("$db_name")or die("cannot select DB");

$sql="SELECT * FROM $tbl_name";
$result=mysql_query($sql);

$count=mysql_num_rows($result);


?>
<style>
/*table affects look of the whole table look */
table {
margin-left: auto;
margin-right: auto;
border: 1px solid #330000;
border-collapse:collapse;
width:70%;

border-width: 5px 5px 5px 5px;
border-spacing: 1px;
border-style: outset outset outset outset;
border-color: #330000 #330000 #330000 #330000;
border-collapse: separate;
background-color: #330000;


#800517

f535aa

#330000 school color
#9A0000 school color2
#991B1E school color3
#CCCC99 school color4
#9A0000

}
/*th is table header */
th {
text-align: left;
height: 2.5em;
background-color: #330000;
color: #FC0;
font-size:1.5em;
}
/*td is table data or the cells below the header*/
td {
text-align: left;
height:1.0em;
font-size:1.0em;
vertical-align:bottom;
padding:10px;

border-width: 5px 5px 5px 5px;
padding: 8px 8px 8px 8px;
border-style: outset outset outset outset;
border-color: #9A0000 #9A0000 #9A0000 #9A0000;
background-color: #CCCC99;
-moz-border-radius: 0px 0px 0px 0px;

}
</style>
<table width="400" border="0" cellspacing="1" cellpadding="0">
<tr>
<td><form name="form1" method="post" action="">
<table width="400" border="0" cellpadding="3" cellspacing="1" bgcolor="#CCCCCC">
<tr>
<td bgcolor="#FFFFFF">&nbsp;</td>
<td colspan="4" bgcolor="#FFFFFF"><strong>Pick Which Rows you want to delete, Then press delete.</strong> </td>
</tr>
<tr>
<td align="center" bgcolor="#FFFFFF"><strong>Id</strong></td>
<td align="center" bgcolor="#FFFFFF"><strong>Name</strong></td>
<td align="center" bgcolor="#FFFFFF"><strong>Lastname</strong></td>
<td align="center" bgcolor="#FFFFFF"><strong>Email</strong></td>
<td align="center" bgcolor="#FFFFFF">delete</td></tr>
<?php
while($rows=mysql_fetch_array($result)){
?>
<tr>
<td bgcolor="#FFFFFF"><? echo $rows['id']; ?></td>
<td bgcolor="#FFFFFF"><? echo $rows['name']; ?></td>
<td bgcolor="#FFFFFF"><? echo $rows['lastname']; ?></td>
<td bgcolor="#FFFFFF"><? echo $rows['email']; ?></td>
<td align="center" bgcolor="#FFFFFF"><input name="checkbox[]" type="checkbox" id="checkbox[]" value="<? echo $rows['id']; ?>"></td>
</tr>
<?php
}
?>
<tr>
<td colspan="5" align="center" bgcolor="#FFFFFF"><input name="delete" type="submit" id="delete" value="Delete"></td>
</tr>
<?
// Check if delete button active, start this // edited
if($delete){
for($i=0;$i<$count;$i++){
$del_id = $checkbox[$i];
$sql = "DELETE FROM $tbl_name WHERE id='$del_id'";
$result = mysql_query($sql);
}

// if successful redirect to delete_multiple.php
if($result){
echo "<meta http-equiv=\"refresh\" content=\"0;URL=delete_multiple.php\">";
}
}
mysql_close();
?>
</table>
</form>
</td>
</tr>
</table>

So I need to echo a row from my database with php, but where i need to echo is already inside an echo. This is my part of my code:


$con = mysql_connect("$host","$username","$password");
if (!$con)
  {
  die('Could not connect: ' . mysql_error());
  }

mysql_select_db("main", $con);

$result = mysql_query("SELECT * FROM Vendor");

while($row = mysql_fetch_array($result))
  {
//I need to echo right here  .................. but I get a blank page when I try this. Please Help.
  echo '<option value=$row['vendor_id']>'; echo $row['vendor_id']; echo '</option>';
  }

mysql_close($con);

Result: A Blank page.
Thanks in advance!

I have a log system that allows 10 logs on each side(Left and right). I am trying to make it so that the left side has the 10 most recent logs, then the right as the next 10. Any ideas?

Hi   I try to echo out random lines of a html file and want after submit password to whole content of the same html file. I have two Problems. 1st Problem When I echo out the random lines of the html file I don't get just the text but the code of the html file as well. I don't want that. I just want the text. How to do that?

for($x = 1;$x<=40;$x++) {
		$lines = file("$filename.html");
        echo $lines[rand(0, count($lines)-1)]."<br>";
        }

I tried instead of "file("$filename.html");" "readfile("$filename.html");" But then I get the random lines plus the whole content. Is there anything else I can use instead of file so that I get the random lines of text  without the html code?P.S file_get_contents doesn't work either have tried that one.     2nd Problem:   As you could see in my first problem I have a file called $filename.html. After I submit the value of a password I want the whole content. But it is like the program did forget what $filename.html is. How can I make the program remember what $filename.html is? Or with other words how to get the whole content of the html file?   My code:

if($_POST['submitPasswordIT']){
if ($_POST['passIT']== $password ){
$my_file = file_get_contents("$filename.html");
echo $my_file;
}
else{
echo "You entered wrong password";
}
}

If the password isn't correct I get: You entered wrong password. If the password is correct I get nothing. I probably need to create a path to the file "$filename.html", but I don't know exactly how to do that.   

Why isn't this working?


elseif($db_password==md5($password))

Hey all, I have an odd problem that I hope someone here has had and knows how to fix.

I recently installed Apache, PHP, and MySQL on a new server we have at work. Everything works fine, oddly enough, except for PHP parsing.

You see the following code:

Code: [Select]
<?
echo "test";
?>

Will display the PHP code, while

Code: [Select]
<?php
echo "test";
?>

Will echo "test". The problem seems to be that PHP isnt parsing the <? directive as a start command. Does anyone have any idea why this might be?

Thanks for any help.

$last = mysql_query("SELECT MAX('id') FROM comments WHERE submittedby='$username'");


can any1 help me?

hi guys hope some1 can help. 

im creating a system that will allow stock to be added to a database and modifed.  However on the add section, nothing adds it only inputs a new id row in the database and the other fields are blank.   Can anyone have a look for me
This sections is the form handler once the user has input a stockname and stock qty


Code: [Select]
<?php
session_start();


?>

<!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>stock</title>
</head>

<body>
<?php
$stockname = &$_POST['stockname'];
$stockqty = &$_POST['stockqty'];


$connect = mysql_connect("localhost","root", "") or die ("Couldn't Connect!");
mysql_select_db("stock", $connect) or die("Couldn't find db"); // select database

$query = mysql_query("SELECT * FROM stocks WHERE stockname=$stockname, stockqty=$stockqty");
$numrows = mysql_num_rows($query);


if ($numrows!=0)
{
echo("Item already exists!  Try Updating the items instead!");
}
else
{
$queryreg = mysql_query("INSERT INTO `stock` . `stocks` (`id`, `stockname`, `stockqty`) VALUES (NULL,'$stockname','$stockqty')");

echo("stock added!");
}


?>
<center><table>
<tr>
    <td>
       
        Stock_id
        </td>
        <td>
       
        Stock_name
        </td>
        <td>
       
        Stock_Qty
        </td>
    </tr>
</table></center>
</body>
</html>

Thanks


Lance

Ok, I am a complete noob when it comes to php. I am slowly learning it but I turned to youtube for a tutorial on a registration/login page. I found a good tutorial http://www.youtube.com/watch?v=ngqeWUIDlnk&feature=channel but for some reason my php is NOT working. I have it exactly the way he does but it wont echo anything or work at all. The login page worked great in his tutorial. What do I have wrong? I cant figure it out. Please help!

 

echo "<h1>Register</h1>";

 $submit = $_POST['submit'];
 $fullname = strip_tags($_POST['name']);
 $username = strip_tags($_POST['user']);
 $password = strip_tags($_POST['password']);
 $verifypassword = strip_tags($_POST['verifypassword']);
 $date = date("Y-m-d");

 if ($submit)
 {
     if($fullname&&$username&&$password&&$verifypassword)
     {
          password = md5($password);
          verifypassword= = md5($verifypassword);
     }
     else
         echo "Please fill in all fields!";

 }
Code: [Select]
<html>
<form action='register.php' method='POST'>
      <table>
              <tr>
                   <td>Full Name:</td>
                   <td><input type='text' name='name'></td>
              </tr>
             
              <tr>
                   <td>Username:</td>
                   <td><input type='text' name='user'></td>
              </tr>
               
               <tr>
                   <td>Password:</td>
                   <td><input type='password' name='password'></td>
              </tr>

              <tr>
                   <td>Verify Password:</td>
                   <td><input type='password' name='verifypassword'></td>
              </tr>
      </table>
      <p><input type='submit' name='submit' value='Submit'></p>
</form>

</html>

Ive got some like code like this (this is a part of my source, it'll be enough to solve my problem). I've got 4 functions here trying to run them using switch statement, but only the default one is running, why ?

Code: [Select]
  <?php 

//******PETLJA ZA MENI*******//
switch(@$HTTP_GET_VARS["method"])

{

case "ShowAdd":

GetNewPollDetails();

break;

case "AddFinal":

AddPoll();

break;

case "ShowDelete":

GetPollToDelete();

break;

case "DeleteFinal":

DeletePoll();

break;

default:

GetChoice();

}

function GetChoice(){
?>
<ul>
  <li><h2><a href="managepoll.php?method=ShowAdd">Dodaj anketu</a></h2></li>
<li><h2><a href="managepoll.php?method=ShowDelete">Izbrisi anketu</a></h2></li>
<li><h2><a href="managepoll.php?method=DeleteFinal">Pregledaj ankete</a></h2></li>
</ul>
<?php 
}
?>
<?php
function GetNewPollDetails(){
?>
  <h1>Nova anketa</h1>
<form name="DodajAnketu" action="managepoll.php?method=AddFinal">
<br />
 
Pitanje Ankete:<input name="text" type="text" width="150"/>
<br />
Odogovor 1:<input name="text2" type="text" width="150"/>
<br />
Odogovor 2:<input type="text" width="150"/>
<br />
Odogovor 3:<input type="text" width="150"/>
<br />
Odogovor 4:<input type="text" width="150"/>
<br />
Odogovor 5:<input type="text" width="150"/>
<br />
<input type="submit" value="Napravi" name="napravi" />
</form>
<?php
}
?>

Hi,

Im trying to get an image to display from a reference in the database but am having no joy. At the minute Im just playing about with PHP to get familiar with it so you can ignore most of the code. The line im interested in is:

<td><?php echo "<img src=\"C:\wamp\www\fermpix\Pics\'{$row["Name"]}'\">";?></td>

When I view the page in my browser I see the attached. Can anybody see what im doing wrong?

Heres the full page:

<!DOCTYPE HTML PUBLIC 
  "-//W3C//DTD HTML 4.0 Transitional//EN"
  "http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
   <title>Browse Upload Files</title>
</head>
<body bgcolor="white">

<?php
  error_reporting(E_ALL);  
  include 'db.inc';
  
  $query = "SELECT ID, Name, Path, Date, Description FROM Pics";

  if (!($connection = @ mysql_pconnect($hostName, 
                                    $username,
                                    $password)))
     showerror();

  if (!mysql_select_db("fermpics", $connection))
     showerror();
        
  if (!($result = @ mysql_query ($query, $connection)))
     showerror();
?>
    <h1>Image database</h1> 

    <h3>Click <a href="insert.php">here</a> to 
upload an image.</h3>
<?php 
  //require 'disclaimer';

  if ($row = @ mysql_fetch_array($result))
  {
?>

    <table>
    <col span="1" align="right">
    <tr>
       <th>File Name</th>
       <th>Date</th>
       <th>Image</th>

    </tr>
<?php
   do 
   {
?>
    <tr>
       <td><?php echo "{$row["Name"]}";?></td>         
       <td><?php echo "{$row["Date"]}";?></td>
       <td><?php echo "<img src=\"C:\wamp\www\fermpix\Pics\'{$row["Name"]}'\">";?></td>
    </tr>
<?php
   } while ($row = @ mysql_fetch_array($result));
?>
    </table>
<?php
  } // if mysql_fetch_array()
  else
     echo "<h3>There are no images to display</h3>\n";
?>
</body>
</html>

I would appreciate any help.

Cheers
Paul

I have a php page which is ran after a form is posted from the previous page. I am having trouble getting the SQL strings to work. When the page is ran online there is no WSOD or error message but the tables in my database are not being updated. Any help with this would be greatly appreciated. Attached Files  payment.php   1.79KB   4 downloads

I use mysql and this code that I will show says that the info was sucessfully updated, but it wasnt.  please help.  By the way, I am designing a website for a boy scout troop that has asked me to help.  any help appreciated:
Code: [Select]
<?php
session_start(); // Must start session first thing
/*
Created By Adam Khoury @ [URL=http://'http://www.flashbuilding.com/']www.flashbuilding.com[/URL]
-----------------------June 20, 2008-----------------------
*/
// Here we run a login check
if (!isset($_SESSION['id'])) {
echo 'Please <a href="login.php">log in</a> to access your account';
exit();
}
//Connect to the database through our include
include_once "connect_to_mysql.php";
// Place Session variable 'id' into local variable
$id = $_SESSION['id'];

// Query member data from the database and ready it for display
$sql = mysql_query("SELECT * FROM members WHERE id='$id' LIMIT 1");
while($row = mysql_fetch_array($sql)){
$rank = $row['rank'];

}



// Process the form if it is submitted
if ($_POST['rank']) {
$rank = $_POST['rank'];
$sql = mysql_query("UPDATE members SET rank='$rank' where id='$id'");
echo 'Your account info has been updated, visitors to your profile will now see the new info.<br /><br />
<meta HTTP-EQUIV="REFRESH" content="3; url=http://final.net46.net/myprofile.php">';
exit();
} // close if post
?>



<!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>
</head>

<body>
<form id="form1" name="form1" method="post" action="scout.php" onsubmit="return validate_form ( );">
  <label for="rank"></label>
  <select name="rank" id="rank">
    <option value="Scout">Scout</option>
    <option value="Tenderfoot">Tenderfoot</option>
    <option value="Second Class Scout">Second Class Scout</option>
    <option value="First Class Scout">First Class Scout</option>
    <option value="Star Scout">Star Scout</option>
    <option value="Life Scout">Life Scout</option>
    <option value="Eagle Scout">Eagle Scout</option>
    <option value="<?php echo $rank; ?>" selected="selected"></option>
  </select>
  <input type="submit" name="submit" id="submit" value="Save" />
</form>
</body>
</html>

Hey guys so my code below is not working, it will get the app information for the user but its only display 3 results like every time a new user "installs" an new app like it stops showing the last result and starts displaying the new result. Like for example right now it should be showing 7 results but only displaying 3 is there something wrong with my query. (PS: this is just developement testing purposes so thats why my code is sorta sloppy) Thanks!

$default_apps = mysql_query("SELECT * FROM apps WHERE `default`='1'") or die(mysql_error());
$user_apps = mysql_query("SELECT * FROM user_apps WHERE `user_id`='$user_id'") or die(mysql_error());
while($row = mysql_fetch_array($default_apps))
{
$url = $row['download_url'];
$name = $row['name'];
   echo $row['name'];
   echo "<a href='$url'>$name</a><br />";
} 
while($raw = mysql_fetch_array($user_apps)){
$app_id = $raw['app_id'];
}
$select_user_apps = mysql_query("SELECT * FROM apps WHERE `app_id`='$app_id' ");
while($rop = mysql_fetch_array($select_user_apps))
{
$name = $rop['name'];
$url = $rop['download_url'];
echo $name;
echo $url;
}

This is my first project. Just a simple registration form. it will connect to the server but I can't convince it to select the the database 'learnphp'.


<?php
if($_POST['formSubmit'] == "Submit") 
    {
if(empty($_POST['formName'])) 
        {
$errorMessage .= "<li>You forgot to enter your Name.</li>";
}

if(empty($_POST['address'])) 
        {
$errorMessage .= "<li>You forgot to enter your address.</li>";
        }
        
if(empty($_POST['city'])) 
        {
$errorMessage .= "<li>You forgot to enter your city.</li>";
}
        
if(empty($_POST['state'])) 
        {
$errorMessage .= "<li>You forgot to enter your state.</li>";
}

if(empty($_POST['zip'])) 
{
$errorMessage .= "<li>You forgot to enter your zip code.</li>";
}

if(empty($_POST['phone'])) 
        {
$errorMessage .= "<li>You forgot to enter your phone number.</li>";
}

    if(empty($_POST['email'])) 
        {
$errorMessage .= "<li>You forgot to enter your email.</li>";
}
        
        }


$varformName = $_POST['formName'];
$varaddress = $_POST['address'];
$varcity = $_POST['city'];
$varstate = $_POST['state'];
$varzip = $_POST['zip'];
$varphone = $_POST['phone'];
$varemail = $_POST['email'];



 
        
        
//generated by fatcow


$link = mysql_connect('', '', ''); 
if (!$link) { 
    die('Could not connect: ' . mysql_error()); 
   }  
echo 'Connected successfully'; 
$db_selected = mysql_select_db("learnphp"); 

   if (!$mysql_select_db) { 
    die(' blast!' . mysql_error()); 
   }
       if(!empty($errorMessage))  {
   echo("<p>There was an error with your form:</p>\n");
   echo("<ul>" . $errorMessage . "</ul>\n");
 }
     
 

$sql = "INSERT INTO membership (memberName, address, city, state, zip, phone, email) VALUES (".
PrepSQL($varmemberName) . ", " .
PrepSQL($varAddress) . ", " .
PrepSQL($varCity) . ",";
PrepSQL($varState) . ",";
PrepSQL($varZip) . ",";
PrepSQL($varPhone) . ",";
PrepSQL($varEmail) . ",";
mysql_query($sql);

//header("Location: thankyou.html");
exit();



            
    // function: PrepSQL()
    // use stripslashes and mysql_real_escape_string PHP functions
    // to sanitize a string for use in an SQL query
    //
    // also puts single quotes around the string
    //
    function PrepSQL($value)
    {
        // Stripslashes
        if(get_magic_quotes_gpc()) 
        {
            $value = stripslashes($value);
        }

        // Quote
        $value = "'" . mysql_real_escape_string($value) . "'";

        return($value);
    }
   
?>

<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<meta http-equiv="Content-type" content="text/html;charset=UTF-8">

<head>
    <title>membership test</title>
</head>

<body>
<?php
    if(!empty($errorMessage)) 
    {
    echo("<p>There was an error with your form:</p>\n");
    echo("<ul>" . $errorMessage . "</ul>\n");
            }
        ?>
       
<form  action="form.php" method="post" name="ohta_membership_application" >
Name: <input type="text" name="formName" maxlenghth="45" value="<?=$varformName;?>" />
Address: <input type="text" name="address" maxlenghth="4" value="<?=$varAddress;?>" />
City: <input type="text" name="city" maxlenghth="4" value="<?=$varCity;?>" />
State: <input type="state" name="state" maxkength="2" value="<?=$varState;?>">
Zip: <input type="text" name="zip" maxlenghth="4" value="<?=$varZip;?>" />
Phone: <input type="text" name="phone" maxlenghth="4" value="<?=$varPhone;?>" />
Email: <input type="text" name="email" maxlenghth="4" value="<?=$varEmail;?>" />
<input type="submit" name="formSubmit"  value="Submit" />
 <input type="reset" name="reset" value="Reset" >

</form>

</body>
</html>