PHP - Why Does This Work???

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>

Hi, me again;

i'm curious why this don't work and what would in it's replace;

echo "<b>".$row['name'].['id']."</b><BR>";

basically what I'm trying to do is that it read like this

Your in game name is ['name'] with id set to ['id']

I figure if I can get the name and id beside each other I can figure out how to the add the your in game name is and with id set to part myself

sorry guys don't mean to be a bother

Hi

I am having trouble with a login code which keeps producing a true value even when the password is incorrect.  Just spent 4 hours writing code and I think I've gone a bit coo coo:

Code: [Select]
<h1>Login</h1>
<p>If you are an existing member please login below. If you are new to this site please register to obtain your unqiue login and password by <a href="register.php">clicking here.</a></p>


<?php
require_once('common.php');

$error = '0';

if (isset($_POST['login'])){
    // Get user input
    $username = isset($_POST['username']) ? $_POST['username'] : '';
    $password = isset($_POST['password']) ? $_POST['password'] : '';
        
    // Try to login the user
    $error = loginUser($username,$password);
}

?>

<?php if ($error != '') {?>
      <form action="<?php echo $_SERVER['PHP_SELF']; ?>" method="post" name="loginform">
        <table width="100%">
          <tr><td>Username:</td><td> <input name="username" type="text"  /></td></tr>
          <tr><td>Password:</td><td> <input name="password" type="password" /></td></tr>
          <tr><td colspan="2" align="center"><input type="submit" name="login" value="Login" /></td></tr>
        </table>
      </form>

      &nbsp;<a href="register.php">Register</a>
<?php
}
    if (isset($_POST['login'])){
?>
        <table width="100%"><tr><td><br/>
<?php
    if ($error == '') {
        echo "<h1>Welcome $username! <br/>You are logged in!</h1><br/><br/>";
        echo '<a href="browse_index.php"><h2>Now you can start shopping! ---CLICK HERE---</h2></a>';
    }
    else echo $error;

?>
        <br/><br/><br/></td></tr></table>
<?php
    }
?>


Code for Common.php:

?php
function loginUser($user,$pass){
    $errorText = '';
    $validUser = false;
    
    // Check user existance    
    $pfile = fopen("users.txt","r");
    rewind($pfile);

//$counter=0;

    while (!feof($pfile)) {
        $line = fgets($pfile);
        $temp = explode(':', $line);
        if ($temp[5] == $user) {
            // User exists, check password
            if (trim($data[0]) == trim(md5($pass))){
                $validUser= true;
                $_SESSION['userName'] = $user;

//$counter = $counter + 1;

//echo $data;
            }
            break;
        }
    }
    fclose($pfile);

    if ($validUser != false) $errorText = "Invalid username or password!";
    
    if ($validUser == true) $_SESSION['validUser'] = true;
    else $_SESSION['validUser'] = false;
    
    return $errorText;    
}

function logoutUser(){
    unset($_SESSION['validUser']);
    unset($_SESSION['userName']);
}

function checkUser(){
    if ((!isset($_SESSION['validUser'])) 
         || ($_SESSION['validUser'] != true)){
        header('Location: login.php');
    }
}
?> 

Well, for those of you who use facebook, if you move pages from messages, to feed, to events or anything like that, you will notice the entire page doesn't load. At first, I though there must be some Ajax involved but then I realised that the page url is changing with new GET variables.

So what is going on? What are they doing?

Ok strange one.  I have an image upload script.  It works fine and the image uploads and puts its name in my database.  I also then post the name to the next page.  Here is the image uploader

<?php
if (isset($_POST['insert_image']))
{
$folder = "../../images/image_box/";
move_uploaded_file($_FILES["photo"]["tmp_name"] , "$folder".$_FILES["photo"]["name"]) or die(mysql_error());
//connect to database
include('../../Connections/database.php'); 
$photo = $_FILES["photo"]["name"];

$qInsert = "INSERT INTO `photos` 
(`photo_name`)
VALUES                    
('".$photo."')";
$rInsert = mysql_query($qInsert) or die(mysql_error()); 
 //Tells you if its all ok 
 if ($rInsert) {
 $url = "add_image_to_album.php?image_name='".$photo."'" or die(mysql_error());        
header("Location: ".$url.""); 
}
else {
$errors = "There was an error inserting the image into the database";
}
}
?>


