omarsdali
Jan 8 2008, 12:03 AM
| | Hi,
I am creating a website in php and using a mysql database to store the data. I want to store time data in the database. My question is what is the best datatype I should use and how do I read the time from the database and format(display) it using php ? |
Reply
sonesay
Jan 8 2008, 01:34 AM
The best datatype to use for each field would depend on what kind of data you intend to store. You will have to get fimilar with these datatypes before you begin to use it or you may end up with the wrong ones. I'm not sure what your asking on the last question. Do you want to know how to display the data in your database? You mention time in there do you mean time from the database? I'm not sure mysql stores time.
Reply
jlhaslip
Jan 8 2008, 02:03 AM
SQL code for adding Table to the Database: SQL CREATE TABLE users (
user_id MEDIUMINT UNSIGNED NOT NULL AUTO_INCREMENT,
first_name VARCHAR(15) NOT NULL,
last_name VARCHAR(30) NOT NULL,
email VARCHAR(40) NOT NULL,
password CHAR(40) NOT NULL,
registration_date DATETIME NOT NULL,
PRIMARY KEY (user_id)
);
#INSERT INTO users (first_name, last_name, email, password, registration_date) VALUES ('Larry', 'Ullman', 'phpmysql2@DMCInsights.com', SHA('password'), NOW()); php code for MySql: SQL $query = "SELECT CONCAT(last_name, ', ', first_name) AS name, DATE_FORMAT(registration_date, '%M %d, %Y') AS dr FROM users ORDER BY registration_date ASC"; php code for printing the Results of the above query: HTML while ($row = mysql_fetch_array($result, MYSQL_ASSOC)) {
echo '<tr><td align="left">' . $row['name'] . '</td><td align="left">' . $row['dr'] . '</td></tr>
';
} So, the DB Table has a field that is "DATETIME", that is added to the DB using the NOW(), that uses "DATE_FORMAT(registration_date, '%M %d, %Y')" in the Query, and prints it out via php as an Associative Array string... try it. *code snippets from a Book on Php and MySql by author Larry Ullman, PHP and MySql For Dynamic Web Sites*
Reply
shadowx
Jan 8 2008, 05:18 PM
jlhaslip covered good code there so take a look at that. Also google Tizag and maybe "php mysql tutorial" alongside it and you should find an excellent website for PHP and SQL tutorials which is where i learned all i know today. as for datatypes. Im a lazy person when it comes to DB's, unless you're going to be using functions like comparing two numbers to find the highest, or incrementing a number, or comparing dates you dont need to worry too much about data types (IMHO) So you can store a number in a TEXT field and it wont make any difference. Unless you ask the DB to compare the numbers to see which is higher etc.. then you have problems. Also with numbers in Ms access you couldnt start a number with 0 for some reason.. i dont know if this is true in MYSQl but if it is then numbers like phone numbers should always be in a TEXT field, otherwise you hit errors. As for text i just stick it into a TEXT field, it makes sense, i dont know the reason for all tghe other data types like blob and such.. they just seem useless when i have text, char and integer types. I guess its for validation but its better to validate with PHP and JS (or whatever language you're using) rather than passing it to the DB then handling the error it gives without showing the user a messy error message and then going back to the PHP page to get them to change it. Its just a waste of time and BW if you have a big site.
Reply
gogoily
Jan 10 2008, 01:58 AM
I prefer "DateTime" type It stores data in form of "YYYY-MM-DD HH:mm:ss"
Reply
iGuest
Jun 2 2008, 01:50 PM
Importing excel to mysql by using php coading without using csv it is possible?
Mysql + Php Question
Hi, I am working in php from 3 months, I am new with php so I trying to convert excelsheet data into mysql without using csv. I am lot of trying but I cant solution. I tried to converting excel sheet into csv and then by using coding importing it through coding. But in excel shee in address and products column there is lots of commas is assign. So it can break from that and put it into next field into database. To avoid this situation is reticules because my excel sheet contain around 40,000 rows so I can not possible to modify csv file. Please guide me and tell me direct importing method excel to mysql to solve my problem. It urgent. Thanks & Regards Chetan chopkar Excel Informatics -question by Chetan
Reply
Similar Topics
Keywords : mysql, php
- Mysql
Several files in one field. (2)
Index In A Mysql Database
Make the numbers follow (3) I hope I am on topic here (It does have to do with web design, after all). I have noticed that in a
MySQL database, the 'id' field just keeps its numbers for every record, with the backdraw
that, whenever you remove (a) record(s) from the table, you get your list numbered as eg.
1,5,6,7,12,25 etc. This makes it a bit difficult of keeping track of the number of records in your
table. Is there a way of achieving (either in PHPMyAdmin or through the use of PHP) that the id
field in your table gets sort of 'refreshed and updated' so you have a clearer view....
Accessing Mysql From Javascript
Javascript to communicate with database (4) I found a nice program which allows you to put quizzes on your web site. You can design your own
questions, set the layout of your page, and there is also a possibility of having the results
emailed to you. It further offers a facility to store the results and all that, all you have to do
is put a link in the program, telling it which page takes care of that. However, when I look at the
HTML code the program generates, I see that most of it is written in Javascript. Obviously, it also
uses variable names, but as I don't know any Java, I was wondering if those variab....
Another Question On Mysql Table Data Type
text field for lots of text. (1) In my MySQL table I would like to use one text field which can contain lots of text. What I want to
use it for is for student records, and I want to be able to add to it without destroying what is
already there. I want the field to contain something like: ****03/11/2007**** Chopin prelude No 9:
small problem bars 12-15. Advice given on how to practice. ****10/11/2007**** Problem in Prelude
overcome, piece successfully completed. New piece set: Beethoven Sonata No 1, movement 1. etc. This
is of course just an example, but that is how I want to set up my student records....
Which Data Type To Use In Mysql Table
Using a 5 character number (4) If I wanted to use an ID field which automatically increments when data are addad, but displays the
ID as a 5 figure number, which data type would I have to use? I would want a type that assigns a
number to a record in the format "00001", "00002", etc. However, when I use "int" as datatype, it
only displays th field contents as "1", "2" etc. So, which data type could do the job for me? i do
not need a decimal point or anything, just an id that displays in 5 figures, including the leading
zeros. Thanks in advance.....
Merging Database Php Mysql
(5) Hii i need help margning script. i have coppermine gallery, AzDGDating Site, Noah's
Classifieds they all have user sign-up login. but they have different like i need to have 3 seperate
account for each script is there any way like mergning one user name and password would work for 3
section. if you don't get my question please tell me i will try to explain more in detail
thank you for your time and help ....
How Do You Combine Multiple Mysql Databases Into One Database?
(3) How do you combine multiple mysql databases into one database? I was thinking thta soem servers
restrict you to one to five mysql databases. If I have a dynamic part of a table on my site, I
would use one database for that. For every table of dynamic information, I use one database. Can I
streamline what I am doing and combine all of my databases into one? I could make multipple tables
in the same database. Would that work? thanks....
Phpbb And Mysql Relations?
Need forum code for my website (2) Hi if someone could get back to me as fast as they can that would be great! i got a couple of
questions what do you use my sql for what does that have to do with forums? and secondally can
someone give me the php code for the forum thanks /biggrin.gif" style="vertical-align:middle"
emoid=":D" border="0" alt="biggrin.gif" />....
Syndicate Your Content Using Php And Mysql
(0) I just finished reading a php book, and figured out some interesting things, and wanted to share
them with the Trap17 community. I know lot of you make websites so this could help out. Enjoy
QUOTE Introduction So, you've spent the best part of a year creating your PHP/MySQL driven
web site. You've got a fair amount of decent, flexible content, and you're buddies with a
couple of other webmasters, so they've given you a free banner ad on their site in exchange for
one on yours. Promoting your site can be even harder than developing it. I've foun....
Tips On Creating Your Own Search
PHP/MySQL Integrated search on your site (1) I'm not a professional web developer but I've learned a lot since I used Macromedia
Dreamweaver. The latest version 8 supports PHP 5. If you select PHP as your working language, you
can use this software to automatically add dynamic content to your website with MySQL as a
requisite. If you have a MySQL database containing records like a songs information database, then
you might probably not be able to add a good search page to your website which will search records
in the database. I faced the same problem, but now I'm able to create one sophisticated datab....
Php And Mysql Problem
Need a little help (8) hi.. i'm new in php and mysql... here is my problem.... $sql = "SELECT COUNT(*) FROM
messages WHERE _parent={$row }"; after sending the query above i dont know how to fetch the
actual rows counted.. i tried using the mysql_fetch_array() and mysql_fetch_row() function but it
didnt work... actually the only function i know that fetches results from sql queries is
mysql_fetch_array()... so what function or code i need to have the result from the query which uses
COUNT?....
Import From Excel File Into Mysql Database
(7) Has anyone tried using the excel import function that comes with phpmyadmin
http://www.phpmyadmin.net/home_page/ - it does not require any additional plug-ins or scripts and
is fairly straightforward to use. In phpmyadmin, if you click on the database table which you wish
to import the data to , there is a link on the bottom left corner which says "insert data from a
text file into the table" - although it says text file it still can be used to import an excel file.
When you click on this link you will be taken to a page where you will be asked for the file name
(the....
Mysql Host Adress
how do i connect (4) helo! hou do you? i need somebody post the data for acces my mysql database from my client.
thanks a lot! also i need the alter code for add a foreign key to a column on a table, thanks a
lot /blink.gif' border='0' style='vertical-align:middle' alt='blink.gif' /> Moved to the
appropriate section. Don't put questions in the tutorial section please. ....
What If You Forget Mysql Root Password
(2) If you have set a root password, but forgot what it was, you can set a new password with the
following procedure: 1. Take down the mysqld server by sending a kill (not kill-9) to the mysqld
server. The pid is stored in a `.pid' file, which is normally in the MySQL database directory:
shell> kill `cat /mysql-data-directory/hostname.pid` You must be either the Unix root user or the
same user mysqld runs as to do this. 2. Restart mysqld with the --skip-grant-tables option. 3. Set
a new password with the mysqladmin password command: shell> mysqladmin -u root password &....
Mysql And Ms Access
(1) Can MS Access interface with mySQL? Does anyone know how to set it up? Is it even a good idea to?....
Mysql Tool
(0) What are the best Open Source MySql developer tools?....
Mysql Infos
(2) hello... what are the infos for the mysql databases ? Like the host, is it localhost ? and the
username ? And what does setting up users for the databases in cpanel does ? thanks in advance....
Php Tutorial - Basics...up To Mysql/file Commands
(1) the best way to start php is probably not adjusting a script IMO - that misses out a stage. - the
very first stage - here... Why use php? because it allows things to be generated very quickly -
without lots of html pages. It enables users you choose to allow, to input their own content to the
pages you want them to. 1) save these files as anyfilename.php - pick your names, upload them to a
php enabled server and go to the url they are at... 2) understand , .php, //////, /* */, and ;
Code: ?> THis tells the web browser when to expect php coding. So... wh....
Mysql Help
Oh please help a poor little girl... (8) Hello....I am crap at making websites and I don't even know how to use MySql. I don't even
know what it means.OK FIRST OF ALL DON'T GIVE ME SOME WEBSITE TO GO TO because I WONT. Anyways
the problem is well this is a page of my banner rotation websites
http://bexchange.bexa.trap17.com/member.php and well why does it say 0: bexa_mysql ??? WTF does it
mean ? I aint got a clue and hopefully all you computer genius' out there can help me. If you
can't don't worry I will just pray to god for it to hopefully change it self the next time I
go on it. ....
Looking for mysql, php
|
|
Searching Video's for mysql, php
|
advertisement
|
|
Jul 25, 2008
