ShaolinF Posted April 7, 2010 Share Posted April 7, 2010 Hi Guys When executing prepared statements, will one need to also bind parameters for datetime columns in the DB or will the system do it automatically? Link to comment https://forums.phpfreaks.com/topic/197930-prepared-statements/ Share on other sites More sharing options...
Mchl Posted April 7, 2010 Share Posted April 7, 2010 If you want to do anything with these columns you generally need to bind parameters to them... Could you give an example of what you're trying to do? Link to comment https://forums.phpfreaks.com/topic/197930-prepared-statements/#findComment-1038627 Share on other sites More sharing options...
ShaolinF Posted April 7, 2010 Author Share Posted April 7, 2010 table below: id auto_increment PRIMARY KEY, product_name varchar(233), product_type varchar(100), product_weight varchar(10), date_posted datetime In the preparedstatment I insert the values for product_*, I dont need to bind a param for ID since its auto. Is the same applicable for the date_posted col (i.e. i dont need to bind a param to it since its automatic)? Link to comment https://forums.phpfreaks.com/topic/197930-prepared-statements/#findComment-1038629 Share on other sites More sharing options...
Mchl Posted April 7, 2010 Share Posted April 7, 2010 DATETIME is not automatic. TIMESTAMP with DEFAULT CURRENT_TIMESTAMP is. (at least in MySQL, you might be using something else though) In such case, you can ommit it in insert statement. And BTW: wouldn't product_weight be better represented by numeric type, such as DECIMAL? Link to comment https://forums.phpfreaks.com/topic/197930-prepared-statements/#findComment-1038641 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.