PHP - Finding Dates, And Placing Them In Variables

Hi,

$_POST['arr_name'];


I want to make the search so that am getting the array values and oputting in IN(val1, val2, val3)


Thanks

Hi,

I have a project, where i want to place a text over the image dynamically, just like if it is sold, i want to make it as SOLD text over the image

Looking for idea to implement this,

Thanks,

Okay,

I would like to redirect my page within a specific time using java script:

<meta http-equiv="Refresh" content="3;url=<?PHP echo 'progress.php?user=';$session->username?>">

Basically, I would like it to redirect to this: progress.php?user=$session->username.

But it redirects to: progress.php?user=

Please help, thanks ...

I have two different tables and I am trying to condense them into one table.   The structure of the tables is   cc -- ci -- cc -- cn -- alpha_2   countries -- id -- cn -- alpha_2 -- alpha_3   What I want to do is place the info from the column alpha_2 in the countries table into the alpha_2 column in the cc table. I have tried inner joins, left joins, Insert and Select index. Everything that I have tried gives me an error message. I do not know what I am doing wrong and I was hoping that someone would be able to give me a hand.   I forgot to mention that I want the placement of the alpha_2 column to be based on the cn columns in both tables. So that the information in the alpha_2 column lines up with the right name in the cn column
Edited by mdmartiny, 09 August 2014 - 01:07 PM.

I believe the solution the my problem should be simple I feel that it's staring me right in the face. I have a Cron Job that sends an email message to users who's bill "due date" falls on the current date. I want to make the email more personalized and say:   Dear John Doe:   You have the following bills due today:   Rent Cable Internet   Please login to pay your bills   Thanks,.   Here's my following PHP code

<?php
header("Content-type: text/plain");
 
// OPEN DATA BASE
define("HOSTNAME","localhost");
define("USERNAME","");
define("PASSWORD","");
define("DATABASE","");
 
mysql_connect(HOSTNAME, USERNAME, PASSWORD) or die("Connetion to database failed!");
mysql_select_db(DATABASE); 
 
joinDateFilter();
 
// BILL QUERY
function joinDateFilter(){
     $query = mysql_query("SELECT bills.billname, bills.duedate, bills.firstname, bills.email, bills.paid FROM bills JOIN users ON bills.userid=users.userid WHERE DATE(bills.duedate) = CURDATE() AND bills.PAID != 'YES'");
     $mail_to = "";
     while ($row = mysql_fetch_array($query)){
      echo $row['firstname']." - ".$row['email']."\n";
  $mail_to = $row['email'].", ";
     }
     if (!empty($mail_to)){
      sendEmail($mail_to);
     }
}
 
// SEND EMAIL
function sendEmail($mail_to) {
$from    = "MyEmail@myemail.com";
$message = "Dear " . $row['firstname'].", <br><br>"
 
."You have the following bills due today.<br><br>"
.$row['billname']. "<br><br>"
."Please login to pay your bills";
 
$headers = 'From: '.$from."\r\n" .
'Reply-To:'.$_POST['email']."\r\n" .
"Content-Type: text/html; charset=iso-8859-1\n".
'X-Mailer: PHP/' . phpversion();
mail($mail_to, "Today is your due date", $message, $headers);
}
?>

Edited by demeritrious, 26 December 2014 - 07:21 PM.

Hi There,

I would like to place the last for month names into an variable- for example:

February 2011
January 2011
December 2010
November 2010

But I would like them to all have the same variable ($date) - so when I use it in a mssql_fetch_assoc - it increments with every instance of $date, as there will be one instance of $date for every row returned, getting older with every row.

Hope that is enough info?

Cheers
Matt

Hi Guys,

I'm going to try and watermark my uploaded images with a small logo (placed onto the original image) so they are all watermarked, is there any tutorials anyone can recommend to do this? i can't seem to find any online.

thanks for any help guys

Graham

I want a div at the bottom of another div, and I want it centered, just using css not javascript.

HTML
<div id="parent">
      <div id="bottom_element">test</div>
</div>


CSS
#parent {height:100% width:100%}
#bottom_element {position:absolute; bottom:5px; width:200px; margin:0 auto}

So the issue is that position absolute and margin auto do not seem to work together. What is an alternative without javasript?

Basically i have a folder with 100+ images they are NOT all the same extension, what im wanting to do is use PHP to find all the images and put them all in a database. how would i go about doing this?

thanks

does anyone know how to decode this XML variable value into string values? I also need to know the oposite way: creating variable values into xml. I've tried several code examples but they did filter the requested data.

Code: [Select]
$xml='<?xml version="1.0" encoding="utf-8"?>
<elements>
<text identifier="ed9cdd4c-ae8b-4ecb-bca7-e12a5153bc02">
  <value/>
