Learn VBA & Macros in 1 Week!

PHP - Dates Headache :-(

Full Excel VBA Course - Beginner to Expert

Dates Headache :-(	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

Full Excel VBA Course - Beginner to Expert

Similar Tutorials

Subtracting Dates With Dates Stored As Datetime In Mysql?

Php Highlight Dates Between Two Dates On Calender

Cookie Headache

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

Prepared Statements Headache

Learning Php, Java Dev With A Headache.

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

Unknown Column In 'field List' Error Is A Headache

Var Between Dates -help

Help With Php Dates

Getting Dates Using Strtotime Or Other If Possible.

Getting Dates From Database

Php W/mysql (dates)

Php/mysql Dates

Learn VBA & Macros for Excel in 1 Week!

Subtracting Dates With Dates Stored As Datetime In Mysql?

Similar Tutorials

Hi All,

I need to subtract dates and display the number of days left. I have a 'Start' date and an 'End' date in DATETIME format in the DB. Not quite sure where to start. A simply start - end doesn't work .

Start = 2011-11-01-00:00:00
End = 2011-11-30-23:59:59

Since it is now 2011-11-27, my output should equal 3. Any help is appreciated.

Php Highlight Dates Between Two Dates On Calender

Similar Tutorials

Hi guys,

I am trying to do a multidates events availability calender. The script below indicates todays date by highlighting an orange colour and also indicates the start and end date of the event highlighting grey colour on the two dates (The colour are link via css classes as shown).
Code: [Select]
//Today's date
$todaysDate = date("d/m/Y");
$dateToCompare = $daystring . '/' . $monthstring . '/' . $year;
echo "<td align='center' ";
if($todaysDate == $dateToCompare){
echo "class='today'";
}else{
//Compare's the event dates
$sqlcount = "select event_start,event_end from b_calender where event_start ='".$dateToCompare."' AND event_end='".$dateToCompare."'";
$noOfEvent = mysql_num_rows(mysql_query($sqlcount));
if($noOfEvent >= 1){
echo "class='event'";
}
}
It works ok i.e. if start date = 01/01/2012 and end date = 04/01/2012 both date will be highlighted with grey colour. However I want it to also highlight grey on the dates between the 1st and 4th to show that then anydates between the 1st and 4th are not available and this is when I'm stuck.

Please guys I need help.

Thanks

Cookie Headache

Similar Tutorials

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

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

Similar Tutorials

Hi All,

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

I.e. int the text:

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

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

Date Headache.

Similar Tutorials

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.

Prepared Statements Headache

Similar Tutorials

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."<br>";

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

Learning Php, Java Dev With A Headache.

Similar Tutorials

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 ??

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

Similar Tutorials

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.<br>";
else
$res = "Could not move ".$fname['tmp_name']." to ".$uploadfile."<br>";
}
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"><em><strong>UPLOAD FILE </strong></em></div>
<form action="upload.php" method="post" enctype="multipart/form-data" name="form1" id="form1">
<p>
<br />

</p>
<p>{Note: All * fields are Mandatory} </p>
<p>
<label>
<input name="picture" type="file" id="picture" />
</label>
</p>
<p>File Type
<label>
<select name="type" id="type">
<option value="mp3">mp3</option>
</select>
</label>
</p>
<p>Artiste*<span class="style1"><sub>(e.g Alashine)</sub></span>
<label>
<input name="artiste" type="text" id="artiste" />
</label>
Title

<label>
<input name="title" type="text" id="title" /><span class="style1">
</label>
<p>Genre
<label><input name="genre" type="text" id="genre" />(Genre e.g Hiphop, RnB, Reggae . . .)</span></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>
</p>

</p>
<p>
<label>
<input name="Upload" type="submit" id="Upload" value="Upload Mp3" />
</label>
</p>
</form>
</div>
</div>
<?php include("includes/footer.php"); ?>
</div>

Thanks for your help in anticipation

Unknown Column In 'field List' Error Is A Headache

Similar Tutorials

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

Var Between Dates -help

Similar Tutorials

i want to created a case like the following need help with the syntax:
Code: [Select]
switch (true)
{
case($fromdate-$todate==17-04-2001-25-04-2011):
echo $finalprice = $result;
break;
}

Dates

Similar Tutorials

Hi guys,

I am trying to create a program which manages campaigns.
each campaign has a start date and and end date.
a user has to enter data releated to the campaign everyday

example
start date: 10-1-2011
end date: 17-1-2011

now all this information is stored in 2 tables
1st table is "campaigns" this stores the campaign name, start date and end date
and 2nd table is "campaign_data" this table stored the data for each campaign and also date of when that data was entered

my question is, if the user did not enter data on 11-1-2011 how will I know this, keeping in mind the month diffrence which can accur if the length of the campign was 2 month long?

table:
campaigns
fields:
id | campaign_name | start_date | end_date

table:
campaign_data
fields:
id | campaign_id | date | page

Thank you

Help With Php Dates

Similar Tutorials

Hey guys,

What I'm trying to do is set 2 dates. Today's date and then a date 14 days from now. However, I want it to increase the month if by adding 14 days will bring me to the next month, same with the year.

I have this, but it doesn't increment the month or year.

$week = mktime(11, 59, 59, date("m"), date("d")+14, date("y"));
$date = date("Y-m-d H:i:s", $week);

Dates?

Similar Tutorials

Hey, I have just recently coded a forum and my topics are ordered by date. This means if there is a topic at 4pm and then there is another topic made at 4:01pm the topic which was posted at 4:01pm will be listed at the top.

I know how to add timezones but there is bit of a problem, if person from the UK posts a topic and his/hers timezone is set to:

date_default_timezone_set('Europe/London');()

this means the time at which the topic was posted will be 20:36pm (Just a randome time example).

However if someone posted a topic from america/los_angeles one hour before the one above his/her time will be 11:36 am. Even though this topic was posted one hour before the UK post. The UK topic will override it because it is 8:36pm. In fact, all UK topics will show up at the top and all the america/los_angeles topics will show bellow.

How do I slove this problem? I just don't get it even tough I looked online.

Please help, thanks.

Php Dates

Similar Tutorials

Php Dates

Similar Tutorials

Hi,
So I only want my users to be able to perform certain tasks each 12 hours.
This is the code I use:
Code: [Select]
function canVote($ip, $vote_id, $updateTimer = true){
$time = date("Y-m-d H:i:s");

$this->CI->db->where('vote_id', $vote_id);
$this->CI->db->where('user_ip', $ip);
$this->CI->db->from('votes_voters');
$count = $this->CI->db->count_all_results();
/*$count = $this->CI->db
->where('vote_id =', $vote_id)
->where('user_ip =', $ip)
->from('votes_voters')
-count_all_results();*/

$row = $this->CI->db
->where('vote_id =', $vote_id)
->where('user_ip =', $ip)
->get('votes_voters')
->row();

if($count == 0){
$data = array(
'vote_id' => $vote_id,
'user_ip' => $ip,
'last_vote' => $time
);

$this->CI->db->insert('votes_voters', $data);
return true;
}
else{
$last_vote = $row->last_vote;
if($last_vote + strtotime("12 hours") < $time){
return false;
}
else{
if($updateTimer = true){
$data = array(
'last_vote' => $time,
);

$this->CI->db->where('vote_id', $vote_id);
$this->CI->db->where('user_ip', $ip);
$this->CI->db->update('votes_voters', $data);
}
return true;
}
}
}
Apparently the failing bit is this:
Code: [Select]
if($last_vote + strtotime("12 hours") < $time){
return false;
}
I believe you can guess what I'm trying to do here, if variable 1 + 12 hours is smaller than variable 2, then return false.
Any help is much appreciated.

Pre 1901 Dates

Similar Tutorials

Been a while since I hit a snag but have a new one!

I have hit the old problem that I need to be able to input dates pre 13th December 1901 which appears to not work when using strtotime
<?php echo date("F j, Y ", strtotime($row_seasonview['season_start'])); ?>

Following a bit of googling it seemed that the alternative was to set the format in the query
Code: [Select]
SELECT *,
DATE_FORMAT(`season_start`,'%D %M %Y') AS startdate,
DATE_FORMAT(`season_end`,'%D %M %Y') AS enddate
FROM seasons
WHERE season_id = %sand to call the date from that
<?php echo $row_seasonview['startdate']; ?>
but this just comes back with 'Query was empty'. If I remove the two DATE_FORMAT lines the query runs fine.

I know there must be a way round this but cannot fathom it out. Any suggestions would be greatfully welcomed!!!

Thanks in advance
Steve

Getting Dates Using Strtotime Or Other If Possible.

Similar Tutorials

so i have a basic html table and down the left column i have monday,tuesday,wednesday.... sunday.

In the column 2nd from the left, i want to fill it with the current weeks dates, which is really based on the current date. So if today is Jul 29th Friday, then strtotime("last monday") would give me Jul 26th Monday... my issue is "last monday" wont work if today is monday because that will give me 19th of july... and since I technically dont know what day is today i'm not sure how to cleanly work around this without having to use some if statement... if today is monday do "last monday +7 days" or just do "now" etc...

Thanks!

Getting Dates From Database

Similar Tutorials

Hi,

I'm trying to get the date, using this code

<?php
include('config.php');
$today = date('Y-m-d 00:00:00');
$nineyesterday = date('Y-m-d H:i:s', mktime(date("H") - (date("H") + 6), date("i") - date("i"), date("s") - date("s"), date("m") , date("d"), date("Y")));
$now = date('Y-m-d H:i:s');
$nineam = date('Y-m-d 9:00:00');
$ninepm = date('Y-m-d 18:00:00');

if ((strtotime($now) >= strtotime($today)) &&  (strtotime($now) <= strtotime($nineam)))
{
//count the answers by yes or no
$q = "SELECT opt, count(opt) FROM plus_poll_ans WHERE date<='".$nineyesterday."' AND date>='".$nineam."' GROUP BY opt desc ";
}
elseif ((strtotime($now) >= strtotime($nineam)) &&  (strtotime($now) <= strtotime($ninepm)))
{
//count the answers by yes or no
$q = "SELECT opt, count(opt) FROM plus_poll_ans WHERE date<'".$nineam."' AND date>='".$ninepm."' GROUP BY opt desc ";
}
$q = mysql_query($q) or die(mysql_error());

//separate the results
while($row = mysql_fetch_array($q))
{
$total_opt[] = $row['count(opt)'];
}

mysql_freeresult($q);

$yes = intval($total_opt[0]);
$no = intval($total_opt[1]);

$total = $yes + $no;
        echo $total."<br/>";
        echo $yes."<br/>";
        echo $no."<br/>";
?>

but it didn't work, why isn't it working?

Thanks

Php W/mysql (dates)

Similar Tutorials

Code: [Select]
<?php
$date = date('Y-m-d');
$strtime = strtotime('today +14 days');
$strtime = date('Y-m-d', $strtime);
if ($distributor != 1) {
$select = "SELECT deal_data.headline AS headline FROM deal_data
WHERE str_to_date(deal_data.end_date,'%Y/%m/%d') BETWEEN str_to_date('" . $date . "', '%Y/%m/%d') and str_to_date('" . $strtime . "', '%Y/%m/%d')";
}else {
$select = "SELECT deal_data.headline AS headline FROM deal_data
WHERE str_to_date(deal_data.end_date,'%d.%m.%Y') BETWEEN '" . $date . "' and '" . $strtime . "'";
}
?>
The dates are formatted in the database as Varchar (I don't do that anymore, this is an old project) and are formatted as: "09/12/2010".

Anything wrong with the above code that would make it not work and return queries?

Php/mysql Dates

Similar Tutorials

I was just wondering if anyone can reccomend the best way to get dates from a database and turn them into dates you can display. For example if you have a date stored such as 23/08/10, is there an easy way to turn this into 23rd August 2010? Thanks for any help.