Notice I then post the image name  to the next page.

Now on the next page I have only this

<?php include('../../Connections/database.php'); 
session_start();?>
   <?php echo '".$_GET['image_name']."' ;?>


But there is an error at line one but I have tested the connection and its fine so its erroring displaying for example;

landscape.png

Does it have something to do with the .png in the name? If so how do i solve this?

I'm sorry if this maybe is an obvious understanding for you, but i can't understand one thing with URL's.

If i create my page called "index.php" and put it in a folder called "folder" then the URL in the address bar would be: http://www.website.com/folder/index.php

But then i deside to add a few more pages with like next and previous links to scroll through them. I put those pages in a folder called "pages" within the folder "folder". Now the URL's would something look like this!

http://www.website.com/folder/pages/page1.php
http://www.website.com/folder/pages/page2.php
etc...

Thats the only way i know URL's are created and look like. But now too my question..

This is a few URL's i've seen on a site and every URL leeds to a new page but there is no slashes indicating new folders? How do you do that? Here is some examples of how the URL's could look like:

http://www.website.com/index.php
http://www.website.com/index.php?p=new
http://www.website.com/index.php?p=new&page=121
http://www.website.com/merge.php
http://www.website.com/merge.php?id=20381

And every URL was a comnpletly new page? 

Hello, I am trying to make this work.  what i am trying to do is to make a function that changes a variable back and forth. for example, I need to have a variable $bgcolorplace that is set to 1, as soon as the function is executed the variable $bgcolorplace changes to 0.  The next time the function executes, variable should turn to 1 again.  This pattern should repeat forever only when the function is executed.  I am trying to use this to change the background color of a generated HTML code which will be on the webpage.  Here is my script.

<?php
$input=($_GET['inputText']);      //get info from JS
$ItemNum='Item'.$input;           //make a var with contents "Item" + the info from JS to display later
$bgcolorplace;                           //var that keeps track of what color to make the next background
$bgcolor;                                    //keeps the color of the background for this execution
function changebgcolor(){         
  if ($bgcolorplace=="0"){           
        $bgcolorplace="1";
                  //$bgcolor="444444"
        echo("0 to 1<br/>".$bgcolorplace."<br/>");//display which part of code is executed 1 to 0 or 0 to 1(can never get the script to run this part), this line is temp/test code
     }else{
        $bgcolorplace="0";
                  //$bgcolor="ffffff"
        echo("1 to 0<br/>".$bgcolorplace."<br/>");   //display which part of code is executed 1 to 0 or 0 to 1(It works), this line is temp/test code
     }
}
//this next section I have temporarily commented for testing purposes, this section works fine 
/*$out="<tr bgcolor=#'".$bgcolor."' id='".$input."'><td align='center' width='5%'>".$input."</td><td align='center' width='30%'>bible</td><td align='center' width='50%'>Softcover</td><td align='center' width='5%'>45</td><td align='center' width='5%'>1</td><td align='center' width='5%'>45</td></tr>";*/

if ($input=='123'){
      changebgcolor();
      //echo($out);
}else{
   echo('none');
}
?>

I get a responds of this everytime

1 to 0
1

this means that the function is being processed, but the value of $bgcolorplace is always a 1, it never changes to 0 like I am trying to inside the IF Else Statement.  The commented Items are just my code that I have temp disabled while I try to figure out why my IF Else statement doesnt work.  Help is much appreciated, and thank you in advanced.

Here is my code:

