Jump to content

voip03

Members
  • Posts

    693
  • Joined

  • Last visited

Everything posted by voip03

  1. try $_GET $password =md5($_GET['password']);
  2. try this Password - e99a18c428cb38d5f260853678922e03
  3. How many type of PayPal check out s solutions avaible.
  4. <? if($earns >5 ) { echo "request money"; } else { echo "you can't request money";} ?>
  5. <? $email ="doclhrd@yahoo.com, 1staydcraig@gmail.com, jeeferil99@msn.com,timothyruffner@att.net, BigMarkus1031@frontiernet.net,legs4days77@aol.com, amc52377@gmail.com, josecorte5@yahoo.com,truesoldier_6@hotmail.com, da_devil006@yahoo.com,schilly62@hotmail.com, barnhouseboogie@yahoo.com,stevereece05@yahoo.com, dianasdream0803@hotmail.com"; $emailAddress= explode(",", $email); $total = count($emailAddress); for($i=0; $i< $total; $i++) { echo $emailAddress[$i]; echo "<br/>"; } ?>
  6. Can you use 'switch structure' instead of if else statement?
  7. I am learning Mysql BLOB from http://www.techcubetalk.com/2009/01/tutorial-on-how-to-store-images-in-mysql-blob-field/ And I am getting error when I add ‘img_data’ and $imgContent in the insert statement ‘You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 2’ This is my code. <? require('config.php'); if(isset($_REQUEST[submit]) && $_FILES[imgfile][size] > 0) { $fileName = $_FILES[imgfile][name]; // image file name $tmpName = $_FILES[imgfile][tmp_name]; // name of the temporary stored file name $fileSize = $_FILES[imgfile][size]; // size of the uploaded file $fileType = $_FILES[imgfile][type]; // file type $fp = fopen($tmpName, "r"); // open a file handle of the temporary file $imgContent = fread($fp, filesize($tmpName)); // read the temp file fclose($fp); // close the file handle $sql = "INSERT INTO img_tbl (img_name,img_type,img_size,img_data) VALUES ('$fileName','$fileType','$fileSize','$imgContent')"; $res = mysql_query($sql); if(!$res) { die(" error: <br/>". mysql_error() ); } $imgid = mysql_insert_id(); // autoincrement id of the uploaded entry mysql_close($db); echo "<br>Image successfully uploaded to database<br>"; echo "<a href=/jquery/BLOB/viewimage.php?id=$imgid\>View Image</a>"; } else die("You have not selected any image"); ?>
  8. This is good one http://www.phpfreaks.com/tutorial/basic-pagination
  9. htmlGo to MySQL Reference - 10.5. Data Type Storage Requirements http://dev.mysql.com/doc/refman/5.0/en/storage-requirements. Search for: Storage Requirements for Date and Time Types Dates are internally stored as A three-byte integer packed as DD + MM×32 + YYYY×16×32 But, if you select a date column for display, it has to be shown in some way, so it comes out as 0000-00-00. It is not stored as a char(10) with that specific format. If, for display, you need to see a specific format, you can convert it to VARCHAR in a specific format using Date_Format(). However, bear in mind that if you are using the query in a programming tool, this is not what you want to do. You want the raw date value, for display purposes, there will be a similar formatting function from whatever programming environment you use. As you can see from the reference in DATE_FORMAT, you will want to use '%d-%m-%Y', e.g. SELECT col1, col2, DATE_FORMAT(datecolumn, '%d-%m-%Y') AS datecolumn, more1... FROM sometable ....
  10. The default way to store a date in MySQL is with the type DATE. Below is the proper format of a DATE. •YYYY-MM-DD •Date Range: 1000-01-01 to 9999-12-31 http://www.tizag.com/mysqlTutorial/mysql-date.php
  11. It 's look ok. just google it ,
  12. read this post http://www.phpfreaks.com/forums/index.php?topic=339907.msg1602474#msg1602474
  13. phpSensei thank you. I forgot the date format.
  14. change the date to 02/10/11. what is u'r result.
  15. phpSensei Thank U http://www.addedbytes.com/lab/ternary-conditionals/
  16. please mark as solved. the topic solved button can be found at the bottom left of the page. thank you
  17. Are you trying to insert date into mysql? Then you need NOW ().
  18. Sort by ASC or DESC http://php.about.com/od/learnmysql/p/SQL_order_by.htm
  19. some examples http://php.net/manual/en/function.date.php http://www.w3schools.com/PHP/php_date.asp
×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.