PHP - Download Missing Last Chunk

Hi. I am new to PHP and trying out database connections. I am trying to query the database, to see if the date matches a record in the field 'date'. If it does echo yes, if there are no matches 'no'.

Can anyone tell me what is missing from my code:

Code: [Select]
<?php

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

mysql_select_db("date_picker", $con);

$date= $_POST['date'];

$new_date = date('Y-m-d',strtotime($date));

$sql = 'SELECT date FROM availability'

if (date = $new_date) echo "Yes";

else echo "No";
   
mysql_close($con)

?>

well when i am in my forum thing and i go to click on a 'topic' it says no topic exists. and there is one there idk what im missing in the code to make it view it in my table..

Code: [Select]
<?php require("top.php");

?>
<div id='content'>

<div id='homepageright'>
<?php

include_once("scripts/connect.php");

if($username){


$cid = $_GET['cid'];
$tid = $_GET['tid'];

$sql = "SELECT * FROM topics WHERE category_id='".$cid."' AND id='".$tid."' LIMIT 1";
$res = mysql_query($sql) or die(mysql_error());

if(mysql_num_rows($res) == 1){

echo "<table width='100%'>"; 
if($username){
echo "<tr><td colspan='2'><input type='submit' value='Add Reply' onClick=\"window.location = post_reply.php?cid=".$cid."&tid=".$tid."\" /><hr /> ";
}

While ($row = mysql_fetch_assoc($res)) {
$sql2 = "SELECT * FROM posts WHERE category_id='".$cid."' AND topic_id= '".$tid."'";
$res2 = mysql_query($sql2) or die(mysql_error());
while ($row2 = mysql_fetch_assoc($res2)) {
echo "<tr><td valign='top' style='border: 1px solid #000000;'><div style='min-height: 125px;
'>".$row['topic_title']."<br /> by ".$row2['post_creator']." - ".$row2['post_date'].
"<hr /> ".$row2['post_content']."</div></td><td width='200' valign='top' 
align='center' style='border: 1px solid #000000;'>User Info Here</td></tr><tr><td 
colspan='2'><hr /></td></tr>";
}
echo "</table>";

}

}

else{
echo "This Topic Does Not Exist.";
}

}
else{
echo "You Must Be Logged In To Continue.";
}
?>
</div>
<div id='homepageleft'>
<?php


?>
</div>

</html>
</body>

Let's say I have an array:

$myArray[0] = "AtG2";
$myArray[1] = "AtG4";
$myArray[2] = "AtG1";
$myArray[3] = "AtG3";
$myArray[4] = "AtG5";

I want to sort it alphanumerically, so that the key/value pairs are as follows:
[zero*] => "AtG1"
[1] => "AtG2"
[2] => "AtG3"
[3] => "AtG4"
[4] => "AtG5"

* = I have to write [zero] because putting an actual zero number inside of [ and ] braces converts it to an HTML list bullet.

It *appears* that natsort() is the proper function for this. The only problem I'm having is that natsort() doesn't manipulate key/value pairs.  To confuse me even more, literally every example I can find on using natsort() uses it in conjunction with print_r() like so:

natsort($someArray);
print_r($someArray);

Obviously, something is happening to $someArray when passed to natsort(), otherwise, print_r() wouldn't be able to order the indices in synch with the natural ordering algorithm.

Well, I don't need my web app to use print_r()! I just need the darn key/value pairs reordered so that when I echo $myArray[3], I know I'm going to get "AtG4".

What am I missing here? What is the point of calling it a "sort" if it doesn't manipulate the key/value pairs??? How can I get what I want?!?

I am running a search query from MYSQL and it works, but now I want to get a little custom.

I am selecting one field, out of many called paid1 which in database is either Yes or No. I want to do this: if paid1 is NO display Pay Now and everything else display Yes. I want this to be under new heading of paid1b. So the code should look something like this:

$paid1b= if(['paid1'}==No){echo "Pay Now";} else {echo "YES";}

But I am missing something somewhere. What is it?
Thanks

The user will click on the first button (.Applybutton) which opens a bootstrap modal with the ID ApplyModal. From then on an apply button (.SendButton) will send the job id that is passed in the first button press $_POST['jobid'] to the database.

foreach ($export as $group => $arrayOpts) 
{
//echo $arrayOpts[0]["choice"]; This returns No
/**
  * If the option hasn't been selected, leave that part out entirely
 **/
if (!empty($arrayOpts)) // if the entire options array isn't empty, we'll display
{
   if ($arrayOpts[0]["choice"]!="0" || $arrayOpts[0]["choice"]!="No")
   {
$pdf->Cell(40,10,$group,0,1); 
$pdf->ImprovedTable($header,$arrayOpts);
$pdf->Ln();
   }
}
}

Unfortunately I can't show print_r's at the moment, the main issue is it's running those $pdf-> lines even if that variable is equal to No, I proved it because up above commented out returns No, but it still runs the pdf code.

Any thoughts? Been staring at it a while, maybe it's something in my conditional statement? Thanks.