</text>
<textarea identifier="a77f06fc-1561-453c-a429-8dd05cdc29f5">
  <value><![CDATA[<p style="text-align: justify;">Lorem ipsum dolor sit amet, consetetur sadipscing elitr, sed diam nonumy eirmod tempor invidunt ut labore et dolore magna aliquyam erat, sed diam voluptua. At vero eos et accusam et justo duo dolores et ea rebum. Stet clita kasd gubergren, no sea takimata sanctus est Lorem ipsum dolor sit amet.</p>]]></value>
</textarea>
<textarea identifier="1a85a7a6-2aba-4480-925b-6b97d311ee6c">
  <value><![CDATA[<p style="text-align: justify;">Lorem ipsum dolor sit amet, consetetur sadipscing elitr, sed diam nonumy  eirmod tempor invidunt ut labore et dolore magna aliquyam erat, sed  diam voluptua. At vero eos et accusam et justo duo dolores et ea rebum.  Stet clita kasd gubergren, no sea takimata sanctus est Lorem ipsum dolor  sit amet.</p>]]></value>
</textarea>
<image identifier="ffcc1c50-8dbd-4115-b463-b43bdcd44a57">
  <file><![CDATA[images/stories/red/cars/autobedrijf.png]]></file>
  <title/>
  <link/>
  <target/>
  <rel/>
  <lightbox_image/>
  <width><![CDATA[250]]></width>
  <height><![CDATA[187]]></height>
</image>
<text identifier="4339a108-f907-4661-9aab-d6f3f00e736e">
  <value><![CDATA[Kramer 5]]></value>
</text>
<text identifier="ea0666d7-51e3-4e52-8617-25e3ad61f8b8">
  <value><![CDATA[6000 RS]]></value>
</text>
<text identifier="90a18889-884b-4d53-a302-4e6e4595efa0">
  <value><![CDATA[Eindhoven]]></value>
</text>
<text identifier="410d72e0-29b3-4a92-b7d7-f01e828b1586">
  <value><![CDATA[APK Pick up and return]]></value>
</text>
<text identifier="45b86f23-e656-4a81-bb8f-84e5ea76f71f">
  <value><![CDATA[15% korting op grote beurt]]></value>
</text>
<text identifier="3dbbe1c6-15d6-4375-9f2f-f0e7287e29f3">
  <value><![CDATA[Gratis opslag zomerbanden]]></value>
</text>
<text identifier="2e878db0-605d-4d58-9806-8e75bced67a4">
  <value><![CDATA[Gratis abonnement of grote beurt]]></value>
</text>
<text identifier="94e3e08f-e008-487b-9cbd-25d108a9705e">
  <value/>
</text>
<text identifier="73e74b73-f509-4de7-91cf-e919d14bdb0b">
  <value/>
</text>
<text identifier="b870164b-fe78-45b0-b840-8ebceb9b9cb6">
  <value><![CDATA[040 123 45 67]]></value>
</text>
<text identifier="8a91aab2-7862-4a04-bd28-07f1ff4acce5">
  <value/>
</text>
<email identifier="3f15b5e4-0dea-4114-a870-1106b85248de">
  <value/>
  <text/>
  <subject/>
  <body/>
</email>
<link identifier="0b3d983e-b2fa-4728-afa0-a0b640fa34dc">
  <value/>
  <text/>
  <target/>
  <custom_title/>
  <rel/>
</link>
<relateditems identifier="7056f1d2-5253-40b6-8efd-d289b10a8c69"/>
<rating identifier="cf6dd846-5774-47aa-8ca7-c1623c06e130">
  <votes><![CDATA[1]]></votes>
  <value><![CDATA[1.0000]]></value>
</rating>
<googlemaps identifier="160bd40a-3e0e-48de-b6cd-56cdcc9db892">
  <location><![CDATA[50.895711,5.955427]]></location>
</googlemaps>
</elements>';

Hi

I have a file, that is copied from other files. All other files work perfectly.
But, for some reason this one is throwing back an error.

I've been over it so many time, but can't see whats wrong.

Error:
Fatal error: Call to undefined method stdClass::save() in /home/p/o/powtest/web/public_html/admin/lib/ajax_php/add_interests.php on line 28


add_interests.php
Code: [Select]
<?PHP
require_once("../../../includes/initialize.php");

$flag = 0;
$ID = $_POST['ID'];
$type = $_POST['type'];
$category = $_POST['category'];
$interest = $_POST['interest'];
$expInt = explode("\n", $interest);
$DMOD = date('Y-m-d');
$TMOD = date('H:i:s');

$check_entry = Admin_interest::if_exists(clean_input_value($category));
if($check_entry == 0){
$new_category = Admin_interest::make($ID, clean_input_value($category), clean_input_value($type), $DMOD, $TMOD);
if($new_category && $new_category->save()){
$CID = $new_category->id;
$flag = 1;
}
}


foreach($expInt as $expInts){

$check_entry = Admin_interests_sub::if_exists($CID, clean_input_value($expInts));
if($check_entry == 0){
$new_interest = Admin_interests_sub::make($ID, $CID, clean_input_value($expInts), $DMOD, $TMOD);
if($new_interest && $new_interest->save()){
$message = 'Thank You: Your list Has Been Saved';
}else{
$message = "Sorry, There was an error";
}
}

}

