Skip to content

Instantly share code, notes, and snippets.

@yesnik
yesnik / active_record.md
Last active November 1, 2024 14:49
Yii 1 Framework Cookbook

CActiveRecord methods

findAll()

Sort records

// Ascending order
Partner::model()->findAll(array('order' => 'company'));
@dastagirkhan
dastagirkhan / gist:00a6f6e32425e0944241
Last active January 7, 2023 09:58
Major cities in India with latitudes and longitudes (coordinates) JSON
[{"name":"Mumbai","state":"Maharashtra","lat":"18.975","lon":"72.825833"},{"name":"Delhi","state":"Delhi","lat":"28.666667","lon":"77.216667"},{"name":"Bangalore","state":"Karnataka","lat":"12.983333","lon":"77.583333"},{"name":"Hyderabad","state":"Telangana","lat":"17.375278","lon":"78.474444"},{"name":"Ahmedabad","state":"Gujarat","lat":"23.033333","lon":"72.616667"},{"name":"Chennai","state":"Tamil Nadu","lat":"13.083333","lon":"80.283333"},{"name":"Kolkata","state":"West Bengal","lat":"22.569722","lon":"88.369722"},{"name":"Surat","state":"Gujarat","lat":"20.966667","lon":"72.9"},{"name":"Pune","state":"Maharashtra","lat":"18.533333","lon":"73.866667"},{"name":"Jaipur","state":"Rajasthan","lat":"24.583333","lon":"86.85"},{"name":"Lucknow","state":"Uttar Pradesh","lat":"26.85","lon":"80.916667"},{"name":"Kanpur","state":"Uttar Pradesh","lat":"26.466667","lon":"80.35"},{"name":"Nagpur","state":"Maharashtra","lat":"23.3","lon":"82.3"},{"name":"Indore","state":"Madhya Pradesh","lat":"22.716667","lon":"75.8333