voip03
Members-
Posts
693 -
Joined
-
Last visited
Everything posted by voip03
-
try $_GET $password =md5($_GET['password']);
-
try this Password - e99a18c428cb38d5f260853678922e03
-
How many type of PayPal check out s solutions avaible.
-
<? if($earns >5 ) { echo "request money"; } else { echo "you can't request money";} ?>
-
<? $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/>"; } ?>
-
Can you use 'switch structure' instead of if else statement?
-
O sorry miss line 8
-
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"); ?>
-
This is good one http://www.phpfreaks.com/tutorial/basic-pagination
-
what do u mean?
-
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 ....
-
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
-
It 's look ok. just google it ,
-
read this post http://www.phpfreaks.com/forums/index.php?topic=339907.msg1602474#msg1602474
-
phpSensei thank you. I forgot the date format.
-
yes -176
-
change the date to 02/10/11. what is u'r result.
-
phpSensei Thank U http://www.addedbytes.com/lab/ternary-conditionals/
-
please mark as solved. the topic solved button can be found at the bottom left of the page. thank you
-
Are you trying to insert date into mysql? Then you need NOW ().
-
Sort by ASC or DESC http://php.about.com/od/learnmysql/p/SQL_order_by.htm
-
some examples http://php.net/manual/en/function.date.php http://www.w3schools.com/PHP/php_date.asp