I need to modify existing data in a database using PHP. So far it works but only if i modify the data such that it has less characters than it originally did ie i can change ‘trial’ to ‘try’ but not ‘try’ to ‘trial’…any idea why this might happen?
Posts Tagged ‘Database’
When You Design Web Based Database For Ecommerce Website, Do I Need To Take Invoice And Shipping As An Entity?
February 19th, 2010Hi,
I’m designing a database for E-commerce Application.
Do I need to take Invoice and shipping as an entity or not?
I’ve got stuck here.
Thanks in Advance for ur help.
Can I Create Database Driven Website Using Asp.net?
February 10th, 2010Dear Friends,
I want to learn to creat website. Will asp.net or vb.net will be useful to create database driven website with multiuser.
Please help me.
How To Start Developing A Web Database Using Mysql And Php?
February 9th, 2010I want to develop a web database using mysql and i wonder if php would ne the right software to use.And i dont what siftware needed to build this conceptt.I need help………
What Is The Best Place To Learn Php Fast And Quickly To Make A Mysql Database Site?
February 2nd, 2010Books or website, or snippits of code that could be useful. Will be used in a site like facebook and myspace.
For Commercial Multimedia Portal With Database Joomla Or Drupal?
February 1st, 2010for an east Asian language commercial multimedia portal with database. there’ll be only single webmaster, who has no prior experience in portal management.
so it should be easy and result oriented.
How To Create Links From Database Records Using Php?
February 1st, 2010I wanted to implement something that is in the basic form of PHP forums. Assume a table has two records: topic and body. I want my code to display topics as links, so whenever I click at one of them my code will display the contents of the body. How can I do that? Thanks
How To Insert The Current Date And Time Into A Php Mysql Database?
January 31st, 2010I’m creating a blog website. When a user submits a new blog, I want the blog to be saved into my PHP database, along with the exact date and time that it was submitted.
For storing the date and time, I have a datetime field that is set to “not null”. I’ve tried leaving that field blank when I’m processing a blog submission:
insert into blogs values ‘$title’, ‘body’, ‘ ‘;
(notice the empty quotation marks)
but, when I do that, the field in the database is filled with zeros: 0000-00-00 00:00:00 . I’m using this field as my primary key, so I can’t have them all filled with 0’s!
How do I get the database to enter the current date and time? I’ve tried changing the field to a timestamp, but that didn’t help.
I’m using PHP 5.
