Learn VBA & Macros in 1 Week!

PHP - Date Headache.

Full Excel VBA Course - Beginner to Expert

Date Headache.	View Content

Hi there.

I'm trying to create my own search function for users to search for events between certain dates. One option I have is 'within next 7 days'.

So, within the SQL function I am searching "... WHERE eventdate between $from and $to.."

The $from variable I figured would be $from = date('d-m-Y',time()); (ie- todays date)... but how would I find the date in 7 days?. I've seen strtotime mentioned about the web but can't figure how this applies.

Any help would be marvelous!

Cheers,
Paddyfields.

Full Excel VBA Course - Beginner to Expert

Man! I Have Such A Headache Converting Utf - Someone Help!

Similar Tutorials

View Content

Hi All,

I am trying to convert HTMLentities style encoding, to UTF decimal encoding.

I.e. int the text:

U+001D 1d <control> 
U+007D } 7d RIGHT CURLY BRACKET 
U+00A2 ¢ c2 a2 CENT SIGN 

I want the ¢ to be its UTF decimal equivalent.

that make sense??

Basically, i'm parsing text for an epub and it wont accept special characters in the html entities form - only the decimal form. Rubbish eh?

The entire test text i am using is this (there is some HTML in there you see that i DO NOT want converting - basically only things between the &..

THANKS!

<html xmlns="http://www.w3.org/1999/xhtml" xmlns:xlink="http://www.w3.org/1999/xlink"><head><meta http-equiv="Content-Type" content="text/html; charset=utf-8"/>
<title>Testing images</title>
<link href="stylesheet.css" charset="UTF-8" type="text/css" rel="stylesheet" />
</head>
<body><h2>Character Testing</h2>U+0000 00 <control> 
U+0001 01 <control> 
U+0002 02 <control> 
U+0003 03 <control> 
U+0004 04 <control> 
U+0005 05 <control> 
U+0006 06 <control> 
U+0007 07 <control> 
U+0008 08 <control> 
U+0009 09 <control> 
U+000A 0a <control> 
U+000B 0b <control> 
U+000C 0c <control> 
U+000D 0d <control> 
U+000E 0e <control> 
U+000F 0f <control> 
U+0010 10 <control> 
U+0011 11 <control> 
U+0012 12 <control> 
U+0013 13 <control> 
U+0014 14 <control> 
U+0015 15 <control> 
U+0016 16 <control> 
U+0017 17 <control> 
U+0018 18 <control> 
U+0019 19 <control> 
U+001A 1a <control> 
U+001B 1b <control> 
U+001C 1c <control> 
U+001D 1d <control> 
U+001E 1e <control> 
U+001F 1f <control> 
U+0020 20 SPACE 
U+0021 ! 21 EXCLAMATION MARK 
U+0022 " 22 QUOTATION MARK 
U+0023 # 23 NUMBER SIGN 
U+0024 $ 24 DOLLAR SIGN 
U+0025 % 25 PERCENT SIGN 
U+0026 & 26 AMPERSAND 
U+0027 ' 27 APOSTROPHE 
U+0028 ( 28 LEFT PARENTHESIS 
U+0029 ) 29 RIGHT PARENTHESIS 
U+002A * 2a ASTERISK 
U+002B + 2b PLUS SIGN 
U+002C , 2c COMMA 
U+002D - 2d HYPHEN-MINUS 
U+002E . 2e FULL STOP 
U+002F / 2f SOLIDUS 
U+0030 0 30 DIGIT ZERO 
U+0031 1 31 DIGIT ONE 
U+0032 2 32 DIGIT TWO 
U+0033 3 33 DIGIT THREE 
U+0034 4 34 DIGIT FOUR 
U+0035 5 35 DIGIT FIVE 
U+0036 6 36 DIGIT SIX 
U+0037 7 37 DIGIT SEVEN 
U+0038 8 38 DIGIT EIGHT 
U+0039 9 39 DIGIT NINE 
U+003A : 3a COLON 
U+003B ; 3b SEMICOLON 
U+003C < 3c LESS-THAN SIGN 
U+003D = 3d EQUALS SIGN 
U+003E > 3e GREATER-THAN SIGN 
U+003F ? 3f QUESTION MARK 
U+0040 @ 40 COMMERCIAL AT 
U+0041 A 41 LATIN CAPITAL LETTER A 
U+0042 B 42 LATIN CAPITAL LETTER B 
U+0043 C 43 LATIN CAPITAL LETTER C 
U+0044 D 44 LATIN CAPITAL LETTER D 
U+0045 E 45 LATIN CAPITAL LETTER E 
U+0046 F 46 LATIN CAPITAL LETTER F 
U+0047 G 47 LATIN CAPITAL LETTER G 
U+0048 H 48 LATIN CAPITAL LETTER H 
U+0049 I 49 LATIN CAPITAL LETTER I 
U+004A J 4a LATIN CAPITAL LETTER J 
U+004B K 4b LATIN CAPITAL LETTER K 
U+004C L 4c LATIN CAPITAL LETTER L 
U+004D M 4d LATIN CAPITAL LETTER M 
U+004E N 4e LATIN CAPITAL LETTER N 
U+004F O 4f LATIN CAPITAL LETTER O 
U+0050 P 50 LATIN CAPITAL LETTER P 
U+0051 Q 51 LATIN CAPITAL LETTER Q 
U+0052 R 52 LATIN CAPITAL LETTER R 
U+0053 S 53 LATIN CAPITAL LETTER S 
U+0054 T 54 LATIN CAPITAL LETTER T 
U+0055 U 55 LATIN CAPITAL LETTER U 
U+0056 V 56 LATIN CAPITAL LETTER V 
U+0057 W 57 LATIN CAPITAL LETTER W 
U+0058 X 58 LATIN CAPITAL LETTER X 
U+0059 Y 59 LATIN CAPITAL LETTER Y 
U+005A Z 5a LATIN CAPITAL LETTER Z 
U+005B [ 5b LEFT SQUARE BRACKET 
U+005C \ 5c REVERSE SOLIDUS 
U+005D ] 5d RIGHT SQUARE BRACKET 
U+005E ^ 5e CIRCUMFLEX ACCENT 
U+005F _ 5f LOW LINE 
U+0060 ` 60 GRAVE ACCENT 
U+0061 a 61 LATIN SMALL LETTER A 
U+0062 b 62 LATIN SMALL LETTER B 
U+0063 c 63 LATIN SMALL LETTER C 
U+0064 d 64 LATIN SMALL LETTER D 
U+0065 e 65 LATIN SMALL LETTER E 
U+0066 f 66 LATIN SMALL LETTER F 
U+0067 g 67 LATIN SMALL LETTER G 
U+0068 h 68 LATIN SMALL LETTER H 
U+0069 i 69 LATIN SMALL LETTER I 
U+006A j 6a LATIN SMALL LETTER J 
U+006B k 6b LATIN SMALL LETTER K 
U+006C l 6c LATIN SMALL LETTER L 
U+006D m 6d LATIN SMALL LETTER M 
U+006E n 6e LATIN SMALL LETTER N 
U+006F o 6f LATIN SMALL LETTER O 
U+0070 p 70 LATIN SMALL LETTER P 
U+0071 q 71 LATIN SMALL LETTER Q 
U+0072 r 72 LATIN SMALL LETTER R 
U+0073 s 73 LATIN SMALL LETTER S 
U+0074 t 74 LATIN SMALL LETTER T 
U+0075 u 75 LATIN SMALL LETTER U 
U+0076 v 76 LATIN SMALL LETTER V 
U+0077 w 77 LATIN SMALL LETTER W 
U+0078 x 78 LATIN SMALL LETTER X 
U+0079 y 79 LATIN SMALL LETTER Y 
U+007A z 7a LATIN SMALL LETTER Z 
U+007B { 7b LEFT CURLY BRACKET 
U+007C | 7c VERTICAL LINE 
U+007D } 7d RIGHT CURLY BRACKET 
U+007E ~ 7e TILDE 
U+007F 7f <control> 
U+0080 c2 80 <control> 
U+0081 c2 81 <control> 
U+0082 c2 82 <control> 
U+0083 c2 83 <control> 
U+0084 c2 84 <control> 
U+0085 c2 85 <control> 
U+0086 c2 86 <control> 
U+0087 c2 87 <control> 
U+0088 c2 88 <control> 
U+0089 c2 89 <control> 
U+008A c2 8a <control> 
U+008B c2 8b <control> 
U+008C c2 8c <control> 
U+008D c2 8d <control> 
U+008E c2 8e <control> 
U+008F c2 8f <control> 
U+0090 c2 90 <control> 
U+0091 c2 91 <control> 
U+0092 c2 92 <control> 
U+0093 c2 93 <control> 
U+0094 c2 94 <control> 
U+0095 c2 95 <control> 
U+0096 c2 96 <control> 
U+0097 c2 97 <control> 
U+0098 c2 98 <control> 
U+0099 c2 99 <control> 
U+009A c2 9a <control> 
U+009B c2 9b <control> 
U+009C c2 9c <control> 
U+009D c2 9d <control> 
U+009E c2 9e <control> 
U+009F c2 9f <control> 
U+00A0 c2 a0 NO-BREAK SPACE 
U+00A1 ¡ c2 a1 INVERTED EXCLAMATION MARK 
U+00A2 ¢ c2 a2 CENT SIGN 
U+00A3 £ c2 a3 POUND SIGN 
U+00A4 ¤ c2 a4 CURRENCY SIGN 
U+00A5 ¥ c2 a5 YEN SIGN 
U+00A6 ¦ c2 a6 BROKEN BAR 
U+00A7 § c2 a7 SECTION SIGN 
U+00A8 ¨ c2 a8 DIAERESIS 
U+00A9 © c2 a9 COPYRIGHT SIGN 
U+00AA ª c2 aa FEMININE ORDINAL INDICATOR 
U+00AB « c2 ab LEFT-POINTING DOUBLE ANGLE QUOTATION MARK 
U+00AC ¬ c2 ac NOT SIGN 
U+00AD c2 ad SOFT HYPHEN 
U+00AE ® c2 ae REGISTERED SIGN 
U+00AF ¯ c2 af MACRON 
U+00B0 ° c2 b0 DEGREE SIGN 
U+00B1 ± c2 b1 PLUS-MINUS SIGN 
U+00B2 ² c2 b2 SUPERSCRIPT TWO 
U+00B3 ³ c2 b3 SUPERSCRIPT THREE 
U+00B4 ´ c2 b4 ACUTE ACCENT 
U+00B5 µ c2 b5 MICRO SIGN 
U+00B6 ¶ c2 b6 PILCROW SIGN 
U+00B7 · c2 b7 MIDDLE DOT 
U+00B8 ¸ c2 b8 CEDILLA 
U+00B9 ¹ c2 b9 SUPERSCRIPT ONE 
U+00BA º c2 ba MASCULINE ORDINAL INDICATOR 
U+00BB » c2 bb RIGHT-POINTING DOUBLE ANGLE QUOTATION MARK 
U+00BC ¼ c2 bc VULGAR FRACTION ONE QUARTER 
U+00BD ½ c2 bd VULGAR FRACTION ONE HALF 
U+00BE ¾ c2 be VULGAR FRACTION THREE QUARTERS 
U+00BF ¿ c2 bf INVERTED QUESTION MARK 
U+00C0 À c3 80 LATIN CAPITAL LETTER A WITH GRAVE 
U+00C1 Á c3 81 LATIN CAPITAL LETTER A WITH ACUTE 
U+00C2 Â c3 82 LATIN CAPITAL LETTER A WITH CIRCUMFLEX 
U+00C3 Ã c3 83 LATIN CAPITAL LETTER A WITH TILDE 
U+00C4 Ä c3 84 LATIN CAPITAL LETTER A WITH DIAERESIS 
U+00C5 Å c3 85 LATIN CAPITAL LETTER A WITH RING ABOVE 
U+00C6 Æ c3 86 LATIN CAPITAL LETTER AE 
U+00C7 Ç c3 87 LATIN CAPITAL LETTER C WITH CEDILLA 
U+00C8 È c3 88 LATIN CAPITAL LETTER E WITH GRAVE 
U+00C9 É c3 89 LATIN CAPITAL LETTER E WITH ACUTE 
U+00CA Ê c3 8a LATIN CAPITAL LETTER E WITH CIRCUMFLEX 
U+00CB Ë c3 8b LATIN CAPITAL LETTER E WITH DIAERESIS 
U+00CC Ì c3 8c LATIN CAPITAL LETTER I WITH GRAVE 
U+00CD Í c3 8d LATIN CAPITAL LETTER I WITH ACUTE 
U+00CE Î c3 8e LATIN CAPITAL LETTER I WITH CIRCUMFLEX 
U+00CF Ï c3 8f LATIN CAPITAL LETTER I WITH DIAERESIS 
U+00D0 Ð c3 90 LATIN CAPITAL LETTER ETH 
U+00D1 Ñ c3 91 LATIN CAPITAL LETTER N WITH TILDE 
U+00D2 Ò c3 92 LATIN CAPITAL LETTER O WITH GRAVE 
U+00D3 Ó c3 93 LATIN CAPITAL LETTER O WITH ACUTE 
U+00D4 Ô c3 94 LATIN CAPITAL LETTER O WITH CIRCUMFLEX 
U+00D5 Õ c3 95 LATIN CAPITAL LETTER O WITH TILDE 
U+00D6 Ö c3 96 LATIN CAPITAL LETTER O WITH DIAERESIS 
U+00D7 × c3 97 MULTIPLICATION SIGN 
U+00D8 Ø c3 98 LATIN CAPITAL LETTER O WITH STROKE 
U+00D9 Ù c3 99 LATIN CAPITAL LETTER U WITH GRAVE 
U+00DA Ú c3 9a LATIN CAPITAL LETTER U WITH ACUTE 
U+00DB Û c3 9b LATIN CAPITAL LETTER U WITH CIRCUMFLEX 
U+00DC Ü c3 9c LATIN CAPITAL LETTER U WITH DIAERESIS 
U+00DD Ý c3 9d LATIN CAPITAL LETTER Y WITH ACUTE 
U+00DE Þ c3 9e LATIN CAPITAL LETTER THORN 
U+00DF ß c3 9f LATIN SMALL LETTER SHARP S 
U+00E0 à c3 a0 LATIN SMALL LETTER A WITH GRAVE 
U+00E1 á c3 a1 LATIN SMALL LETTER A WITH ACUTE 
U+00E2 â c3 a2 LATIN SMALL LETTER A WITH CIRCUMFLEX 
U+00E3 ã c3 a3 LATIN SMALL LETTER A WITH TILDE 
U+00E4 ä c3 a4 LATIN SMALL LETTER A WITH DIAERESIS 
U+00E5 å c3 a5 LATIN SMALL LETTER A WITH RING ABOVE 
U+00E6 æ c3 a6 LATIN SMALL LETTER AE 
U+00E7 ç c3 a7 LATIN SMALL LETTER C WITH CEDILLA 
U+00E8 è c3 a8 LATIN SMALL LETTER E WITH GRAVE 
U+00E9 é c3 a9 LATIN SMALL LETTER E WITH ACUTE 
U+00EA ê c3 aa LATIN SMALL LETTER E WITH CIRCUMFLEX 
U+00EB ë c3 ab LATIN SMALL LETTER E WITH DIAERESIS 
U+00EC ì c3 ac LATIN SMALL LETTER I WITH GRAVE 
U+00ED í c3 ad LATIN SMALL LETTER I WITH ACUTE 
U+00EE î c3 ae LATIN SMALL LETTER I WITH CIRCUMFLEX 
U+00EF ï c3 af LATIN SMALL LETTER I WITH DIAERESIS 
U+00F0 ð c3 b0 LATIN SMALL LETTER ETH 
U+00F1 ñ c3 b1 LATIN SMALL LETTER N WITH TILDE 
U+00F2 ò c3 b2 LATIN SMALL LETTER O WITH GRAVE 
U+00F3 ó c3 b3 LATIN SMALL LETTER O WITH ACUTE 
U+00F4 ô c3 b4 LATIN SMALL LETTER O WITH CIRCUMFLEX 
U+00F5 õ c3 b5 LATIN SMALL LETTER O WITH TILDE 
U+00F6 ö c3 b6 LATIN SMALL LETTER O WITH DIAERESIS 
U+00F7 ÷ c3 b7 DIVISION SIGN 
U+00F8 ø c3 b8 LATIN SMALL LETTER O WITH STROKE 
U+00F9 ù c3 b9 LATIN SMALL LETTER U WITH GRAVE 
U+00FA ú c3 ba LATIN SMALL LETTER U WITH ACUTE 
U+00FB û c3 bb LATIN SMALL LETTER U WITH CIRCUMFLEX 
U+00FC ü c3 bc LATIN SMALL LETTER U WITH DIAERESIS 
U+00FD ý c3 bd LATIN SMALL LETTER Y WITH ACUTE 
U+00FE þ c3 be LATIN SMALL LETTER THORN 
U+00FF ÿ c3 bf LATIN SMALL LETTER Y WITH DIAERESIS
</body>
</html>

Cookie Headache

Similar Tutorials

View Content

Hi All, I seem to be getting in a right mess with this, so hope someone can help. I'm simply trying to set a cookie called 'defaultLanguage'. It will initially be set to English and when someone completes a form, the form value is then passed and used in the cookie. here's my code:

$cookie_name = 'defaultLanguage';
$cookie_value = $_GET["language"];
if ($cookie_value == ''){
	$cookie_value = 'English';
}else{
	$cookie_value = $_GET["language"];
}
setcookie($cookie_name, $cookie_value, time() + (86400 * 30), '/'); // 86400 = 1 day

I then use this to test/check:

$cookie_name = 'defaultLanguage';
if(!isset($_COOKIE[$cookie_name])) {
  print 'Cookie with name "' . $cookie_name . '" does not exist...';
} else {
  print 'Cookie with name "' . $cookie_name . '" value is: ' . $_COOKIE[$cookie_name];
}

If I clear my browser cookies, this is what happens: On initial page load it says: Cookie with name "defaultLanguage" does not exist... If I reload the page or move to another, it says: Cookie with name "defaultLanguage" value is: English If I then complete my form, ?language=French is added to the URL, however, it still says: Cookie with name "defaultLanguage" value is: English I think I' missing something obvious but can't see for looking!! Any help is much appreciated

Dates Headache :-(

Similar Tutorials

View Content

Hi all,

I am having bit of a headache in trying to achieve what I want!

Basically I have a date coming into the script as this format:

Tue May 24 18:51:38 +0000 2011

These are the steps I wish to do an not quite sure how!

1. Make date read: May 24 2011
2. Add 6 Months to date and store as new variable

For part 2 I am guessing I can do something like:

Code: [Select]
<?php
$futuredate = strtotime('+6 months', $date)
?>;
But part one is stumping me!

Thanks

Learning Php, Java Dev With A Headache.

Similar Tutorials

View Content

i Have this Form

<form action="action_page.php" method="POST"> <div class="form-group"> <label for="email">Email address:</label> <input type="email" class="form-control" id="email"> </div> <div class="form-group"> <label for="pwd">Password:</label> <input type="password" class="form-control" id="pwd"> </div> <div class="checkbox"> <label><input type="checkbox"> Remember me</label> </div> <button type="submit" class="btn btn-default">Submit</button> </form>

And im trying to pass the information into a USER class and print out the result in a action_page.php.

<?php class User {

private $password;

private $emailAddress;

function __construct() {

$this->emailAddress = isset($_POST['email']) ? $_POST['email'] : null;

$this->password = isset($_POST['pwd']) ? $_POST['pwd'] : null; }

function start() { if (empty($this->password) || empty($this->emailAddress)) {

throw new Exception("Empty Post not allowed");

} else

{ echo " Registration Done";

}

$register = new User(); if(!empty($_POST)) { $register->start(); }

Then in my action page i try to refernence the Object with

?php include "User.php";

$user = new User(); try { $user->start(); }

catch (Exception $e) { echo "Cannot Find account"; }

but it never can do it ?

Anyone any ideas ??

Prepared Statements Headache

Similar Tutorials

View Content

I've had to rearrange a lot of code and I've been trying to put together a prepared statement in a registration form. I'm having a really hard time and being very new to PHP the issue is really confusing for me.

first, I have this function:

//PROCESS DB
function process_database($post) {
  global $table;
  global $conn;

  //THIS FUCKING THING IS DRIVING ME
  //check database connection
  if ($conn->connect_error) {
    return false;

  } else {
    if($statement = $conn->prepare("INSERT INTO $table (username, email, password) VALUES ( ?, ?, ? )")){
      
      $username = $post['username'];
      $email = $post['email'];
      $password = $post['password'];

      $statement->bind_param("sss", $username, $email, $password);

      $statement->execute();
      
      //DEBUGGING
      echo "Added: ".$username.", ".$email.", ".$password."<br>";

      if(!$statement->execute()){
        printf("Connect Failed: %s\n", $conn->connect_error);
      } else {
        echo 'fuckin ay!!!';
      }
      //END DEBUG BLOCK

    } else {
      return false;
    }
  }
  return true; 
}

The issue is very strange. I'll post the function call so it's clear:

//process database actions
  if (!process_database($data) ) {
    return array( 'status' => 0, 'message' => 'Unable to process database request' );
  }

When I run the registration.py without process_database() everything is fine, so I'm confident in the error processing. Here's where it get weird -

when I process the form

Quote

echo "Added: ".$username.", ".$email.", ".$password." ";

is returned from the //DEBUGGING BLOCK but I also get back the error from the following if statement - "Connection Failed: ...."

BUT I also get back the registration successful message that only shows if the function returns true

In short, it's giving me 2 positive affirmations but also the Connection failed message and of course it's not adding anything to the database. I've been working this function all day, and I'm lost for answers. What's going on with this code? I can't see where I've gone wrong

Edited July 1 by TechnoDiver

Unknown Column In 'field List' Error Is A Headache

Similar Tutorials

View Content

Hi there

I'm trying to insert audi files' records into mysql database this is how the records insertion looks like:

Code: [Select]
$fileName = $_FILES['uploaded']['name'];//name
$tmpName = $_FILES['uploaded']['tmp_name'];//temp location
$fileSize = $_FILES['uploaded']['size'];//size of the file
$fileType = $_FILES['uploaded']['type'];//type of file
$error = $_FILES['uploaded']['error'];//verifys errprs
$ext = substr($fileName, strrpos($fileName, '.') +1); //this will get the extention out of the file name e.g. .mp3

//check that a file is passed by and no errors
if(isset($fileName) && $error == 0 && $fileSize != 0){

//condition to accept only certain file types/extentions
if($ext == "mp3" || $ext == "wma" || $ext == "wav"){

//get file content
$fp = fopen($tmpName, 'r');
$content = fread($fp, filesize($tmpName));
$content = addslashes($content);
fclose($fp);

if(!get_magic_quotes_gpc())
{
$fileName = addslashes($fileName);

}

//query to retrieve user's id
$userid = mysql_query("select userID from user where username = '$username'");
//to get id by username
$row = mysql_fetch_assoc($userid);
$userid = $row['userID'];

$query = "INSERT INTO tracks (trackName, userID, tag, price, file, fileName, fileSize, fileType)
VALUES ('$tname','$userid','$tag','$price','$content','$fileName','$fileSize' , '$fileType)";

mysql_query($query) or die (mysql_error());

when i send it i get this error: Unknown column 'application' in 'field list' i did set data type for the fileType field to varchar. when i remove the fileType all together the record is inserted successfully into database though. ?!! can anyone help please

Uploading Media File Script Giving Me Headache... Help!!!

Similar Tutorials

View Content

Hi phpfreaks, please I have being working on a media site for few months now and I have designed everything that needs to be designed but A♏ having problems with my uploading code its not storing the file size in the database, I have tried and tried and all what have being doing seem to be taking me away from the right way with my little understanding of php. Here is the code that is giving me headache

,
<?php //include("includes/sess.php"); ?>
<?php
$upload="active";
include("includes/mheader.php"); ?>
<?php
if(isset($_POST['Upload'])) {
//////////////////////////////////
//$id=$_POST['id'];
$picture=$_POST['picture'];
$artiste=$_POST['artiste'];
$title=$_POST['title'];
$genre=$_POST['genre'];
$uname=$_POST['uname'];

if($title=="")
{
$message="unknown Title";
header("location:upload.php?message=$message");
exit();
}

if($genre=="")
{
$message="unknown Type";
header("location:upload.php?message=$message");
exit();
}

/*if($nfile=="")
{
$message="file not found";
header("location:upload.php?message=$message");
exit();
} */

if($uname=="")
{
$message="error you";
header("location:upload.php?message=$message");
exit();
}

if($artiste=="")
{
$message="Artiste ?";
header("location:upload.php?message=$message");
exit();
}

header("location:upload.php?message=$message");

//////////////////////////////////
$size=$_FILES["picture"]["size"];
$file_size1 = $size/1024 ;
$file_size = $file_size1/1000 ;
function UploadOne($fname)
{
$uploaddir = 'music/NaijaMp3_';
if (is_uploaded_file($fname['tmp_name']))
{
$filname = basename($fname['name']);
$uploadfile = $uploaddir . basename($fname['name']);
if (move_uploaded_file ($fname['tmp_name'], $uploadfile))
$res = "File " . $filname . " was successfully uploaded and stored. ";
else
$res = "Could not move ".$fname['tmp_name']." to ".$uploadfile." ";
}
else
$res = "File ".$fname['name']." failed to upload.";
return ($res);
}
?>
<?php
if ($_FILES['picture']['name'] != "")
{
$res = UploadOne($_FILES['picture']);
$filname = $_FILES['picture']['name'];
$filname=addslashes($filname);
/////////////////////////////////////////////////////////////
$alt_file_name = "NaijaMp3_" .$filname ;

$date_created=date("Y-m-d h:i:A");
include("includes/db_connect.php");
$sql="INSERT INTO upmp3(uname,file_name,alt_file_name,file_size,artiste,title,genre,date_created)
VALUES('$uname','$filname','$alt_file_name','$file_size','$artiste','$title','$genre','$date_created')";
mysql_query($sql) or die (mysql_error());
$message="Upload Sucessful";
/////////////////////////////////////////////////////////////

echo ($res);
}
}
?>

<div class="main_but">

</div>

</div>


</div>
<div class="login">
</div>
<div id="feature">
<blockquote/>
<div align="center">UPLOAD FILE </div>
<form action="upload.php" method="post" enctype="multipart/form-data" name="form1" id="form1">

 


{Note: All * fields are Mandatory} 

<label>
<input name="picture" type="file" id="picture" />
</label>

File Type
<label>
<select name="type" id="type">
<option value="mp3">mp3</option>
</select>
</label>

Artiste*(e.g Alashine)
<label>
<input name="artiste" type="text" id="artiste" />
</label>
Title

<label>
<input name="title" type="text" id="title" />
</label>
Genre
<label><input name="genre" type="text" id="genre" />(Genre e.g Hiphop, RnB, Reggae . . .)</label>
<input type='hidden' name='id' value='<?php echo"$id" ?>' id='id'/>
<input type='hidden' name='uname' value='<?php echo"$uname" ?>' id='uname'/>
<label></label>




<label>
<input name="Upload" type="submit" id="Upload" value="Upload Mp3" />
</label>

</form>
</div>
</div>
<?php include("includes/footer.php"); ?>
</div>

Thanks for your help in anticipation

Only Display If Date Is After Current Date (date: Yyyy - Mm - Dd)

Similar Tutorials

View Content

Hey,

I'm using a script which allows you to click on a calendar to select the date to submit to the database.

The date is submitted like this: 2014-02-08

Is there a really simple way to prevent rows showing if the date is in the past?

Something like this:
if($currentdate < 2014-02-08 || $currentdate == 2014-02-08) {

}

Thanks very much,
Jack

How To Get A Date From A Blog Post To Read Full Month, Date, And Year?

Similar Tutorials

View Content

Hello. I'm new to pHp and I would like to know how to get my $date_posted to read as March 12, 2012, instead of 2012-12-03.
Here is the code:
Code: [Select]
<?php

$sql = " SELECT id, title, date_posted, summary FROM blog_posts ORDER BY date_posted ASC LIMIT 10 ";

$result = mysql_query($sql);

while($row = mysql_fetch_assoc($result)) {
$id = $row['id'];
$title = $row['title'];
$date_posted = $row['date_posted'];
$summary = $row['summary'];

echo "<h3>$title</h3>\n";
echo "$date_posted\n";
echo "$summary\n";
echo "<a href=\"post.php?id=$id\" title=\"Read More\">Read More...</a>\n";
}

?>
I have tried the date() function but it always updates with the current time & date so I'm a little confused on how I get this to work.

Convert Form Inputs For Date Into A Mysql Date Format

Similar Tutorials

View Content

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.

Datetime, My Code Is Returning The Wrong Date..?$mysqldate = Date( 'y-m-d H:i:s

Similar Tutorials

View Content

Alright, I have a Datetime field in my database which I'm trying to store information in. Here is my code to get my Datetime, however it's returning to me the wrong date. It's returning:
1969-12-31 19:00:00

$mysqldate = date( 'Y-m-d H:i:s', $phpdate );
$phpdate = strtotime( $mysqldate );
echo $mysqldate;

Is there something wrong with it?

Work Out If Current Date (today) Is A Week Before A Given Date

Similar Tutorials

View Content

(continuing from topic title)
So if I set a date of July 7 2011 into my script, hard coded in, I would like the current date to be checked against the hard coded date, and return true if the current date is within a week leading up to the hard coded date.

How could I go about doing this easily?

I've been researching dates in php but I can't seem to work out the best way to achieve what I'm after.

Cheers
Denno

Display Number Of Days Between A Date And Today's Date

Similar Tutorials

View Content

Hi,

I have a job listing website which displays the closing date of applications using:

$expired_date

(This displays a date such as 31st December 2019)

I am trying to show a countdown/number of days left until the closing date.

I have put this together, but I can't get it to show the number of days.

                    <?php 
                    $expired_date = get_post_meta( $post->ID, '_job_expires', true );
                    $hide_expiration = get_post_meta( $post->ID, '_hide_expiration', true );
                    if(empty($hide_expiration )) {
                        if(!empty($expired_date)) { ?>
                                <span><?php echo date_i18n( get_option( 'date_format' ), strtotime( get_post_meta( $post->ID, '_job_expires', true ) ) ) ?></span>
                    
                    <?php
                                        $datetime1 = new DateTime($expired_date);
                                        $datetime2 = date('d');
                                        $interval = $datetime1->diff($datetime2);
                                        echo $interval->d;

                     ?>
                        <?php }
                    } 
                    ?>

Can anyone help me with what I have wrong?

Many thanks

Convert A Date String Into Numeric Date

Similar Tutorials

View Content

Hi,

I am trying to convert a String date into numeric date using PHP function's, but haven't found such function.
Had a look at date(), strtotime(), getdate();

e.g. Apr 1 2011 -> 04-01-2011

Could someone please shed some light on this?

Regards,
Abhishek

Formatting Timestamp As Uk Date Gives Today's Date Only

Similar Tutorials

View Content

Hi guys, I'm putting together a small event system where I want the user to add his own date and time into a textfield (I'll probably make this a series of drop-downs/a date picker later).
This is then stored as a timestamp - "0000-00-00 00:00:00" which displays fine until I try to echo it out as a UK date in this format - jS F Y, which just gives today's date but not the inputted date.

Here's the code I have right now:

Code: [Select]
$result = mysql_query("SELECT * FROM stuff.events ORDER BY eventdate ASC");

echo " ";
echo mysql_result($result, $i, 'eventvenue');
echo ", ";

$dt = new DateTime($eventdate);

echo $dt->format("jS F Y");

In my mysql table eventdate is set up as follows:

field - eventdate
type - timestamp
length/values - blank
default - current_timestamp
collation - blank
attributes - on update CURRENT_TIMESTAMP
null - blank
auto_increment - blank

Any help as to why this could be happening would be much appreciated, thanks.

Issue In Count Date From Date Range

Similar Tutorials

View Content

Compare Current Date With The Date In Database

Similar Tutorials

View Content

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]";
}
?>

Change A Date To A Different Date Based On Timezone..

Similar Tutorials

View Content

Hi Guys..

How can I change a date on the fly ?
Everything is UTC on my server.

How can I change a date to something else on the fly?

Ie:

$timezone = "cet";
$datetime = "2011-09-04 19:53:00";

echo $datetime($timezone);

So I can give it a datetime and have it echo the datetime as if it were in the other timezone?

Thanks
Graham

Filter Date To Show Dates After A Set Date

Similar Tutorials

View Content

i have a table that shows payments made but want to the payments only showing from a set date(06/12/14) and before this date i dont want to show this is my sql that doesnt seem to work and is showing dates before the specified date. .

"SELECT * FROM payments2014, signup2014, editprop2014 WHERE signup2014.userid = payments2014.payment_userid AND editprop2014.prop_id = signup2014.prop_id AND signup2014.userid !='page1' AND signup2014.userid !='page6' AND signup2014.userid !='page4' AND payments2014.payment_transaction_status !='none' AND payments2014.payment_transaction_status !='CANCELLEDa' AND payments2014.payment_type !='deposit' AND payments2014.payment_paid_timestamp NOT LIKE '%2012%' AND payments2014.payment_paid_timestamp NOT LIKE '%2011%' AND payments2014.payment_paid_timestamp >= '06/12/14' ORDER BY payments2014.payment_id DESC"

i have some other parts in the statment but this one that should be filtering is

host_payments2014.payment_paid_timestamp >= '06/12/14'

thanks in advance

Need Help With Warning: Date() [function.date]: In Blocked.php

Similar Tutorials

View Content

I'm getting this Time Zone error.
Perhaps it's a compatibility issue with PHP 5.3. Looked all over for an answer without finding one.
Here is the error message

Warning: date() [function.date]: It is not safe to rely on the system's timezone settings.
You are *required* to use the date.timezone setting or the date_default_timezone_set() function.
In case you used any of those methods and you are still getting this warning,
you most likely misspelled the timezone identifier. We selected 'America/New_York' for 'EST/-5.0/no DST'
instead in /blocked.php on line 41
12/02/12

Here is the code. Line 41 is near the bottom, the one with the d,m,y. Perhaps the echo date (d/m/y") needs to be changed. Appreciate any help!

Code: [Select]
<table border="3" width="16%" align="center" cellspacing="0" bgcolor="#FF6600" bordercolor="red" bordercolordark="red" bordercolorlight="red">
<tr>
<td width="176">

<?php // shows IP Number on Page
echo $ip; ?> 

</td>
</tr>
</table>
<?php // Show the user agent
echo 'Your user agent is: '.$_SERVER['HTTP_USER_AGENT'].' ';?>
[b]<h1 align="center"><?php echo date("d/m/y");?></h1>[/b]
</td>
</tr>
</table
[,code]