PHP - Problem With Posting Date From Mysql Database

I have an issue with my script, the date for some reason stopped posting after I changed the format in the date() section, I wanted it to post so it shows month-day-year, and it seems for some reason all it accepts is Y-m-d...

Can someone help me out here please?

Code: [Select]
<?php
require_once('connectvars.php');

  if (isset($_POST['submit'])) {
    // Connect to the database
    $dbc = mysqli_connect(DB_HOST, DB_USER, DB_PASSWORD, DB_NAME);
$PO_Date = date('MM "/" DD "/" YY',strtotime($_POST['PO_Date']));
$query = "INSERT INTO ncmr (PO_Date) VALUES ('$PO_Date')";
            mysqli_query($dbc, $query);



// Confirm success with the user
        echo '<p>The date have been successfully entered</p>';
mysqli_close($dbc);

// Clear the score data to clear the form
            $PO_Date = "";
}
echo'<form form id="all" method="post">';
echo '<div id="abd"><span class="b">On:&nbsp;&nbsp;</span><input type="text" name="Added_By_Date" value="" /></div>';
echo '<div id="button"><input type="submit" value="Submit Edits" name="submit" /></div>';
echo '</form>'
?>

You guys helped me create a function to gather information for my database. Now I need some help with posting that information.

Function code and Form:
<?php include("opendatabase.php"); ?>

<?php
function createMatchup($week, $game)
{
$query1 = "SELECT team_name 
FROM schedule, teams 
WHERE schedule.week_id = $week 
AND schedule.game_id = $game 
AND schedule.A_team = teams.team_id";

$query2 = "SELECT team_name 
FROM schedule, teams 
WHERE schedule.week_id = $week 
AND schedule.game_id = $game 
AND schedule.H_team = teams.team_id";

$result1 = mysql_fetch_assoc(mysql_query($query1));
$result2 = mysql_fetch_assoc(mysql_query($query2));

$output = "
<input type=\"text\" size = \"3\" name=\"w$weekg$gameA\"> {$result1['team_name']} vs. {$result2['team_name']} 
<input type=\"text\" size = \"3\" name=\"w$weekg$gameH\">";

return $output;

}

$game1 = createMatchup(1, 1);
$game2 = createMatchup(1, 2);
$game3 = createMatchup(1, 3);
$game4 = createMatchup(1, 4);
$game5 = createMatchup(1, 5);
$game6 = createMatchup(1, 6);
$game7 = createMatchup(1, 7);
$game8 = createMatchup(1, 8);
$game9 = createMatchup(1, 9);
$game10 = createMatchup(1, 10);
$game11 = createMatchup(1, 11);
$game12 = createMatchup(1, 12);
$game13 = createMatchup(1, 13);
$game14 = createMatchup(1, 14);
$game15 = createMatchup(1, 15);
$game16 = createMatchup(1, 16);

mysql_close($con);

?>

<form action="insert_spreads.php" method="post">
<?php echo $game1; ?>
<br>
<?php echo $game2; ?>
<br>
<?php echo $game3; ?>
<br>
<?php echo $game4; ?>
<br>
<?php echo $game5; ?>
<br>
<?php echo $game6; ?>
<br>
<?php echo $game7; ?>
<br>
<?php echo $game8; ?>
<br>
<?php echo $game9; ?>
<br>
<?php echo $game10; ?>
<br>
<?php echo $game11; ?>
<br>
<?php echo $game12; ?>
<br>
<?php echo $game13; ?>
<br>
<?php echo $game14; ?>
<br>
<?php echo $game15; ?>
<br>
<?php echo $game16; ?>
<br /><br />
<input type="Submit" value="Submit Spreads">
</form>
I'm wondering if I can use this code for posting to the database (insert_spreads.php):
<?php

header("Location: admin_schedule.php");

include("opendatabase.php");

$w$weekg$gameA=("$_POST['w$weekg$gameA']");
$w$weekg$gameH=("$_POST['w$weekg$gameH']");

$sql="
UPDATE schedule 
SET A_pt_spread= '$w$weekg$gameA',H_pt_spread= '$w$weekg$gameH'
WHERE week_id = '$week'
AND game_id = '$game';

$result = mysql_query($sql) or die(mysql_error().$sql);

mysql_close($con)

?>



Thanks for helping.

I'm trying to figure out how to post an array into my database. I am able to post single entries without a problem, but trying to post several entries at once is causing me some headaches. Can anyone check this code and hopefully give me some insight as to where I'm going wrong?

Here's the form:
Code: [Select]
<?php include("opendatabase.php"); ?>

<FORM Method = "POST" action ="insert_spreads.php">
 
