PHP - Want To Know Whats Going On Here?

Ive created a process which automatically creates a form for all of the "courses" that are listed in a database. This table shows the name, the course code, the current program the course is under and an option to delete the course. I have created a drop down menu for the user to select any of the current programs to switch the course into. My problem is I have X amount of select fields and radio buttons and I dont know how to tell which one has been changed below is my code, appreciate the help!:



        case "ep":
        
        if (isset ($_GET['id'])){
            $id = $_GET['id'];
                    echo "Below lists all of the current courses under this program. Once you have made all of the changes click the submit button at the bottom of the page. <br><br><br>";
                    $query = "SELECT * FROM courses WHERE cid = $id";
                    $result = mysql_query($query) or die (mysql_error());
                    echo "<form action=\"course_process.php\" method=\"post\">";
                    echo "<table><tr><td><strong>Course Name</strong></td><td><strong>Course Code</strong></td><td><strong>Change Course Program</strong></td><td><strong>Delete</strong></td></tr>";
                    $i = 0;
                    
                    while ($row = mysql_fetch_assoc($result)){
                        $r = $row['id'];
                        $query2 = "SELECT * from catagories";
                        $result2 = mysql_query($query2) or die (mysql_error());
                        echo "<tr><td> ". $row['name']. " </td><td> ".$row['code']." </td><td><select name=\"".$row['id']."\">";
                        
                        while ($row2 = mysql_fetch_assoc($result2)){
                        
                        echo "<option value=".$row2['id'].">".$row2['name']. "</option>";
                            }
                            
                             echo "</select></td><td><input name=\"".$row['id']."\" type=\"radio\" value=\"Click to delete\" /></td></tr>";
                    }
                    echo "<tr><td></td><td></td><td></td><td><input name=\"submit\" type=\"submit\" value=\"Commit Changes\" /> </td></tr></table></form>";
                    
                    
                }else{
                    echo "Invalid action request. ERROR CODE 1";
                    
                }
                
        break;

Cant Figure Out Whats Wrong With it..
Code:
Code: [Select]
<?php
if(isset($_SESSION['user']))
{
$bb = mysql_query("SELECT * FROM main WHERE id=". $_SESSION['id']) or die ("An error has occured: " . mysql_error());
while($n=mysql_fetch_array($bb)) 
{
?>
                            <div class='cs_article'>
                           
                                <div class='left'>
                                    <h2>User Control Panel</h2>
                                    <p><a href="usercp.php">User CP</a><?php 
if($n['rights'] == 1)
{
echo ", <a href="modcp.php">Mod CP</a>";
}?>
<?php
if($n['rights'] == 2)
{
echo ", <a href="aa/">Admin CP</a>";
}?>
                                   
                                    <div class='button'><a href='usercp.php'>Read more</a></div>
                                </div>
                                <div class='right'>
<h1>User CP</h1>
</div>
                                                               
                            </div>
<?php
}}
?>
What its doing: Mod-Justin Compared to Mod-Justin

can you tell me whats wrong with this?

Code: [Select]
<?php
$age= 60;
if( isset($_SESSION['logedin']) ) {
$q = mysql_query('SELECT id=`$id`, DATE_FORMAT(`last_activity`,"%a, %b %e %T") as `last_activity`,UNIX_TIMESTAMP(`last_activity`) as `last_activity_stamp`FROM `mymembers`WHERE `$logOptions_id` <> "'.($_SESSION['logedin']).'"');
$isonlinecheck = mysql_query($q);
if ($isonlinecheck ="last_activity_stamp + $age "< time()){
$isonline =  "is <font color='green'>online!</font>";}
else {
$isonline = "is<font color='red'> offline!</font>";
}

}
?>

Its a page 'Downloads'. Works great at localhost but doesnt show up @ web hosting.

Code: [Select]
<?php

define('IN_PHPBB', true);
$page = !isset($_GET["page"]) ? "None" : $_GET['page'];
$phpbb_root_path = (defined('PHPBB_ROOT_PATH')) ? PHPBB_ROOT_PATH : './';
$phpEx = substr(strrchr(__FILE__, '.'), 1);
include($phpbb_root_path . 'common.' . $phpEx);

// Start session management
$user->session_begin();
$auth->acl($user->data);
$user->setup();

page_header('Downloads');

