This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
<?php | |
// http://localhost/iglesia-bb/public/persona/index/123 | |
// http://localhost/iglesia-bb/public/persona/index/123/enlacee- | |
'router' => array( | |
'routes' => array( | |
'Persona' => array( | |
'type' => 'Literal', | |
'options' => array( | |
'route' => '/persona', |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
.ico-detail-see-more { | |
-webkit-transform: rotate(270deg); | |
-ms-transform: rotate(270deg); | |
-o-transform: rotate(270deg); | |
transform: rotate(270deg); | |
top: 3px; | |
font-size: 18px; | |
} |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
SEARCHS TABLE | |
------ | |
0. id_search | |
1. id_user (users.id_user) | |
2. username (users.username_user) | |
2. name (profiles.name_profile + profiles.lastname_profile) | |
3. description (profiles.services_profile) | |
4. gender_profile (profiles.gender_profile) | |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
USE asistemas; | |
DROP TRIGGER IF EXISTS MiTrigger; | |
DELIMITER | | |
CREATE TRIGGER MiTrigger AFTER INSERT ON asistemas.users | |
FOR EACH ROW | |
BEGIN | |
INSERT INTO asistemas.oauth_users (username, password, first_name, last_name) |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
# TABLE | |
DROP TABLE IF EXISTS `searchs`; | |
CREATE TABLE `searchs` ( | |
`id_search` int(11) NOT NULL AUTO_INCREMENT, | |
`username_user` varchar(45) DEFAULT NULL, | |
`name` varchar(255) DEFAULT NULL, | |
`services_profile` text, | |
`gender_profile` varchar(1) DEFAULT NULL, | |
`id_user` int(11) NOT NULL, | |
PRIMARY KEY (`id_search`,`id_user`), |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
<?php | |
$text = '*'.$text.'*'; | |
// subquery | |
$sql = new Sql($this->dbAdapter); | |
$mainSelect = $sql->select()->from('searchs'); | |
$subQry = $sql->select() | |
->from('searchs') |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
<?php | |
$text = '*'.$textParam.'*'; | |
$id_district = (int) $district; | |
// subquery | |
$adapter = $this->table->getAdapter(); | |
$sql = new Sql($adapter); | |
$mainSelect = $sql->select()->from('searchs'); | |
$mainSelect->columns( | |
array( | |
'id_search', |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
setTimeout(function(){ | |
$.mobile.loading('show'); | |
},100); | |
$( "header" ).fadeOut( 1, function() { | |
setTimeout(function(){ | |
$( "header" ).fadeIn(); | |
$.mobile.loading('hide'); | |
},2000); | |
}); |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
$str = 'https://www.google.com'; | |
$str = preg_replace('#^https?://#', '', $str); | |
$str = preg_replace('#\/#', '', $str); | |
echo $str; |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
<?php | |
$urlImage = urldecode($urlImage); | |
$arrayImage = explode(_url_, $urlImage); | |
$pathImage = $arrayImage[1]; | |
if (strpos($pathImage, '/',0) >= 0 ) { | |
$pathImage = substr($pathImage, 1,(strlen($pathImage))); | |
} | |