<?php
$weekID = $_POST[Week];
echo "<h2>Enter Spreads for Week $weekID</h2>";
print ("<br /><br />");

$result = mysql_query("
SELECT S.game_id, TH.team_name AS HomeTeam, TA.team_name AS AwayTeam
FROM schedule AS S 
JOIN teams AS TH ON S.H_team = TH.team_id
JOIN teams AS TA ON S.A_team = TA.team_id
WHERE S.week_id = '$weekID'
ORDER BY S.game_id;");

while ($row = mysql_fetch_array($result)) {
printf('<input type="text" size="4" name="w%dg%dAspread">', $weekID, $row['game_id']);
printf(" %s vs. %s  ", $row['AwayTeam'], $row['HomeTeam']);
printf('<input type="text" size="4" name="w%dg%dHspread">', $weekID, $row['game_id']);
print("<br /><br />");
} 
mysql_close($con);
?>
<br /><br />

<input type="Submit" value="Submit Spreads">
</FORM>

And here's the "insert_spreads.php
Code: [Select]
<?php

header("Location: admin_main_entry.php");

include("opendatabase.php");

$aspread=$_POST['w%dg%dAspread'];
$hspread=$_POST['w%dg%dHspread'];
$row=$_POST[$row['game_id'];

$sql="
UPDATE schedule 
SET A_pt_spread= '$aspread',H_pt_spread= '$hspread'
WHERE week_id = '$weekID'
AND game_id = '$row'";

$result = mysql_query($sql);

mysql_close($con)

?>
Thanks!

I'm not much of a PHP programmer so please excuse the mess but I'm having a problem with some code. I am able to successfully build a table and assign values to radio buttons based one information in a database. The problem comes when I want to update the database when someone changes a radio button. Everthing works up until the foreach statment. Nothing in the database is being updated, if I replace the sql statement with echo $v; all I get is the word Submit so it's like the rest of the values aren't being included in the form.
<link href="css/demo.css" rel="stylesheet" type="text/css">

<?php
session_start();
// dBase file
        include "dbconfig.php";
if (!$_SESSION["valid_user"])
        {
        // User not logged in, redirect to login page
        Header("Location: index.php");
        }
 //Grab GUID passed in the URL
 $guid=$_GET['guid'];
 // Create query for student name
  $sql = "SELECT FirstName, LastName FROM Students where GUID ='". $guid . "'";
  // Run query
  $result = mssql_query($sql);
  $row= mssql_fetch_assoc($result);
  
// Member only content
//Title and main page information
echo "<div align=\"center\"><p><img src=\"images/EFCTS Logo.jpg\" width=\"600\" height=\"144\" /></p><h1>OCAP DATABASE</h1></div>";
echo "<p><a href=\"logout.php\">Logout</a></p>";
//Build sortable table of student data.
echo "<table id=\"test1\" class=\"sortable-onload-3-reverse rowstyle-alt no-arrow\" border=\"0\" cellpadding=\"0\" cellspacing=\"0\">";

//query database for table information
$SQLcommand = "SELECT convert(varchar(36), StudentGUID) as StudentGUID, CompetencyLevel, CompetencyName, CompetencyID, Category, convert(varchar(36), CompetencyGUID) as CompetencyGUID FROM VW_StudentSkills WHERE StudentGUID ='". $guid ."'";
$SQLresult = MsSQL_QUERY($SQLcommand);

//Continue building table
echo "<caption>".$row[FirstName]." ".$row[LastName]."</caption>";
echo "<th style=\"-moz-user-select: none;\" class=\"sortable-numeric fd-column-0\"><a title=\"Sort on \"Competency ID\"\" href=\"#\">Competency ID</a></th>";
echo "<th style=\"-moz-user-select: none;\" class=\"fd-column-1 sortable-text reverseSort\"><a title=\"Sort on \"Catagory\"\" href=\"#\">Catagory</a></th>";
echo "<th style=\"-moz-user-select: none;\" class=\"fd-column-2 sortable-text reverseSort\"><a title=\"Sort on \"Competency Name\"\" href=\"#\">Competency Name</a></th>";
echo "<th style=\"-moz-user-select: none;\" class=\"sortable-numeric fd-column-3\"><a title=\"Sort on \"Competency Level\"\" href=\"#\">Competency Level</a></th>";
echo "</tr></thead>";
//Set variables for radio buttons
$a="";
$b="";
$c="";
$d="";

//count the number of rows returned
$count=mysql_num_rows($SQLresult);
//Start form
echo "<form name=\"form1\" method=\"post\" action=\"".$_SERVER['REQUEST_URI']."\">";

$groupnum = 0;
//Build table with SQL data
while($row2=mssql_fetch_array($SQLresult)) 
{

//find the competency level
$complevel = $row2[CompetencyLevel];
if($complevel=="1") $a="checked";
if($complevel=="2") $b="checked";
if($complevel=="3") $c="checked";
if($complevel=="4") $d="checked";
//build the table
echo "<tr class=\"\"><td>".$row2[CompetencyID]."</td><td>".$row2[Category]."</td>";
echo "<td>".$row2[CompetencyName]."</td>";
echo "<td class=\"lft\"><input type=\"radio\" name=\"".$row2[CompetencyID]."\" value=\"1\"".$a."> 1";
echo "<input type=\"radio\" name=\"".$row2[CompetencyID]."\" value=\"2\"".$b."> 2";
echo "<input type=\"radio\" name=\"".$row2[CompetencyID]."\" value=\"3\"".$c."> 3";
echo "<input type=\"radio\" name=\"".$row2[CompetencyID]."\" value=\"4\"".$d."> 4";
$idarray[]=$row2[CompetencyGUID];
echo "</td></tr>";
$groupnum++;
//clear the variables
$a="";
$b="";
$c="";
$d="";
}

echo "</tbody>";
echo "<input type=\"submit\" name=\"Submit\" value=\"Submit\">";
echo "</form></table>";
echo "<script type=\"text/javascript\" src=\"javascript/tablesort.js\"></script>";

                  if($_POST['Submit'])
                        {
                           echo"submit button detected";
   foreach($_POST as $k=>$v)
                           {                               
                             if($k!="Submit") { 
                              $sqlUpdate = "UPDATE DATA SET COMPETENCYLEVEL = '".$v."' WHERE COMPETENCYGUID = '".$idarray."' AND STUDENGUID = '".$guid."' ";
                              $resultUpdate = mssql_query($sqlUpdate);
  }

                           }
                        }
if($resultUpdate)
                        {    print_r ($_POST); 
echo $resultUpdate;     
echo $sqlUpdate;                  
                                                      
                        }
                        else
                        {
                           echo "Your entry is not completed at this time.............";
   echo $sqlUpdate;
   echo $resultUpdate;
                        }
                    
// Display Member information
//echo "<p>User ID: " . $_SESSION["valid_id"];
//echo "<p>Username: " . $_SESSION["valid_user"];
//echo "<p>Logged in: " . date("m/d/Y", $_SESSION["valid_time"]);

?>

In my app, the users will take a multiplication test with 10 problems... I'm not sure how I would post the grade that the user got to the database.

When the user finishes the test and hits score it should post their Name/Date & Time/ and Score to the database. I have the name and date & time working. Just not sure how I would approach the score.

This is my application... It is small and simple to run in browser.


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>Lab 5</title>
</head>

<body>

<?php

require_once('database.php');






define ('ROWS', 3);
define ('COLS', 3);
define ('MAX_NUMBER', 12);
date_default_timezone_set('America/New_York');



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

$result_name=$_POST['result_name'];

$sql = "INSERT INTO results (result_name, result_score, result_date_time) VALUES ('$result_name', 100, NOW());";


$db->exec($sql);





//print_r ($_POST);
$time1 = $_POST['ts'];
$time1_object = new DateTime($time1);
$now = new DateTime();
$time_span = $now->diff($time1_object);

$minutes = $time_span->format('%i');
$seconds = $time_span->format('%s');
$seconds+= $minutes * 60;

echo "It took $seconds seconds to complete the test<hr />";



foreach ($_POST as $problem => $answer)
{
if ($problem <> "btn_score" && $problem <> "ts")
{
//echo "$problem -- $answer <br />";
$problem = explode('_', $problem);
$num1 = $problem[2];
$num2 = $problem[3];



$right = $num1 * $num2;

if ($answer != $right)
{
echo "$num1 * $num2 = $answer , The right answer is $right<br />";
}
}
}
}









?>

<h1>Lab 5</h1>

<form name="lab5" method="post" action="lab5b.php">
<?php
$now = new DateTime();
//echo $now->format('Y-m-d H:i:s');
echo "<input type='hidden' name='ts' value='" . $now->format('Y-m-d H:i:s') . "'>";
?>
<table border="1" cellspacing="5" cellpadding="5">

<?php


$no_of_problems = 0;
for ($row=0; $row<ROWS; $row++)
{
echo "<tr>";
for ($col=0; $col<COLS; $col++)
{
$num1 = mt_rand(1,MAX_NUMBER);
$num2 = mt_rand(1,MAX_NUMBER);

echo "<td>$num1 * $num2 </td>";
echo "<td><input type='text' size='2' name=${no_of_problems}_mult_${num1}_${num2}></td>";
$no_of_problems++;
}
echo "</tr>";
}
$colspan = 2 * COLS;
echo "<tr><td colspan=$colspan align='right'><input type='submit' value='Score' name='btn_score'></td></tr>";
?>

</table>
<br>
<br>
<label for="result_name">Student Name:</label>
<input type="text" id="result_name" name="result_name" /><br />
</form>
<br>
<br>





</body>
</html>

Hi.

I have a database named 'Forums' with a table named 'forumlist'. The fields in the table are 'id', 'name', 'link', and 'keys'.

I am trying to search the database in either the 'name' or 'keys' field and display the matches.

I am getting this error:

Parse error: syntax error, unexpected T_STRING, expecting ']' in C:\xampp\htdocs\search3.php on line 51 (The define fields)



<html>
<head>
  <title>My Forum Search</title>
  <style type="text/css">
 
  table {
     background-color: #CCC
  }
 
  th {
     width: 150px;
     text-align: left;
  }
 
  </style>
</head>
<body>
<h1>Forum Search</h1>

<form method="post" action="search3.php">
<input type="hidden" name="submitted" value="true" />

<label>Search Category:

<select name="category">
   <option value="keys">Keyword</option>
    <option value="name">Name</option>
   
</select>
</label>
   





<label><input type="text" name="criteria" /></label>

<input type="submit" />


</form>

<?php

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




DEFINE ('DB_USER', 'root');
DEFINE ('DB_PSWD', '******');
DEFINE ('DB_HOST', 'localhost');
DEFINE ('DB_NAME', 'Forums');

$dbcon = mysqli_connect(DB_HOST, DB_USER, DB_PSWD, DB_NAME);



$category = $_POST['category'];
$criteria = $_POST['criteria'];
$query = "SELECT * FROM forumlist WHERE $category LIKE '$criteria'";
$result = mysqli_query($dbcon, $query) or die ('Error retrieving data')

echo "<table>";
echo "<tr> <th>Name</th><th>Link</th> </tr>";

while ($row = mysqli_fetch_array($result, MYSQLI_ASSOC)) {

   echo "<tr><td>";
    echo $row['name'];
    echo "</td><td>";
    echo $row['link'];
    echo "</td></tr>";
   

}

echo "</table>";

} // end of main if state