if(strcmp($page,"org") == 0)
{
$template->set_filenames(array('body' => 'download/org.html',));
}
else if(strcmp($page,"audi") == 0)
{
$template->set_filenames(array('body' => 'download/audi.html',));
}
else if(strcmp($page,"bmw") == 0)
{
$template->set_filenames(array('body' => 'download/bmw.html',));
}
else if(strcmp($page,"vw") == 0)
{
$template->set_filenames(array('body' => 'download/vw.html',));
}
else if(strcmp($page,"nissan") == 0)
{
$template->set_filenames(array('body' => 'download/nissan.html',));
}
else if(strcmp($page,"opel") == 0)
{
$template->set_filenames(array('body' => 'download/opel.html',));
}
else if(strcmp($page,"ford") == 0)
{
$template->set_filenames(array('body' => 'download/ford.html',));
}
else if(strcmp($page,"chevrolet") == 0)
{
$template->set_filenames(array('body' => 'download/chevrolet.html',));
}
else if(strcmp($page,"other") == 0)
{
$template->set_filenames(array('body' => 'download/other.html',));
}
else
{
$template->set_filenames(array('body' => 'download/org.html',));
}

make_jumpbox(append_sid("{$phpbb_root_path}viewforum.$phpEx"));
page_footer();
?>

and the html:


Code: [Select]
<table class="tablebg" cellspacing="1" width="100%">
<tr>
<th>BMW</th>
</tr>
<tr class="row1">
<td align="center" style="padding:5px 5px 5px 5px;">
<center>
<hr width="60%" size="3" />
<table width="70%">
<tr>
<td width="10%"><a href="http://www.upload.ee/image/1626514/325i_2.jpg" target = "_blank">
<img src="http://www.upload.ee/thumb/1626514/325i_2.jpg" border="0"/></a>
<a href="http://www.upload.ee/image/1626518/325i_3.jpg">
<img src="http://www.upload.ee/thumb/1626518/325i_3.jpg" border="0"/></a>
<td width="0%"><a href="http://www.upload.ee/image/1626519/325i_1.jpg" target = "_blank">
<img src="http://www.upload.ee/thumb/1626519/325i_1.jpg" border="0"/></a>
<a href="http://www.upload.ee/image/1626521/325i_4.jpg" target = "_blank">
<img src="http://www.upload.ee/thumb/1626521/325i_4.jpg" border="0"/></a></td></td>
<td><b><font color="white">Name:</font></b> 1996 BMW 325i e36 Convertible</br>
<b><font color="white">Original Author:</font></b> ikey07</br>
<b><font color="white">Size:</font></b> 3.89MB</br></br>
<b><font color="white">Description:</font></b></br>
Tunable in WAA</br>
2 Body kits included</br>
1. BMW M e36 series + Hood Vents</br>
2. BMW M e46 series + Masked Lights</br>
New 2 M series wheels e36/e46</br>
Realistic heavy damaged model</br>
Model accuracy as real car 96%</br>
Openable petrolcap</br>
If you replace this car as BF Injection, the front fan is working ( spining )</br></br>
<a href="http://ikey07.c-rp.net/viewtopic.php?f=6&t=2"><b><font color="white">Comments</font></b></a></br>
</br>
<ul id="nav">
<a class="downl" href="http://ikey07.c-rp.net/download/1996_BMW_325i_e36.rar" title="Download"><span>{L_DOWN}</span></a>
        </div>
</br>
</td>
</tr>
</table>
<hr width="60%" size="3" />
</center>
</td>
</tr>
</table>
<br />

Good evening my PHP experts!!!

OK so heres the problem...I have been at this for about 2 DAYS now and for the life of me I just don't understand what I could possibly be doing wrong.

I have 3 of 4 variables outputting correctly but without my id being pulled from the URL NOTHING will get written to my database. I have ran some tests and I came to learn that my $_POST['id']; function is not working properly for some strange reason. As always, any help would be greatly appreciated. Please see below PHP code. I also have posted the HTML code for your reference purposes...thanks in advance. Please helpppp!!!!

Code: [Select]
<?php

session_start();

$id = '';

if (isset($_POST['password'])) {

include_once "scripts/connect_to_mysql.php";

$id = $_POST['id'];
$id  = mysql_real_escape_string($id );
$id = eregi_replace("`", "", $id);


    $cust_password = $_POST['password'];
    $hashedPass = md5($cust_password); 

$sql = mysql_query("UPDATE customers SET password='$hashedPass' WHERE id='$id'");

$update_success = 'You have successfully updated your Password. Please click <a href="customer_login.php">HERE</a> to log into your account.';

//Output to test whether or not my variables have anything in them.
//$update_success, $hashedPass, $cust_password all Output just fine. $id displays nothing at all.
echo $update_success;
echo $hashedPass;
echo $cust_password;
echo $id;

exit();

}

?>

<!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>
<link rel="stylesheet" type="text/css" href="style.css"/>

<script type="text/javascript">
<!-- Form Validation -->
function validate_form ( ) {
valid = true;
if ( document.form.password.value == "" ) {
alert ( "Password field must not be blank." );
valid = false;
}
return valid;
}
<!-- Form Validation -->
</script>

</head>

<body>

<div id="pg_container">

<!--HEADER SECTION-->
<div id="header">
<div id="header_logo"></div>
    <div id="header_right">Welcome to Built 2 Manage.</div>
</div>
<!--HEADER SECTION-->

<!--PAGE CONTAINER-->
<div id="pgbdy_container">
<form action="cust_acc_conf.php" method="post" id="form" name="form" enctype="multipart/form-data" onsubmit="return validate_form ( );">
<div id="login_header">
    <p>
        Please log into your account below.
        </p>
    </div>
   
    <div id="cust_choose_pass_form">
    <div id="cust_choose_pass_text">
        <p>
            Password:
            </p>
        </div>
        <div id="cust_choose_pass_field">   
            <p>
            <input name="password" type="text" id="password" /><br /><br />
                <input name="submit_password" type="submit" id="submit_password" value="Submit Password" /><br />
               </p>
        </div>
    </div>
    </form>
</div>

<!--PAGE CONTAINER-->

<div id="footer"></div>

</div>
</body>
</html>

Not sure what is wrong with line 17

<?php
$hostname="localhost"; //local server name default localhost
$username="root";  //mysql username default is root.
$password="";       //blank if no password is set for mysql.
$database="login";  //database name which you created
$con=mysql_connect($hostname,$username,$password);
if(! $con)
{
die('Connection Failed'.mysql_error());
}

mysql_select_db($database,$con);

//include connect.php page for database connection
Include('connect.php')
//if submit is not blanked i.e. it is clicked.
If(isset($_REQUEST['submit'])!='') 
{
If($_REQUEST['name']=='' || $_REQUEST['email']=='' || $_REQUEST['password']==''|| $_REQUEST['repassword']=='')
{
Echo "please fill the empty field.";
}
Else
{
$sql="insert into student(name,email,password,repassword) values('".$_REQUEST['name']."', '".$_REQUEST['email']."', '".$_REQUEST['password']."', '".$_REQUEST['repassword']."')";
$res=mysql_query($sql);
If($res)
{
Echo "Record successfully inserted";
}
Else
{
Echo "There is some problem in inserting record";
}

}
}
?>

Edited by Metoriium, 25 October 2014 - 05:04 PM.

Hi all,

Yeah just a fresh pair of eyes needed. It just wont insert into the table and the alert returns a blank. Only thing I can think is thats its posting variables from two different queries...but that shouldnt make a difference...

Cheers

Code: [Select]
FORM PAGE*************************

//*****************************LOGGED CHECKER*********************

$sql = "SELECT * FROM users WHERE firstName= '$logged'";

if ($result = mysql_query($sql)) {
    if (mysql_num_rows($result)) {
   if ($row = mysql_fetch_assoc($result)) {


//**************QUESTION FORM*****************************
$sql2 = "SELECT * FROM questions WHERE questionID= '$orderCounter'";

if ($result2 = mysql_query($sql2)) {
    if (mysql_num_rows($result2)) {
   if ($row2 = mysql_fetch_assoc($result2)) {

echo "<p>" . $row2['questionText'] . "</p>";

echo '<form name="form1" method="post" action="questionProcess.php">';
echo   '<input type="radio" name="q1" value="' . $row2['answer1'] . '" />' . $row2['answer1'] . '<br />';
echo '<input type="radio" name="q1" value="' . $row2['answer2'] . '" />' . $row2['answer2'] . '<br />';
echo    '<input type="radio" name="q1" value="' . $row2['answer3'] . '" />' . $row2['answer3'] . '<br />';
echo     '<input type="radio" name="q1" value="' . $row2['answer4'] . '" />' . $row2['answer4'] . '<br />';     
echo    '<input type="hidden" name="userid" value="' . $row['userid'] . '" />';
echo    '<input type="hidden" name="orderCounter" value="' . $row['orderCounter'] . '" />'   
echo    '<input type="submit" name="Submit" id="Submit" value="Next" />';
echo     '</label>';
echo    '</form>';


}
}
}

 }
 }
 }
 ?>

PROCESSING PAGE****************************************

$q1=$_POST['q1'];
$userid=$_POST['userid'];
$orderCounter=$_POST['orderCounter'];
// To protect MySQL injection
$q1 = stripslashes($q1);
$userid = stripslashes($userid);
$orderCounter = stripslashes($orderCounter);