<?php
   class ScheduleRecord {
      private $month;
      private $day;
      private $year;
      private $hour;
      private $minute;
      private $type;
      private $employeeNumber;
      
      public function __construct($employeeNumber, $type, $month, $day,
      $year, $hour, $minute) {
         $this->employeeNumber = $employeeNumber;
         $this->type = $type;
         $this->month = $month;
         $this->day = $day;
         $this->year = $year;
         $this->hour = $hour;
         $this->minute = $minute;
      }
      
      public function getType() {
         return $this->type;
      }
      
      public function getEmployeeNumber() {
         return $this->employeeNumber;
         
      }
      
      public function getMonth() {
         return $this->month;
      }
      
      public function getDay() {
         return $this->day;
      }
      
      public function getYear() {
         return $this->year;
      }
      
      public function getHour() {
         return $this->hour;
      }
      
      public function getMinute() {
         return $this->minute;
      }
      
      public function getType() {
         return $this->type;
      }
   }
   
   $shcRec = new ScheduleRecord(3, "DayIn", 04, 04, 04, 04, 04);
   echo $shcRec ->getEmployeeNumber();
?>
error:
The page cannot be displayed because an internal server error has occurred.

the last line seems to be the problem.

So I wanted to use a \ in order to stop PHP from registering my quotes.  For some reason it does not seem to work.  I am running PHP version 5.3.8.   What am I doing wrong?

hi all,

i have been struckling with this code of mine

i want when i click a link to change the setting for the menu (see code)

Code: [Select]
<? echo "[".$_SESSION['menu']."]"; ?>
<table class="border_test">
  <tr>
    <td valign="top" align="left">
      <!-- menu items: menu -->
      <img src="../design/item.png" width="10" height="10"><a href="<?=$_SERVER['REQUEST_URI'];?>" onclick="<? $_SESSION['menu']=1;?>"><b>&nbsp;Site menu:</b></a>
    </td>
  </tr>
  <? if($_SESSION['menu']==1) { echo '
  <tr>
    <td>
      &nbsp;&nbsp;&nbsp;<img src="../design/subitem.png" width="10" height="10">&nbsp;<a href="?topic=add_menu">Toevoegen menu item.</a><br>
      &nbsp;&nbsp;&nbsp;<img src="../design/subitem.png" width="10" height="10">&nbsp;<a href="?topic=edit_menu">Bewerken menu item.</a><br>
      &nbsp;&nbsp;&nbsp;<img src="../design/subitem.png" width="10" height="10">&nbsp;<a href="?topic=del_menu">Verwijderen menu item.</a>
    </td>
  </tr>'; } ?>
  <tr>
<td>
      <!-- menu items: submenu -->
      <img src="../design/item.png" width="10" height="10"><a href="<?=$_SERVER['REQUEST_URI'];?>" onclick="<? $_SESSION['menu']=2;?>"><b>&nbsp;Site submenu:</b></a>
    </td>
  </tr>
  <? if($_SESSION['menu']==2) { echo '
  <tr>
    <td>
      &nbsp;&nbsp;&nbsp;<img src="../design/subitem.png" width="10" height="10">&nbsp;<a href="?topic=add_submenu">Toevoegen submenu item.</a><br>
      &nbsp;&nbsp;&nbsp;<img src="../design/subitem.png" width="10" height="10">&nbsp;<a href="?topic=edit_submenu">Bewerken submenu item.</a><br>
      &nbsp;&nbsp;&nbsp;<img src="../design/subitem.png" width="10" height="10">&nbsp;<a href="?topic=del_submenu">Verwijderen submenu item.</a>
    </td>
  </tr>'; } ?>
  <tr>
    <td>
      <!-- menu items: Pagina's -->
      <img src="../design/item.png" width="10" height="10"><a href="<?=$_SERVER['REQUEST_URI']; ?>"><b>&nbsp;Pagina's:</b></a>
    </td>
  </tr>
</table>

so what it wil do is show the subitem list of the main menu item when de var is changed!

butt when i use it it always set to the last ( in this case to: 2 ) even when i click the first link to set it to 1

can somebody help me to get it to work?


thnx,

All i get is a link to view all partners. What I want to see is all the people in the database and how many comments each has.
Anyone?
Was on last night but still couldn't get it woking

Code: [Select]
<?php

$db = mysql_connect('--', '--', '-!');
if (!$db)
  {
  die('Could not connect: ' . mysql_error());
  }
mysql_select_db ('-',$db);

$max_items = 5;

function displayPartners($all = 0){

global $db, $max_items;

if ($all == 0){

$query = "SELECT id,title, DATE_FORMAT(postdate, '%Y-%m-%d') as date FROM partners ORDER BY postdate DESC LIMIT $max_items";
}else{
$query = "SELECT id,title, DATE_FORMAT(postdate, '%Y-%m-%d') as date FROM partners ORDER BY postdate DESC";
}


if (!$db)
while ($row = mysql_fetch_assoc($result)){
echo "&lt;TABLE border = \"1\" width=\"300\&gt;\n";
$date = $row['date'];
$title = htmlentities ($row['title']);

echo "&lt;TR&gt;&lt;TD&gt;&lt;b&gt;$title&lt;/b&gt;posted on $date&lt;/TD&gt;&lt;/TR&gt;\n";
echo "&lt;TR&gt;&lt;TD&gt;$partners&lt;/TD&gt;&lt;/TR&gt;\n";

$comment_query = "SELECT count(*) FROM comment WHERE partners_id ={$row['id']}";
$comment_result = mysql_query ($comment_query);
$comment_row = mysql_fetch_row($comment_result);

echo "&lt;TR&gt;&lt;TD&gt;&lt;ahref=\"{$_SERVER['PHP_SELF']}" . "?action = show&amp;id={$row['id']}\&lt;Comments&lt;/a&gt;($comment_row[0]}&lt;/TD&gt;&lt;/TR&gt;\n)";

echo "&lt;/TABLE&gt;\n";
echo "&lt;BR&gt;\n";
}
 if ($all == 0){

echo "<a href =\"{$_SERVER['PHP_SELF']}?action=all\">View all Partners</a>\n";
}
}
function displayOneItem($id){
global $db;

$query = 'SELECT * FROM partners WHERE id = $id';
$result = mysql_query ($query);

if (mysql_num_rows ($result) == 0){
echo 'No partners found ';
return;
}
$row = mysql_fetch_assoc($result);
echo "&lt;TABLE border =\"1\" width=\"300\&gt;\n";
$title = htmlentities ($row['title']);

echo "&lt;TR&gt;&lt;TD&gt;&lt;b&gt;$title&lt;/b&gt;&lt;/TD&gt;&lt;/TR&gt;\n";
echo "&lt;TR&gt;&lt;TD&gt;$partners&lt;b&gt;/TD&gt;&lt;/TR&gt;\n";

echo "&lt;/TABLE&gt;\n";
echo "&lt;BR&gt;\n";

displayComments($id);

}
function displayComments($id){

global $db;

$query = "SELECT * FROM comment WHERE partners_id=$id";
$result = mysql_query ($query);

echo "Comments:&lt;BR&gt;&lt;HRwidth=\"300\"&gt;\n";

while ($row = mysql_fetch_assoc ($result)){

echo "&lt;TABLE border=\"1\"width=\"300\"&gt;\n";

$name = htmlentities ($row['name']);
echo "&lt;TR&gt;&lt;TD&gt;&lt;b&gt;by:$name&lt;/b&gt;&lt;/TD&gt;&lt;/TR&gt;\n";

$comment = strip_tags ($row['comment'],'&lt;a&gt;&lt;b&gt;&lt;i&gt;&lt;u&gt;');
$comment = nl2br ($comment);

echo "&lt;TR&gt;&lt;TD&gt;$comment&lt;/TD&gt;&lt;/TR&gt;\n";

echo "&lt;/TABLE&gt;\n";
echo "&lt;BR&gt;\n";
}
echo "&lt;HR width=\"300\"&gt;";
echo "&lt;FORM action=\"{$_SERVER['PHP_SELF']}" . "?action=addcomment&amp;id=$id\"method=POST&gt;\n";
echo "Name: &lt;input type=\"text\" " . "width=\"30\"name=\"name\"&gt;&lt;BR&gt;\n";

echo "&lt;TEXTAREA cols=\"40\" rows=\"5\" " . "name=\"comment\"&gt;&lt;/TEXTAREA&gt;&lt;BR&gt;\n";
echo "&lt;input type=\"submit\"name=\"submit\" " ."value=\"Add Comment\"\n";
echo "&lt;/FORM&gt;\n";
}
function addComment($id) {
global $db;
$query = "INSERT INTO comment " . "VALUES('',$id,'{$_POST['name']}'," . "'{$_POST['comment']}')";
mysql_query ($query);

echo "Comment submitted&lt;BR&gt;\n";
echo "&lt;a href=\"{$_SERVER['PHP_SELF']}" . "?action=show&amp;id=$id\"&gt;Back&lt;/a&gt;\n";
}

echo "&lt;CENTER&gt;\n";
switch($_GET['action']) {

case 'show':
displayOneItem($_GET['id']);
break;
case 'all':
displayPartners(1);
break;
case 'addcomment':
addComment($GET['id']);
break;
default:
displayPartners();
}
?>

So, I have part of this snippet of code in my homepage and it pops up an inner window notification that briefly displays and then goes away...I'm looking to do it for a non-index.php page and it just isnt working. In the index.php page, it automatically occurs when the form loads and in this case, I need to invoke it...any help would be awesome..

 

It is the section where I'm echoing the JS script that isn't working.

 

<?php

if($_GET){

    if(isset($_GET['add'])){
/* Attempt MySQL server connection. Assuming you are running MySQL
server with default setting (user 'root' with no password) */
$link = mysqli_connect("localhost", "root", "test", "vendors");
 
// Check connection
if($link === false){
    die("ERROR: Could not connect. " . mysqli_connect_error());
}
$name = mysqli_real_escape_string($link, $_REQUEST['vendor']);
$company = mysqli_real_escape_string($link, $_REQUEST['company']);
$type = mysqli_real_escape_string($link, $_REQUEST['type']);
$email = mysqli_real_escape_string($link, $_REQUEST['email']);
$soc = mysqli_real_escape_string($link, $_REQUEST['soc']);
$status = mysqli_real_escape_string($link, $_REQUEST['status']);

// Attempt insert query execution
$sql = "INSERT INTO vendor_data (name, company, type, email, soc, status) VALUES ('$name', '$company', '$type', '$email', '$soc', '$status')";
if(mysqli_query($link, $sql)){
		echo ' 	<script type="text/javascript">
					$(document).ready(function(){

					demo.initChartist();

					$.notify({
					icon: "pe-7s-gift",
					message: "TESTING!"				
            },{
                type: "info",
                timer: 4000
            });

    	});
	</script>';
} 
else{
    echo "ERROR: Could not able to execute $sql. " . mysqli_error($link);
}
 
// Close connection
mysqli_close($link);
      
    }

}


?>
<!doctype html>

 

Hi everybody *asian accent*,
im trying to figure out how to display xml in php

i know how to do things like


      <condition>
        <conditionId>4000</conditionId>
        <conditionDisplayName>Very Good</conditionDisplayName>
      </condition>

for each blah blah as $item

$condition = $item->condition->conditionId

echo $condition;





BUT........how do i get these values in XML to display in php

this <searchResult count="2">

I want to get the value of count to display


help please

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>

echo "<div id='wrap'><div id='header'>" . implode("</div>", array_keys($sports)) . ; 

I get the following error:

Parse error: syntax error, unexpected ';' in /hermes/bosweb/xxxxx/xxx/xxxxxxxxxxxxxxxx/xxxxx/xxx_xxxx/xxx_xxxxxx.php on line 75

The above line is 75.  I have changed the quotes using ' ' or " " and no matter what I do I continue to get errors.. where am I going wrong here? 

Thanks!