?>




</body>
</html>



Thanks in advance

Hey there I'm trying to gather a users Facebook info and use that to create a user account for them on my database.

My code works perfectly for the first person who links his Facebook account with my site and adds all the user info to the database. After that with any other users it will display the logged in Facebook users name with their profile pic. The problem arises when it tries to add this person to the mysql database. It returns the error "An error has occurred and we are unable to sync your Facebook account."

Before the <head>

Code: [Select]
<?php
define('FACEBOOK_APP_ID', 'imagine_app_id_here');
define('FACEBOOK_SECRET', 'imagine_secret_here');
function get_facebook_cookie($app_id, $application_secret) {
  $args = array();
  parse_str(trim($_COOKIE['fbs_' . $app_id], '"'), $args);
  ksort($args);
  $payload = '';
  foreach ($args as $key => $value) {
    if ($key != 'sig') {
      $payload .= $key . '=' . $value;
    }
  }
  if (md5($payload . $application_secret) != $args['sig']) {
    return null;
  }
  return $args;
}
$cookie = get_facebook_cookie(FACEBOOK_APP_ID, FACEBOOK_SECRET);
?>
In the <body>

Code: [Select]
<?php if ($cookie) {
//###cookie is set, user is logged in
$user = json_decode(file_get_contents('https://graph.facebook.com/'.$cookie['uid']));


define('INCLUDE_CHECK',true);
require("connect.php");

$fbookid = $user->{'id'};
$fbookname = $user->{'name'};


$query = mysql_query("SELECT * FROM tz_members WHERE facebook_id='$fbookid'");
        $numrows = mysql_num_rows($query);
        if ($numrows == 1){
                echo "<font color='#FF0000'>You are logged in through Facebook.</font>";
        }
        else
        {
                        mysql_query("INSERT INTO tz_members(facebook_id,usr,regIP,dt)
                        VALUES(
                        
                            '".$fbookid."',
                            '".$fbookname."',
                            '".$_SERVER['REMOTE_ADDR']."',
                            NOW()
                            
                        )");
                        $query = mysql_query("SELECT * FROM tz_members WHERE facebook_id='$fbookid'");
                        $numrows = mysql_num_rows($query);
                        if ($numrows == 1){
    
                                echo "<font color='#FF0000'>Your Facebook account has been synced with our user database.</font>";
                        }
                        else {

                            echo "<font color='#FF0000'>An error has occured and we are unable to sync your Facebook account.</font>";
                        }
                        mysql_close();
        }
                                        
echo '<img src="http://graph.facebook.com/'.$user->{'id'}.'/picture" alt="'.$user->{'name'}.'"/>';
echo $user->{'name'};

echo '<fb:login-button perms="email,user_birthday" onlogin="window.location.reload(true);" autologoutlink="true"></fb:login-button>';


}
else
{
//###user is not logged in, display the Facebook login button
echo '<fb:login-button perms="email,user_birthday" autologoutlink="true"></fb:login-button>';
}
?>
Javascript:
Code: [Select]
<div id="fb-root"></div>
<script src="http://connect.facebook.net/en_US/all.js"></script>
<script>
FB.init({appId: '<?= FACEBOOK_APP_ID ?>', status: true,
cookie: true, xfbml: true});
FB.Event.subscribe('auth.login', function(response) {
window.location.reload();
});
</script>
Any help would be greatly appreciated!

I have an email form that is working wonderfully. I have a select box that has a list of names of people that you can email. That list is being pulled from a database.

It is currently sending to the email related to the name selected in the dropdown menu. However, in the email that sends, I would like the name of the recipient to show up in the greeting. I.E. Dear "name from dropdown".

How do I go about doing this. My select box that holds the query for the name is as folows:

<?php 
echo '<select name="First_and_Last_Name">';
while( $array = mysql_fetch_assoc($result) ) {
    $text_for_select = $array["First_Name"] . " " . $array["Last_Name"]. " " . $array["District"];
$value_for_select = $array["Email"];
echo "<option></option>\n";
echo "<option value=\"$value_for_select\">$text_for_select</option>\n"; 
}
echo '</select>';?> 

No, this is querying the First and Last Name and another variable called district in to a new variable called "text_for_select". I just want to either print the "text_for_select" after the "Dear", or better yet, just the "First_Name" and "Last_Name".

How would I get this to print there?

Ok, I have one database three tables.

Table 1 is ncmr the main table where everything is to be entered.

Table 2 is companies, where all the companies in pull down menu 1 is located.

Table 3 is fabricators, where all the people who have had hands on the product are residing.

I want the selected choices of table 2 and 3 to be inputed into table 1. I know this has to be possible, but I don't know how.  I thought I wrote the code correctly, but it seems not.

Can someone review my code and show me where my mistake is?

Here is the page:

http://kaboomlabs.com/PDI/post2.php

Thanks.

Code: [Select]
    <?php
    
    require_once('connectvars.php');
     $dbc = mysqli_connect(DB_HOST, DB_USER, DB_PASSWORD, DB_NAME)
     or die('Error connecting to MySQL server.');
    ?>
   
    <!DOCTYPE html
         PUBLIC "-//W3C//DTD XHTML 1.0 Strict//EN"
         "http://www.w3.org/TR/xhtml1/DTD/xhtml1-strict.dtd">
   
    <html xmlns="http://www.w3.org/1999/xhtml">
    <head>
    <meta http-equiv="Content-Type" content="text/html; charset=UTF-8" />
    <title>PDI Non-Conforming Materials Report</title>
    <link rel="stylesheet" type="text/css" href="CSS/postie.css" />
   
    </head>
   
    <body>
    <div id="logo">
    <img src="images/PDI_Logo_2.1.gif" alt="PDI Logo" />
    </div>
   
    <div id="title">
    <h3 id="NCMR2">Non-Conforming Materials Report (NCMR)</h3>
    </div>
    <?php
    //Post Data
     if (isset($_POST['submit'])) {
     $ab = mysqli_real_escape_string($dbc,$_POST['ab']);
     $date = mysqli_real_escape_string($dbc,date('Y-m-d',strtotime ($_POST['date'])));
     $part = mysqli_real_escape_string($dbc,$_POST['part']);
     $rev = mysqli_real_escape_string($dbc,$_POST['rev']);
     $partdesc = mysqli_real_escape_string($dbc,$_POST['partdesc']);
     $ncmrqty = mysqli_real_escape_string($dbc,$_POST['ncmrqty']);
     $comp = mysqli_real_escape_string($dbc,$_POST['comp']);
     $ncmrid = mysqli_real_escape_string($dbc,$_POST['ncmrid']);
     $rma = mysqli_real_escape_string($dbc,$_POST['rma']);
     $jno = mysqli_real_escape_string($dbc,$_POST['jno']);
     $fdt = mysqli_real_escape_string($dbc,$_POST['fdt']);
     $cof = mysqli_real_escape_string($dbc,$_POST['cof']);
     $fab1= mysqli_real_escape_string($dbc,$_POST['fab1']);
     $fab2= mysqli_real_escape_string($dbc,$_POST['fab2']);
     $fab3= mysqli_real_escape_string($dbc,$_POST['fab3']);
     $non= mysqli_real_escape_string($dbc,$_POST['non']);
     $dis= mysqli_real_escape_string($dbc,$_POST['dis']);
     $comm= mysqli_real_escape_string($dbc,$_POST['comm']);
     $caad= mysqli_real_escape_string($dbc,$_POST['caad']);
     $po= mysqli_real_escape_string($dbc,$_POST['po']);
     $pod = mysqli_real_escape_string($dbc,date('Y-m-d',strtotime($_POST['pod'])));
     $dri = mysqli_real_escape_string($dbc,date('Y-m-d',strtotime($_POST['dri'])));
    
     $output_form = 'no';
     if (empty($ab) || empty($date) || empty($part) || empty($partdesc)){
    
    // We know at least one of the input fields is blank 
    echo '<div id="alert">';
    echo 'Please fill out all of the required NCMR information.<br />';
     echo '</div>';
    
    }
     $output_form = 'yes';
    
    }
    
    //Access the Database
     if (!empty($ab) && !empty($date) && !empty($pod)) {
     $dbc = mysqli_connect(DB_HOST, DB_USER, DB_PASSWORD, DB_NAME)
     or die('Error connecting to MySQL server.');
    
     $query = "INSERT INTO ncmr (ab, date, part, rev, partdesc, ncmrqty, comp, ncmrid, rma, jno, fdt, cof, fab1, fab2, fab3, non, dis, comm, caad, po, pod, dri)
    
     VALUES ('$ab','$date','$part','$rev','$partdesc','$ncmrqty','$comp','$ncmrid','$rma','$jno','$fdt','$cof','$fab1','$fab2','$fab3','$non','$dis','$comm','$caad','$po','$pod','$dri')";
    
     $data = mysqli_query($dbc, $query) or die("MySQL error: " . mysqli_error($dbc) . "<hr>\nQuery: $query");
    
    
          // Confirm success with the user
     echo '<tr><td class="thank">';
     echo '<p>Thank you for adding the NCRM, the correct person will be informed.</p>';
     echo '<p><a href="post.php">&lt;&lt; Back to the form</a></p>';
     $output_form = 'no';
     echo '</td></tr>';
    
     mysqli_close($dbc);
    }
      if ($output_form == 'yes') {
    echo "<form action='".$_SERVER['PHP_SELF']."' method='post'>";
     echo '<fieldset>';
     //Part, Rev, Part Description, NCMR Qty
     echo '<div id="box1">';
     echo '<div id="ab"><span class="b">Added By:&nbsp;&nbsp;</span><input type="text" name="ab" value="" /></div>';
     echo '<div id="date"><span class="b">Date Filed:&nbsp;&nbsp;</span><input type="text" name="date" value="" /></div>';
     echo '<div id="part"><span class="b">Part Number:&nbsp;&nbsp;</span><input type="text" name="part" value="" /></div>';
     echo '<div id="rev"><span class="b">Part Revision:&nbsp;&nbsp;</span><input type="text" name="rev" value="" /></div>';
     echo '<div id="partdesc"><span class="b">Part Description:&nbsp;&nbsp;</span><textarea name="partdesc" rows="3" cols="22" ></textarea></div>';
     echo '<div id="ncmrqty"><span class="b">NCMR Qty:&nbsp;&nbsp;</span><input type="text" name="ncmrqty" value="" /></div>';
     echo '</div>';
    
    
    //Company, Customer NCMR, Internal RMA, and Job Number
     echo '<div id="box2">';
     echo'<div id="comp">';
     echo '<span class="b">Company:&nbsp;&nbsp;</span>';
     $mysqli->select_db('comp');
     $result = $mysqli->query("SELECT * FROM comp"); 
     $i = 0;
     echo "<SELECT name='comp'>\n";
     while($row = $result->fetch_assoc()) {
     if ($i == 4) echo '<option value="lines">-----</option>';
     echo "<option value='{$row['user_id']}'>{$row['name']}</option>\n";
     $i++;
     }
     echo "</select>\n";
     echo '</div>';
    
     echo '<div id="ncmrid"><span class="b">Customer NCMR ID:&nbsp;&nbsp;</span><input type="text" name="ncmrid" value="" /></div>';
     echo '<div id="rma"><span class="b">Internal RMA #:&nbsp;&nbsp;</span><input type="text" name="rma" value="" /></div>';
     echo '<div id="jno"><span class="b">Job #:&nbsp;&nbsp;</span><input type="text" name="jno" value="" /></div>';
     echo '</div>';
    
    
    //Type of Failure and Class of Failure
     echo '<div id="box3">';
     echo '<h2>Failure</h2>';
     echo '<div id="fdt">';
     echo '<span class="b">Failure Due To:&nbsp;&nbsp;</span><br />';
     echo '<select name="fdt">';
     echo '<option value="none">----None----</option>';
     echo '<option value="In House">In House</option>';
     echo '<option value="Third Party">Third Party</option>';
     echo '</select>';
     echo '</div>';
    
     echo'<div id="cof">';
     echo '<span class="b">Class of Failu &nbsp;&nbsp;</span><br />';
     echo '<select name="cof">';
     echo '<option value="none">----None----</option>';
     echo '<option value="Materials">Materials</option>';
     echo '<option value="Fabrication">Fabrication</option>';
     echo '<option value="Drawing">Drawing</option>';
     echo '<option value="Assembly">Assembly</option>';
     echo '<option value="Testing">Testing</option>';
     echo '<option value="Electrical">Electrical</option>';
     echo '<option value="Programming">Programming</option>';
     echo '<option value="Machining">Machining</option>';
     echo '<option value="Inspection">Inspection</option>';
     echo '<option value="Purchasing">Purchasing</option>';
     echo '<option value="Administrator">Administrator</option>';
     echo '</select>';
     echo '</div>';
     echo '</div>';
    
     //Fabricators
     echo '<div id="box4">';
     echo '<h2>Fabricators</h2>';
     echo'<div id="fab1">';
     $mysqli->select_db('user');
     $result = $mysqli->query("SELECT * FROM user"); 
     echo "<SELECT name='fab1'>\n";
     while($row = $result->fetch_assoc()) { 
     echo "<option value='{$row['user_id']}'>{$row['user']}</option>\n";}
     echo "</select>\n";
     echo '</div>';
    
     echo'<div id="fab2">';
     $mysqli->select_db('user');
     $result = $mysqli->query("SELECT * FROM user"); 
     echo "<SELECT name='fab2'>\n";
     while($row = $result->fetch_assoc()) { 
     echo "<option value='{$row['user_id']}'>{$row['user']}</option>\n";}
     echo "</select>\n";
     echo '</div>';
    
     echo'<div id="fab3">';
     $mysqli = new mysqli(DB_HOST, DB_USER, DB_PASSWORD, DB_NAME);
     $mysqli->select_db('user');
     $result = $mysqli->query("SELECT * FROM user"); 
     echo "<SELECT name='fab3'>\n";
     while($row = $result->fetch_assoc()) { 
     echo "<option value='{$row['user_id']}'>{$row['user']}</option>\n";}
     echo "</select>\n";
     echo '</div>';
     echo '</div>';
    
      //Nonconformity, Disposition, Comments and Comments & Additional Details
                echo '<div id="box5">';
     echo '<div id="non"><span class="b">Nonconformity:&nbsp;&nbsp;</span><br /><textarea name="non" rows="3" cols="110" ></textarea><br /></div>';
     echo '<div id="dis"><span class="b">Disposition:&nbsp;&nbsp;</span><br /><textarea name="dis" rows="3" cols="110" ></textarea></div>';
     echo '<div id="comm"><span class="b">Comments:&nbsp;&nbsp;</span><br /><textarea name="comm" rows="3" cols="110" ></textarea></div>';
     echo '<div id="caad"><span class="b">Comments and/or Additional Details:&nbsp;&nbsp;</span><br /><textarea name="caad" rows="3" cols="110" ></textarea></div>';
     //PO, PO Date, and Date Recieved
                echo '<div id="podr">';
     echo '<div id="po"><span class="b">PO:&nbsp;&nbsp;</span><input type="text" name="po"  size="7" value="" /></div>';
     echo '<div id="pod"><span class="b">PO Date:&nbsp;&nbsp;</span><input type="text" name="pod"  size="7" value="" /></div>';
     echo '<div id="dri"><span class="b">Date Received:&nbsp;&nbsp;</span><input type="text" name="dri"  size="7" value=""';
     echo '</div>';
     echo '<div id="button"><input type="submit" value="Submit NCMR" name="submit" /></div>';
     echo '</div>';
     echo '</fieldset>';
    echo '</form>';
     }
    
    
    
    
    ?>
    </body>
    </html>

Hi, Currently I am making a module for joomla. every article has an publish date, if the article was published in 7 days ago, it will displayed as "article in last week", My idea is to use today's date - publish date, if the result is greater than 7 and smaller than 14, the article will be displayed as "article in last week.
Any one know how to write this code?
Here is what I have got, but not working.

<?php
$todays_date = date("Y-m-d"); 

$result = mysql_query("select * from jos_content where $test between $todays_date-14 and $todays_date-7");  
while($row = mysql_fetch_array($result))
  {
echo "$todays_date - $row[title]";
}
?>

I have tried a large number of "solutions" to  this but everytime I use them I see 0000-00-00 in my date field instead of  the date even though I echoed and can see that the date looks correct.

Here's where I'm at:
I have a drop down for the month (1-12) and date fields (1-31) as well as a text input field for the year.  Using the POST array, I  have combined them into the xxxx-xx-xx format that I am using in my field as a date field in mysql. 

<code>
$date_value =$_POST['year'].'-'.$_POST['month'].'-'.$_POST['day'];
echo $date_value;
</code>

This outputs 2012-5-7 in my test echo but 0000-00-00 in the database.

I have tried unsuccessfully to use in a numberof suggested versions of:
strtotime()
mktime

Any help would be extremely appreciated.
I am aware that I need to validate this data and insure  that it is a valid date. That I'm okay with. I would like some help on getting it into the database.

At the fear of bothering all you, I will post here hoping that I am in the write section. I am new to php and mysql. I am using such to develope a webpage for my new business. I do believe that my php scripting is turned on because I have one script that "works". However when I take the wheel and write a script of my own and try to view it all I get is a blank white page and no errors nor anything that I wanted to display. I have tried numerous attempts at tiring to get anything to show up all I can ever seem to do is "echo" something anything else is null in displaying. Please feel free to take a look. http://72.28.26.162/rc/   phpinfo.php is accessible if you insert it after the last / (http://72.28.26.162/rc/phpinfo.php) I am at a loss. I have spent hours looking for something I miss during set up or with my procedure. I thank whomever my help me in advance.

I am running ubuntu server 10
Apache/2.2.16 port 80
(Please advise if you need anything else)

thanks

Please help !

Hi guys, I am literally at my wits end with this and I am almost positive its in my code.

This code is from a blackberry app that sends the infor into PHP, that part works flawlessy and was working just fine until I added the code to get the supervisor email from  a different table based off a query.

What happens is the information gets posted three times, The first time the emails are triggered and the post happens succefully, both the user and the supervisor get the properly formatted emails.

This happens almost immediately, works great. Then almost immediately, the supervisor will get two more emails, with the same information except missing the orignal users email, presumably the user would have gotten two more emails as well if the email address was available. The mysql DB gets all 3 records with the second two missing the user email.

Here is my code:


<?php
$dbServer1='contractor.emcee.tv';
$dbUser1='******';
$dbPass1='******';
$dbName1='purchaseorders';
$link = mysqli_connect("$dbServer1", "$dbUser1", "$dbPass1") or die("Could not connect post");
mysqli_select_db($link,"$dbName1") or die("Could not select database your_db_name1");
$job = $_GET['jobnumber'];
$vend = $_GET['vendor'];
$cat = $_GET['category'];
$amt = $_GET['amount'];
$note = $_GET['note'];
$email = $_SERVER['HTTP_RIM_DEVICE_EMAIL'];
$sql = mysqli_query($link,"insert po (job,vend,cat,amount,user,notes,date) values ('$job','$vend','$cat','$amt','$email','$note',NOW())");
if (!$sql){
print("FAILED");
}
else
{ print("SUCCESS");
$query = "SELECT MAX(id) AS PO from po";
   $result = mysqli_query($link, $query) Or die(mysqli_error($link)) ;
    while ($row = mysqli_fetch_assoc($result))
 {
$po = $row['PO'];
}
$query2 = "SELECT supervisoremail FROM job WHERE jobnum = $job";
$result2 = mysqli_query($link, $query2)Or die(mysqli_error($link));
while ($row2 =mysqli_fetch_assoc($result2)){
$sup = $row2['supervisoremail'];
}
$subject = "Purchase Order Request";
$supsubject = "FYI Purchase Order Completion";
$body = "Your purchase order request has been completed. \n \n Your PO number is: $po \n \n Job Number:$job \n Vendor:$vend \n Category:$cat \n Amount:$amt \n Items: \n $note \n \n A copy of this email has been sent to your supervisor.";
$supbody = "A purchase order request has been completed. \n \n PO number $po was issued to $email for the following: \n \n Job Number:$job \n Vendor:$vend \n Category:$cat \n Amount:$amt \n Items: \n $note \n \n Please address this if this request is in error.";
mail($email, $subject, $body);
mail($sup, $supsubject, $supbody);
}
?>

Hi there,

I have a string '12/04/1990', that's in the format dd/mm/yyyy.

I'm attempting to convert that string to a Date, and then insert that date into a MySQL DATE field.

The problem is, every time I try to do so, I keep getting values like this in the database: 1970-01-01.


Any ideas?


Much appreciated.