echo $message;
?>


Class:
Code: [Select]
<?PHP
require_once(LIB_PATH.DS.'database.php');

class Admin_interests_sub {

protected static $table_name="admin_interests_sub";
protected static $db_fields = array('id', 'category_id', 'interest_sub', 'dateMod', 'timeMod');
public $id;
public $category_id;
public $interest_sub;
public $dateMod;
public $timeMod;


public static function make($ID, $category_id, $interest_sub, $DMOD, $TMOD){
if(!empty($interest_sub)){
$interest = new Admin_interests_sub();
$interest->id = (int)$ID;
$interest->category_id = (int)$category_id;
$interest->interest_sub = $interest_sub;
$kw->dateMod = $DMOD;
$kw->timeMod = $TMOD;
return $kw;
}else{
return false;
}
}

protected function attributes(){
$attributes = array();
foreach(self::$db_fields as $field){
if(property_exists($this, $field)){
$attributes[$field] = $this->$field;
}
}
return $attributes;
}

protected function sanitized_attributes(){
global $database;
$clean_attributes = array();
foreach($this->attributes() as $key => $value){
$clean_attributes[$key] = $database->escape_value($value);
}
return $clean_attributes;
}

public function save(){
return !empty($this->id) ? $this->update() : $this->create();
}

public function create(){
global $database;
$attributes = $this->sanitized_attributes();
$sql = "INSERT INTO ".self::$table_name." (";
$sql .= join(", ", array_keys($attributes));
$sql .= ") VALUES ('";
$sql .= join("', '", array_values($attributes));
$sql .= "')";
if($database->query($sql)){
$this->id = $database->insert_id();
return true;
}else{
return false;
}
}

public function update(){
global $database;
$attributes = $this->sanitized_attributes();
$attribute_pairs = array();
foreach($attributes as $key => $value){
$attribute_pairs[] = "{$key}='{$value}'";
}
$sql = "UPDATE ".self::$table_name." SET ";
$sql .= join(", ", $attribute_pairs);
$sql .= " WHERE id=".$database->escape_value($this->id);
$database->query($sql);
return ($database->affected_rows() == 1) ? true : false;
}

public function delete(){
global $database;
$sql = "DELETE FROM ".self::$table_name." ";
$sql .= "WHERE id=".$database->escape_value($this->id);
$sql .= " LIMIT 1";
$database->query($sql);
return ($database->affected_rows() == 1) ? true : false;
}

}

?>


Any help finding this bug will be a big help.

Thanks

Okay I'm done with searching for answers, working on this preg_match for about 3 hours now.   I'm looking for "($0.01/$0.02 USD)" in a string. The needle might be slighty different. Possible strings that I might look for is:

(€xx.xx/€xx.xx EUR) where the EUR can be changed into USD, including its signs.

Hi ,

I'm new on this forum so don't judge too hard.. But I have a few questions. I am recently new to PHP as this is my first computer language I've learnt besides HTML.

My first question is, what's the difference between !== and !=, and is it more secure to use !== when comparing two fields such as passwords? I've different things and this has confused me.. 

And my second question is, I have this piece of code

Code: [Select]
/* option error checking */
      $field = "option";  // Use field name for option
         /* Check if the option picked is from the list of options to choose from*/
      if($suboption !== "option1" || $suboption !== "option2" || $suboption !== "option3" || $suboption !== "option4" || $suboption !== "option5" || $suboption !== "option6" || $suboption !== "option7"){
            $form->setError($field, "* Unexpected error with option");
      }
I'm guessing in the long run, this will slow down my script.. is there an easier way of checking without using || $suboption !== and is it okay if I've used !==?
Like I said I'm new to this so please don't flame.. I've done some research but I can't seem to find some accurate answer.

Thank you,

ZT

I am trying to find the URL to a directory TWO levels above the script level (if you know what I mean).

For example.. the script sits at
Code: [Select]
http://www.domain.com/TestArea2/members/index.php
BUT I need to find the path to 
Code: [Select]
http://www.domain.com/TestArea2/

the nearest I get is...


$domain = $_SERVER['HTTP_HOST'];
$domain .=  $_SERVER['REQUEST_URI'];
echo $domain; // outputs www.domain.com/TestArea2/members/index.php 



Is there a simple method to do this or have I got to split the string and work backwards?

Many thanks

My query is not finding the last recieptnum entry, it is finding the number 9 everytime for some odd reason. Im trying to incrementally increase this each time a reciept is created.

$getreceiptnum = mysql_query("SELECT receiptnum FROM accounting WHERE agency = '$agency' ORDER BY receiptnum DESC LIMIT 1") or die(mysql_error());
        $recieptarray = mysql_fetch_array($getreceiptnum);
        $recieptnum = $recieptarray['receiptnum'];
        echo $recieptnum;