Skip to content

Instantly share code, notes, and snippets.

@jesgs

jesgs/create_php_array.sql

Created June 10, 2017 16:28
Show Gist options

  • Select an option

    Learn more about clone URLs
  • Save jesgs/cf99818a67e758d7602a5b24c84f73ce to your computer and use it in GitHub Desktop.

Select an option

Learn more about clone URLs
Save jesgs/cf99818a67e758d7602a5b24c84f73ce to your computer and use it in GitHub Desktop.
Download ZIP
Generate a PHP array from a sql query
Raw
create_php_array.sql
-- I'm lazy so this is what I did
SELECT CONCAT("['id' => ", id, ", 'some_column_string' => '", some_column, "'],") FROM mytable;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment