PHP - If Field Contains Data, Show Image

could  anyone pls check this coding? i need to display the data from database into the text field  for editing then submit to the existing database.


mysql_select_db("uni", $con);

$sql=mysql_query("select * from student");

         $res=0;

while($row=mysql_fetch_array($sql))
{
   if($row['StudentID']==$_POST["sid"])
   
{
   ?>
 <form id="form2" name="form2" method="post" action="update.php">   
 
  <h2><p><?php echo "StudentID   :" ?> <input type="text" name="sid" id="sid" value="<?php echo"".$row['StudentID'] ?>" />
 
  <p><?php echo "StudentName   :" ?> <input type="text" name="stname" id="stname" value="<?php echo"".$row['StudentName'] ?>" /> </p>
 
 
 <?php
     $res=1;
   }
   
}?> <h2> <?php
 

if($res==0)
{
   echo "Please enter the Correct ID. ";   
}





update.php

mysql_select_db("uni", $con);

mysql_query("UPDATE student SET StudentID = .$row['StudentID']
WHERE student.StudentID = '.$row['StudentID']'");

mysql_query("UPDATE student SET StudentName = .$row['StudentName']
WHERE student.StudentID = '.$row['StudentID']'");

echo "Successfully Edited";

//submit button

Basically I have a date of birth field (date) now how would I go about splitting that date field into 3 variables $year $month and $day?

Any small push forward is much appreciated, I have searched but it seems that I might not be putting it into words correctly.

Actually while writing this I suppose I might of thought of the solution
Code: [Select]
<?php

$year = date('Y', strtotime($row['dob']));
$month = date('m', strtotime($row['dob']));
$day = date('d', strtotime($row['dob']));
?>

Would that be how you would go about it?

Okay, so I'm trying to run a query to pull the information from a specific item that they click on in order to edit it.

When I run an echo $query, though, it shows the field names rather than the information from the table.

How can I make it so that it pulls the information rather than the field names?

Here's what I have...


<?php
include("lib.php");
define("PAGENAME", "Edit Equipment");

if ($player->access < 100)

$msg1 = "<font color=\"red\">"; //name error?
$error = 0;

$query = $db->execute("SELECT * FROM items WHERE id=?", array($_POST['id']));

echo "$id";

$result = mysql_query($query);

echo "$query";

$data = mysql_fetch_assoc($result); 

$msg1 .= "</font>"; //name error?


?>


Thanks!!

I have a table for collecting airline satisfaction survey results(see attached image).  I run a query to select the staff field there are 25 rows in this column I run a switch case block to filter out a result set that includes the responses 'poor', 'fair', 'good', and 'excellent' the result set should contain 20 elements

Code: [Select]
function score_staff() {
$staff_count = 0;
$result_set_cnt = 0;

$query = "SELECT staff FROM flight_survey";
$result = mysql_query($query);
while ($get_info = mysql_fetch_row($result)){
foreach ($get_info as $field){
switch($field) {
case "poor":
$staff_count++;
$result_set_cnt++;
$exit;

case "fair":
$staff_count+=2;
$result_set_cnt++;
$exit;

case "good":
$staff_count+=3;
$result_set_cnt++;
$exit;

case "excellent":
$staff_count+=4;
$result_set_cnt++;
$exit;

drfault:
// do nothing
}
}
}
echo $staff_count."<br>";
echo $result_set_cnt."<br>";
}

For each match I add 1 to the result set so with 20 matches  $result_set_cnt should be 20 and not 53 as shown at the bottom of the attached image.  The array $get_info bewilders me and I can't seem to access it's elements without putting it in a while loop.  Anyway I'm pretty new to php and have a lot to learn.  If anyone can explain how I could change the code so that the result set would contain 20 I think I'll be alright.  thanks

Hi all expert. I am a newbie in this PHP programming. I need your help or advise on the PHP. And question is, I have a list of data and the details are as below: ID  BILLNO   DATE        AMOUNT   ITEM   DESCRIPTION   QTY   UPRICE
1   IV001   01/01/2015   100.00   A1     Balloon        1    30.00
2   IV001   01/01/2015   100.00   A2         Bag        2    20.00
3   IV001   01/01/2015   100.00   A3         Pen        3    10.00
4   IV002   02/01/2015    20.00   A3         Pen        2    10.00
5   IV003   02/01/2015    50.00   A1     Balloon        1    30.00
6   IV003   02/01/2015    50.00   A2         Bag        1    20.00     How can I make the output in xml by using PHP to output as below: <RECORD>
  <HEADER BILLNO="IV001" DATE="01/01/2015" AMOUNT="100.00>
    <DETAIL ITEM="A1" DESCRIPTION="Balloon" QTY="1" UPRICE="30.00">
    </DETAIL>
    <DETAIL ITEM="A2" DESCRIPTION="Bag" QTY="2" UPRICE="20.00">
    </DETAIL>
    <DETAIL ITEM="A3" DESCRIPTION="Pen" QTY="3" UPRICE="10.00">
    </DETAIL>
  </HEADER>
  <HEADER BILLNO="IV002" DATE="02/01/2015" AMOUNT="20.00>
    <DETAIL ITEM="A3" DESCRIPTION="Balloon" QTY="2" UPRICE="10.00">
    </DETAIL>
  </HEADER>
</RECORD>     Your feedback is highly appreciated. Thank you.

I want to show data for logged in user, i am using sessions to login. This is the code i already have:
// Connect to server and select database.
mysql_connect("$host", "$username", "$password")or die("cannot connect");
mysql_select_db("$db_name")or die("cannot select DB");



//this selects everything for the current user, ready to be used in the script below

$result = mysql_query("SELECT id, points, ingame_points, ingame_money, ingame_items FROM members;
WHERE username = $_SESSION['myusername']");

//this function will take the above query and create an array
while($row = mysql_fetch_array($result))
  {

 //with the array created above, I can create variables (left) with the outputted array (right)
$points = $row['points'];
$id = $row['id'];
$ingame_points = $row['ingame_points'];
$ingame_money = $row['ingame_money'];
$ingame_items = $row['ingame_items'];
  }


Help  ?

Hi, I have this script that returns the entire table including column names and the row data. However I only want certain column names and the corresponding data to be returned.

Code: [Select]
<?php

include_once("data/mysql.php");

$mysqlPassword = (base64_decode($mysqlpword));

$db = mysql_connect("$localhost", "$mysqlusername", "$mysqlPassword") or die ("Error connecting to database");

mysql_select_db("$dbname", $db) or die ("An error occured when connecting to database");


// sending query

$result = mysql_query("SELECT * FROM members");
if (!$result) {
    die("Query to show fields from table failed");
}

$fields_num = mysql_num_fields($result);

echo "<h1>Table: members</h1>";
echo "<table border='1'><tr>";
for($i=0; $i<$fields_num; $i++)
{
    $field = mysql_fetch_field($result);
    echo "<td>{$field->name}</td>";
}
echo "</tr>\n";
while($row = mysql_fetch_row($result))
{
    echo "<tr>";

    
    foreach($row as $cell)
        echo "<td>$cell</td>";

    echo "</tr>\n";
}

mysql_query($result);

?>
Any help is always appreciated

Hi guys, basically here pull out the data from database then creating taxt field automatically and submit into anther table. everything works fine but data not inserting in to the table. could you guys check my code please?


 <?php

$con = mysql_connect("localhost","root","");

mysql_select_db("uni", $con)or trigger_error('MySQL error: ' . mysql_error());
?>
<?php
$result  = mysql_query("SELECT * FROM course") or trigger_error('MySQL error: ' . mysql_error());


echo '<select name ="cid[]">';

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

    echo '<option value="' . $row['CourseID'] . '">'. $row['CourseID'] .'</option>';
}

echo '</select>';
//------------------
?>
   
 <?php
if(!empty($_POST["submit"]))
{
 $value = empty($_POST['question']) ? 0 : $_POST['question'];
?>
 <form name="form1" method="post" action="result.php">
 <?php


 for($i=0;$i<$value;$i++)
 {
  echo 'Question NO: <input type="text" name="qno[]" size="2" maxlength="2" class="style10">&nbsp;&nbsp;&nbsp;&nbsp;
        Enter Marks: <input type="text" name="marks[]" size="3" maxlength="3" class="style10"><br>';
  }


?>
  <label> <br />
  <br />
  <input type="submit" name="Submit" value="Submit" class="style10">
  </label>
 </form>
<?php
 }
else{
?>

<form method="POST" action="#">


 
<label>
<span class="style10">Enter the Number of Question</span>
<input name="question" type="text" class="style10" size="2" maxlength="2"> 
</label>
<input name="submit" type="submit" class="style10" value="Submit">

 
</form>
<?php }?>


result.php
<?php
 

$con = mysql_connect("localhost","root","") or die('Could not connect: ' . mysql_error());
mysql_select_db("uni",$con) or die('Could not connect: ' . mysql_error());

foreach ($_POST['cid'] as $c) {$cid [] = $c;}
foreach($_POST['qno'] as $q){$qno[] = $q;}
foreach($_POST['marks'] as $m){$marks[] = $m;}
$ct = 0;
for($i=0;$i<count($qno);$i++)
{

 $sql="INSERT INTO examquesion (CourseID,QuesionNo,MarksAllocated) VALUES('$cid[$i]','$qno[$i]','$marks[$i]')";
 mysql_query($sql,$con) or die('Error: ' . mysql_error());
 $ct++;
 }
echo "$ct record(s) added";
mysql_close($con)
?>

For instance if i set the following 2x variables;

"$varOne = $_GET[first_name]"
"$varTwo = $_GET[last_name]"
"$varThree = $_GET[userid]"

how do i insert them both together into a DB field for example:

$full = $varOne,$varTwo,$varThree (without the , )

this would then be echo as : joebloggs66985

i have the INSERT in there atm but i wanted to insert first name and last name together with there userid to generate a sort of username possibility.

sorry if i didnt explain correcly

I'm trying to show the same data, but updated right away. For example. I want to update my coords on a map and refresh a div to show the new data, but as the code now, it keeps the same data until I reload the page. Here is the code I have now.


if ($north)
{
$ylocation = $users['y'] + 1;
if ($ylocation > 5)
{
$ylocation = 0;
}
$locationyupdate = ("UPDATE players SET y = '$ylocation' WHERE name='$users[name]'");
mysql_query($locationyupdate) or die("could not register");?>
<script type="text/javascript">
$('#npc').load('npc.php');
$('#description').load('description.php');
</script><?}

The update code is before the reload script for the two div's. The data DOES change in the database, but the two div's won't display the new data until it is refreshed again.

Do I need to reactivate fetch to get the new data?

Hi,

I have some images that I want to resize to a square dimention (40px 40px). However, not all image are square, so when they are resized, they lose their ration and look squashed.

Is there a way I can display just a part of the original image, say 40px x 40px on the top middle of each image?

I hope that makes sense

I'm building a php program that registers users onto a website. With the help of people from this thread http://www.phpfreaks.com/forums/index.php?topic=332260.15
I was able to accomplish the goal and now the signup works with conditions that check for a valid email, and if the password is strong enough.

T he program correctly displays the the problem when a user does NOT enter a valid email, or a strong enough password, but the user has to re-enter the email and password everytime.

I want to make it so that the fields remained populated with what the user entered previously, so he or she does not have to re-enter his or her email/password.

Here is the code (its really ghetto)

Code: [Select]
<?php

function check_email_address($email) {
    // First, we check that there's one @ symbol, and that the lengths are right
    if (!ereg("^[^@]{1,64}@[^@]{1,255}$", $email)) {
        // Email invalid because wrong number of characters in one section, or wrong number of @ symbols.
        return false;
    }
    // Split it into sections to make life easier
    $email_array = explode("@", $email);
    $local_array = explode(".", $email_array[0]);
    for ($i = 0; $i < sizeof($local_array); $i++) {
         if (!ereg("^(([A-Za-z0-9!#$%&'*+/=?^_`{|}~-][A-Za-z0-9!#$%&'*+/=?^_`{|}~\.-]{0,63})|(\"[^(\\|\")]{0,62}\"))$", $local_array[$i])) {
            return false;
        }
    }    
    if (!ereg("^\[?[0-9\.]+\]?$", $email_array[1])) { // Check if domain is IP. If not, it should be valid domain name
        $domain_array = explode(".", $email_array[1]);
        if (sizeof($domain_array) < 2) {
                return false; // Not enough parts to domain
        }
        for ($i = 0; $i < sizeof($domain_array); $i++) {
            if (!ereg("^(([A-Za-z0-9][A-Za-z0-9-]{0,61}[A-Za-z0-9])|([A-Za-z0-9]+))$", $domain_array[$i])) {
                return false;
            }
        }
    }
    return true;
}

define('DB_NAME', 'catch');
define('DB_USER', 'username');
define('DB_PASS', 'password');
define('DB_HOST', 'page.sqlserver.com');

// contact to database
$connect = mysql_connect(DB_HOST, DB_USER, DB_PASS) or die('Error , check your server connection.');
mysql_select_db(DB_NAME);
  
//Get data in local variable
$v_name=$_POST['name'];
$v_email=$_POST['email'];
$v_msg=$_POST['msg'];


 if ( check_email_address($_POST['name'])  == false) 
 
 
 {
   $query = "INSERT INTO contact(name,email,msg) VALUES ('$v_name','$v_email','$v_msg')";
$result = mysql_query( $query );

if( !$result ) {
die( mysql_error() );
}
echo <<<EOD
<head>      
<link rel="stylesheet" type="text/css" href="http://hedgezoo.com/signup.css">
</head>
<h2>Free Registration</h2>
<form action="contact_insert2.php" method="POST" id="insert">
<table>
<tr>
<td>Email</td>
<td ><input type="text" size="40" name="name"></td>
</tr>
    <tr>
<td>Password</td>
<td><input type="password" size="40"  name="msg" ></td>
</tr>
<tr>
<td colspan=2 id="sub">
You must enter a valid email. <br />
<input type="submit" name="submit" value="submit">
</td>
</tr>
</Table>
</form>
EOD;
}

if( $v_name == "" || $v_msg == "" )
// if name is empty or if pass is empty
{
$query = "INSERT INTO contact(name,email,msg) VALUES ('$v_name','$v_email','$v_msg')";
$result = mysql_query( $query );

if( !$result ) {
die( mysql_error() );
}

echo <<<EOD
<head>      
<link rel="stylesheet" type="text/css" href="http://hedgezoo.com/signup.css">
</head>
<h2>Free Registration</h2>
<form action="contact_insert2.php" method="POST" id="insert">
<table>
<tr>
<td>Email</td>
<td ><input type="text" size="40" name="name"></td>
</tr>
    <tr>
<td>Password</td>
<td><input type="password" size="40"  name="msg" ></td>
</tr>
<tr>
<td colspan=2 id="sub">
You must enter an email and password. <br />
<input type="submit" name="submit" value="submit">
</td>
</tr>
</Table>
</form>
EOD;
}

if( strcspn( $_REQUEST['msg'], '0123456789' ) == strlen( $_REQUEST['msg'] ) )
// the above statement says if pass does not contain a number
{
$query = "INSERT INTO contact(name,email,msg) VALUES ('$v_name','$v_email','$v_msg')";
$result = mysql_query( $query );

if( !$result ) {
die( mysql_error() );
}
echo <<<EOD
<head>      
<link rel="stylesheet" type="text/css" href="http://hedgezoo.com/signup.css">
</head>
<h2>Free Registration</h2>
<form action="contact_insert2.php" method="POST" id="insert">
<table>
<tr>
<td>Email</td>
<td ><input type="text" size="40" name="name"></td>
</tr>
    <tr>
<td>Password</td>
<td><input type="password" size="40"  name="msg" ></td>
</tr>
<tr>
<td colspan=2 id="sub">
<div style="color:red;">Your password must contain a number.</div> <br />
<input type="submit" name="submit" value="submit">
</td>
</tr>
</Table>
</form>
EOD;
}


if( strlen($_POST['msg']) < 8 )
// the above statement says if pass is not 8 characters long
{
$query = "INSERT INTO contact(name,email,msg) VALUES ('$v_name','$v_email','$v_msg')";
$result = mysql_query( $query );

if( !$result ) {
die( mysql_error() );
}
echo <<<EOD
<head>      
<link rel="stylesheet" type="text/css" href="http://hedgezoo.com/signup.css">
</head>
<h2>Free Registration</h2>
<form action="contact_insert2.php" method="POST" id="insert">
<table>
<tr>
<td>Email</td>
<td ><input type="text" size="40" name="name"></td>
</tr>
    <tr>
<td>Password</td>
<td><input type="password" size="40"  name="msg" ></td>
</tr>
<tr>
<td colspan=2 id="sub">
<div style="color:red;">Your password must be at least 8 characters long.</div> <br />
<input type="submit" name="submit" value="submit">
</td>
</tr>
</Table>
</form>
EOD;
}


if ( $_POST['msg'] == strtolower($_POST['msg']) )
// the above statement says if pass is all lowercase
{
$query = "INSERT INTO contact(name,email,msg) VALUES ('$v_name','$v_email','$v_msg')";
$result = mysql_query( $query );

if( !$result ) {
die( mysql_error() );
}
echo <<<EOD
<head>      
<link rel="stylesheet" type="text/css" href="http://hedgezoo.com/signup.css">
</head>
<h2>Free Registration</h2>
<form action="contact_insert2.php" method="POST" id="insert">
<table>
<tr>
<td>Email</td>
<td ><input type="text" size="40" name="name"></td>
</tr>
    <tr>
<td>Password</td>
<td><input type="password" size="40"  name="msg" ></td>
</tr>
<tr>
<td colspan=2 id="sub">
<div style="color:red;">Your password must have at least one capital letter.</div> <br />
<input type="submit" name="submit" value="submit">
</td>
</tr>
</Table>
</form>
EOD;
}

if ( preg_replace("/[^a-zA-Z0-9\s]/", "", $_POST['msg']) == $_POST['msg'] )
// the above statement says if pass contains no special characters
{
$query = "INSERT INTO contact(name,email,msg) VALUES ('$v_name','$v_email','$v_msg')";
$result = mysql_query( $query );

if( !$result ) {
die( mysql_error() );
}
echo <<<EOD
<head>      
<link rel="stylesheet" type="text/css" href="http://hedgezoo.com/signup.css">
</head>
<h2>Free Registration</h2>
<form action="contact_insert2.php" method="POST" id="insert">
<table>
<tr>
<td>Email</td>
<td ><input type="text" size="40" name="name"></td>
</tr>
    <tr>
<td>Password</td>
<td><input type="password" size="40"  name="msg" ></td>
</tr>
<tr>
<td colspan=2 id="sub">
<div style="color:red;">Your password must have at least one special character.</div> <br />
<input type="submit" name="submit" value="submit">
</td>
</tr>
</Table>
</form>
EOD;
}
else 
echo <<<EOD
<B>GO FUCK YOURSELF</B>
EOD;
 ?>

not sure if this will find an answer but I am posting anyway. Any help is appreciated....my coder has left the team and no matter how I invite her to come and do some bug squashing, her new schedules won't fit a re-visit into my little aplication...I am eager to delve into the codes at my very low knowledge of php. I have initiated reading and is still trying to teach myself...but of course not as fast as the app needs the patch...here's the meat:

Hi All,

Need help. I have a form which collect the users information including image which are stored in the directory. I want to rename the image file to the name of the user and stores it relative path in SQL table so that when I retrieve user name it also retrieve the image of the user. 

My Table structure is as follow:

id int(5)
lecturer_name varchar(10)
lecturer_img_path varchar(100)

Below is the PHP and HTML code.

PHP Code


<?php
$dbhost = 'localhost';
$dbuser = 'root';
$dbpass = '';
$conn = mysql_connect($dbhost, $dbuser, $dbpass) or die ('Error connecting to mysql');
$dbname = 'test';
mysql_select_db($dbname)or die ('Error connecting to mysql');
?>

<?php
if(isset($_POST['lecturer']))
{
   $lecturer = $_POST['lecturer'];
   $n        = count($lecturer);
   $i        = 0;
   echo "Your selected lecturer are \r\n" .
        "<ol>";
   while ($i < $n)
   {
if($lecturer[$i] == ""){
//do nothing
$i++;
}else{
      echo "<li>{$lecturer[$i]}</li> \r\n";
      $i++;
  }
   }
   echo "</ol>";
}
?>

<?php mysql_close($conn); ?> 


HTML FORM

Code: [Select]
<!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>lecturer details</title>
<style type="text/css">
body {
background-color: #ffc;
}
</style>
</head>

<body>
<b>
<h1>Enter new lecturer details :</h1>

<form id="form1" name="form1" method="post" action="submit1.php">
  <p>Lecturer:<br />
    <label for="lecturer"></label>
    <input name="lecturer[]" type="text" id="lecturer1" size="15" /> <label for="lect_img1"></label><input id="lect_img1" type="file" name="lect_img[]"><br />
    <input name="lecturer[]" type="text" id="lecturer2" size="15" /> <label for="lect_img2"></label><input id="lect_img2" type="file" name="lect_img[]"><br />
    <input name="lecturer[]" type="text" id="lecturer3" size="15" /> <label for="lect_img3"></label><input id="lect_img3" type="file" name="lect_img[]"><br />
    <input name="lecturer[]" type="text" id="lecturer4" size="15" /> <label for="lect_img4"></label><input id="lect_img4" type="file" name="lect_img[]"><br />
    <input name="lecturer[]" type="text" id="lecturer5" size="15" /> <label for="lect_img5"></label><input id="lect_img5" type="file" name="lect_img[]"><br />
    <input name="lecturer[]" type="text" id="lecturer6" size="15" /> <label for="lect_img6"></label><input id="lect_img6" type="file" name="lect_img[]"><br />
    <br />
 
<input name="submit" type="submit" id="send" value="submit">
</form>

</b>
</body>
</html>