Skip to content

Tag: mysql

Get mysql table field names in ZF2

I want to store the csv data dynamically into mysql table. According to my csv columns header i want to insert the data into respective columns in mysql table. For this, I need to get all the table fields name from Zend Framework Controller or Model. I have tried with: ** ** But, it shows the error: Fatal err…

Mysql timestamps and php date()

The mysql timestamp is in a standard format 2013-02-20 02:25:21, when I use date(‘H:i:s’,$date) I get the same invalid output 18:33:33, how can I get the right output? hour:minute:seconds Answer Tip : try with MYSQL DATE_FORMAT function if you want to do it only with PHP then use strtotime

Gettext or database translation

Which is better: gettext custom MySQL+cache based functionality Gettext is a sort of builtin feature, so I assume it’s tweaked for performance. Using poedit is a pain and impossible to show to any client. A custom functionality allows for simple translation interface. But might be heavy on php/db usage.…

Best way to INSERT many values in mysqli?

I’m looking for a SQL-injection-secure technique to insert a lot of rows (ca. 2000) at once with PHP and MySQLi. I have an array with all the values that have to be include. Currently I’m doing that: I tried call_user_func_array(), but it caused a stack overflow. What is a faster method to do this…

Json Parsing and inserting to mysql

I am using the the Mandrill to post any inbound emails. Here is what is posted by Mandrill when i receive a new email -> http://help.mandrill.com/entries/22092308-What-is-the-format-of-inbound-email-webhooks- Also here is what i get in the $_REQUEST (sorry that its not formatted well): [{“event&#8221…

why select option value if zero post empty

I am sorry bad English. I have a select menu option value problem: I am if select value=”0″ option and this post, it retuns the value with no problem. But, when I use value = 0 save mysql table, this value not 0 this return empty. This value saving column type integer? What is problem? I am not us…

php mysql export excel

This code is working without problem if page doesn’t contain any other content. When i add a html form, it gives only html content to excel. I need to use that form to customize query. How can i make this code working with html content? Answer As mentioned in the comments, combining HTML and CSV is not …