Hey guys, been awhile since I have been here, but I hit a little issue in reading session data reliably every time.

What I am doing is reading the variables and values from a rarurlencoded string.
Then putting that into a session array to populate parts of a form and fill in some hidden fields.
After the form posts every now and then, about 1 in 50 or so attempts, I have one (always the same one) that just vanishes.

Anyone ever experience anything like this?

Hi all -

It's gotta be something obvious, but I can't for the life of me how I'm sending output in this file before I send a header redirect.  Can anyone see it?


<?php
//Initialize securimage captcha
session_start();
require_once('dbconnect.php'); // initialize db connection to populate email address
include_once('../securimage/securimage.php');
$language = $_POST['lang'];
include($language . ".php"); //Load language file for feedback. TODO: Maintain separate file for this so the script doesn't need to load so many unused variables?
$securimage = new Securimage();
if ($securimage->check($_POST['captcha_code']) == false) {
  die($contact_bad_captcha);
}

// pump post vars into local vars and clean them up, assign to session to display on contact completion
function lang($language) { //Give hidden post var for language a human name
switch ($language) {
case en:
return "English";
break;
case es:
return "Espa&ntilde;ol";
break;
default:
return "Espa&ntilde;ol";
}
}
$reason = htmlentities($_POST['reason'], ENT_QUOTES);
$name = htmlentities($_POST['name'], ENT_QUOTES);
$email = htmlentities($_POST['email'], ENT_QUOTES);
$phone = htmlentities($_POST['phone'], ENT_QUOTES);
$cell = htmlentities($_POST['cell'], ENT_QUOTES);
$method = htmlentities($_POST['method'], ENT_QUOTES);
$comments = htmlentities($_POST['comments'], ENT_QUOTES);
$lang = lang($language);

// Query for email addresses
$query = "SELECT `description`,`email` FROM contact WHERE `code` = \"" . $reason . "\" AND `language` = \"" . $language . "\"";
$result = mysql_query($query);
while ($row = mysql_fetch_assoc($result)) {
$to = $row['email'];
$reason = $row['description']; 
}
$subject = "ELP Contact Form Submission From " . $name;
$_SESSION['name'] = $name;
$_SESSION['email'] = $email;
$_SESSION['phone'] = $phone;
$_SESSION['cell'] = $cell;
$_SESSION['method'] = $method;
$_SESSION['comments'] = $comments;

// Build the mail object
$header = "From: " . $email . "\r\n";
$header .= "Reply-To: " . $email . "\r\n";
$header .= "Bcc: email@address.com\r\n";
$header .= "Content-type: text/html; charset=iso-8859-1\r\n";
$message = "Reason: " . $reason . "<br>";
$message .= "Name: " . $name . "<br>";
$message .= "Email: " . $email . "<br>";
$message .= "Phone: " . $phone . "<br>";
$message .= "Cell: " . $cell . "<br>";
$message .= "Method to contact: " . $method . "<br>";
$message .= "Comments/Questions: " . nl2br($comments) . "<br>";
$message .= "Language: " . lang($language);

// Send it after checking that variables are set correctly
if (isset($name) && isset($email) && isset($method) && isset($comments) && isset($header) && isset($message)) {
mail($to, $subject, $message, $header);
header("Location: ../contactcomplete.php?lang=" . $language); // Forward to completion page which displays what was sent
}
else {
echo $contact_general_error; //Unknown error
}
?>


Code: [Select]
Warning: Cannot modify header information - headers already sent by (output started at /home1/supresen/public_html/configs/es.php:1) in /home1/supresen/public_html/configs/email.php on line 67
Thanks for the help!

I have a form with a table that contains ONLY dropdown menus for users to select quantities from 25 dinner items.  It contains some Javascript, but nothing fancy.  In an effort to establish my database and TEST to see how some PHP functions might respond so I could improve my form, I created a mini version of the db in MySQL.

But when I click the submit button, the page blinks, the address bar fills with field names, but there is no connect.  No error messages.  No data transfer.  NO NOTHING!

I searched the web and copied a form and plugged it in (an html form, a php insert file, and a MySQL database) and it worked fine.  I peared down my page to mirror it, and still, no success.

What little detail am I missing??  If I have 25 fields but create a db for the first 6, should it function?
If I reduce it and try to re-use the same db, am I persuing a problem?
I've tried error trapping and changing the form inputs, but it just still doesn't connect.

Please help!

I am trying to get a paragraph from a website. Everything works but the first letter is kept on missing. The code shown below is used to get the paragraph. Not sure why the first letter is missing. Please help!!!

Code: [Select]
if ( isset( $offer[ 0 ] ) )
{
// Tidy it up - remove commas and weird Word chars
$off = strip_tags( $offer[ 0 ] );
$off = substr( $off, strpos( $off, ";" ) + 1 );
$off = str_replace("'", "", $off );
$off = trim( $off );

}
else
{
$off = "0";
}

nothing is echoed
for the second foreach???
foreach($pictures as $picture)
-im breaking cause it's a large file


Code: [Select]
$doc = new DOMDocument();
$doc->load('accommodation.xml');