$q1 = mysql_real_escape_string($q1);
$userid = mysql_real_escape_string($userid);
$orderCounter = mysql_real_escape_string($orderCounter);

//ALERT CHECKER
function confirm($msg)
{
echo "<script langauge=\"javascript\">alert(\"".$msg."\");</script>";
}
$msg = $userid;
confirm($msg);
//ALERT CHECKER

if
($q1 == "" ) {
$wrong = '<div id="blackText"><p>Please Answer the Question<p></div>';
}

else {
$sql="INSERT INTO $tbl_name (userid, value, orderCounter) VALUES ('$userid', '$q1', '$orderCounter')";
$result=mysql_query($sql);
}

ob_end_flush();
?>

hi all,

Is this line right? Im trying to say if the cookie has not been created create it and set as default value = 0
however i dont think this is right:

Code: [Select]
$points = $_COOKIE["points"] ? $_COOKIE['points']:0;
thanks,

I can't honestly see whats wrong with this code,
it's print'ing correct with the print_r.
Code: [Select]
Array ( [value1] => 2 [option] => - [value2] => 1 )
however i can't actually echo out the value1,value2 or option?
It says the vars are empty yet it can still print_r the values so i know there not empty
Code: [Select]
<?php
if(isset($_POST["submit"])){
$value1=$_POST["value1"];
$value2=$_POST["value2"];
$option=$_POST["option"];
}
print_r($_POST);
echo"$value1";
?>
<form action="index.php" name="submit" method="post">
<input type="text" name="value1">
<select name="option">
  <option>+</option>
  <option>-</option>
  <option>*</option>
  <option>/</option>
</select>
<input type="text" name="value2">
<input type="submit" value="submit">
</form>

hello.

i have a column called "pageName" and on the each page i have put $pName = "the name of that page".

i want to pull from the database all the information where the $pName on the page is the same as the pageName in the database

its getting the $pName = "adminHome" but it thinks its the name of the column not the row.

this is the error im getting:

Quote

DATABASE.PHP - confirm_query = MySQL Datatbase Query Failed: Unknown column 'adminHome' in 'where clause'

Last SQL query: SELECT * FROM pages WHERE pageName=adminHome



this is the function code
Code: [Select]
public static function find_by_pageName($pName=""){
global $database;
$sql = "SELECT * FROM ".self::$table_name." WHERE pageName=".$database->escape_value($pName)."";
$result_array = self::find_by_sql($sql);
return !empty($result_array) ? array_shift($result_array) : false;
}


this is the page code
Code: [Select]
<?PHP
require_once("../includes/initialize.php");

$pName = "adminHome";

$page = Pages::find_by_pageName($pName);
?>



thanks
rick

This topic has been moved to CSS Help.

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

Hello,   I am trying to make 'onclick img' that will provide a Linux command when clicked. I've been trying this code:

<body>
<?php
	include("connect.php");
	include('Net/SSH2.php');
        *** CONNECTION TO DATABASE MYSQL CODE ***
	if(mysql_num_rows($result) > 0)
    {
		while($row = mysql_fetch_array($result))
		{
			$_SESSION['logged'] = true;
			$ssh = new Net_SSH2('xx.xx.xx.xx');
			if (!$ssh->login($info['username'], $info['password'])) 
			{
				exit('Connection to Linux has failed, please try again.');
			}
			echo '<form action="" method="GET">';
			echo '<input type="image" src="start.png" width=100 height=100 name="start" />';
			echo '</form>';
			if(isset($_GET['start'])) 
			{
				echo $ssh->setTimeout(5);
				echo $ssh->exec('(cd '.$info['username'].' ; nohup ./samp03svr &)');
			}
		}
	}
    else
    {
		$_SESSION['logged'] = null;
		header("Location: loginfail.php");
	}
?>
</body>

But when I clicked the image, it sends me to "loginfail.php". Please help ><

This topic has been moved to Miscellaneous.

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

This topic has been moved to HTML Help.

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

hi all,
I have possibly up to 9 images that I want to find and show on a webpage.

I am trying to put a $file in a loop and get all the .jpg images that are found in to an array and show them all.

I think from the script you can see what I am attempting to do!

Any pointers would be grateful for


<?php
while($i=0 $i < 9 $i++) {
$file = "aircraft/".$_GET['reg'].$i.".jpg";
}
foreach($file) {
echo "<li class=\"active\"><img src=\"./aircraft/".$reg.$i.".jpg\" alt=\"Flowing Rock\" style=\"width: auto; height: 70px; margin-left: -28.5px; display: block;\" class=\"thumb\" ><br />";
}
?>