$i = 0;

$accommodations = $doc->getElementsByTagName('accommodation');
foreach($accommodations as $accommodation) {
if(++$i > 2) break;
$supplierID = $accommodation->getElementsByTagName('code')->item(0)->nodeValue;
 $pictures = $accommodation->getElementsByTagName('pictures')->item(0)->nodeValue;
 $pictures=array();
foreach($pictures as $picture) {
echo $url = $picture->getElementsByTagName('url')->item(0)->nodeValue;

}



}//end


//XMl schema
<?xml version="1.0" encoding="utf-8"?>
<accommodations>
<accommodation>
<code>1</code>
<pictures>
<picture>
<url>http://example.com/images.k.jpg</url>
</picture>
</pictures>

Hi,

I have set up a new website, but the old website is using /mainpage.html as it's homepage when searching in Google. This page no longer exists, so when a user clicks on the page in Google, the website is not found.

Is there a way i can set up a forwarder to point the missing file to the new index.php page?

Thanks

i am trying to pull a .txt file for a class assignment and it is pulling everything except for line 1 any suggestions would be great

html:

<html>
<head>
   <title>Weekly Report</title>
   <link rel ="stylesheet" type="text/css" href="sample.css" />
</head>

<body>
   <h1>Weekly Report</h1>
   <p>
   <form action = "weeklyReport1Boles.php" method = "post" >
      <p>
      <input type = "submit" value = "Display the Report" />
      </p>
   </form>
</body>
</html>

txt.file
1  236.00
2  284.00
3  148.00
4  128.00
5  0.00
6  110.00
7  0.00
8

php file:

<?php

$total = $_POST['total'];   
$avgDailyIncome = $_POST['avgDailyIncome'];   
$badDays = $_POST ['badDays'];      
$paintFile = $_POST ['paintfile'];
$nextDay = $_POST['nextDay'];

$paintFile = fopen("weeklyDataBoles.txt","r");
$week = fgets($paintFile);
$total = 0;   

for ($count = 1; $count <=8; $count = $count +1)   
{     
$nextDay = fgets($paintFile);
$total = $total + $nextDay;
}
$avgDailyIncome = $total/7;
print("<p>TOTAL INCOME FROM PAINT CONTRACTS: ");   
print("$".number_format($total, 2)."</p>");   
print("<p>AVG DAILY INCOME FROM PAINT CONTRACTS: ");   
print("$".number_format($avgDailyIncome, 2)."</p>");   
print("<p>NUMBER OF DAYS with NO INCOME: $badDays.</p>");   

?>
</body>
</html>

I've got a syntax error, but I can't for the life of me see where there's a problem.

 unexpected T_VARIABLE, expecting ',' or ';'  ... on line 35

Code: [Select]
<? include("header.php"); ?>

<html>
<head>
<title>login
</title>
</head>
<body>

<?php
// this is the login page

require ('databaseconnect.php');

// set the page title
if (isset($_POST['submitted'])) {
$e = escape_data($_POST['username']);
} else {
echo '<p> >font color="red" size="+1> You forgot to enter your user name</font></p>';
$e = FALSE;
}
// validate password

if (!empty($_POST['password'])) {
$p = escape_data($_POST['password']);
} else {
 $p = FALSE;
echo '<p><font color="red"
size="+1:>You forgot to enter your password!</font></p>;
}

if($e && $p) { 

$query = "SELECT ID, first_name FROM table WHERE 
(username='$e' AND password=SHA('$p') AND active IS NULL";

$result = mysql_query($query) or trigger_error("Query: $query\n<br />
MySQL Error: " . mysql_error());

if (@mysql_num_rows($result) ==1) {

$row = mysql_fetch_array ($result, MYSQL_NUM);
mysql_free_result($result);
mysql_close();

$_SESSION['first_name'] =
$row[1];
$_SESSION['id'] = $row[0];

// start defining url
$url = 'http://' . $_SERVER['HTTP_HOST'] . dirname($_SERVER['PHP_SELF']);

// check for trailing slash illegal access attempts
if ((substr($url, -1) == '/') OR (substr($url, -1) == '\\') ) {
$url = substr ($url, 0, -1); // chop off slash
}
$url .= '/index.php';

ob_end_clean(); //delete the buffer
header(:location: $url");
exit();

} else { // no match made
echo '<p> >font color="red"size="+1"> Either the user name and password are not correct or you have not activated your account. </font></p>';

}
mysql_close();

}

?>

<h1>Login</h1>
<p> your browser must allow cookies to log in.</p>
<form action="login.php" method="post">
<fieldset>
<p><b>User name: <input type="text" name="username" size="20" maxlength="20" value="<?php if (isset($_POST['username'])) echo $_POST['username']; ?> /></p>
<p><b> Password: <input type="password" name="password" size="20" maxlength="20" /></p>
<div> align="center"><input type="submit" name="submit" value="Login" /></div>
<input type="hidden" name="submitted" value="TRUE" />
</fieldset>
</form>


<? include("footer.php"); ?>