Skip to content

Instantly share code, notes, and snippets.

CREATE DEFINER=`root`@`localhost` FUNCTION `stripSpeciaChars`(`dirty_string` VARCHAR(2048), `allow_space` TINYINT, `allow_number` TINYINT, `allow_alphabets` TINYINT, `no_trim` TINYINT) RETURNS varchar(2048) CHARSET utf8 BEGIN /** * MySQL function to remove Special characters, Non-ASCII,hidden characters leads to spaces, accents etc * Downloaded from http://DevZone.co.in * @param VARCHAR dirty_string : dirty string as input * @param VARCHAR allow_space : allow spaces between string in output; takes 0-1 as parameter * @param VARCHAR allow_number : allow numbers in output; takes 0-1 as parameter * @param VARCHAR allow_alphabets : allow alphabets in output; takes 0-1 as parameter * @param VARCHAR no_trim : don't trim the output; takes 0-1 as parameter * @return VARCHAR clean_string : clean string as output * * Usage Syntax: stripSpeciaChars(string,allow_space,allow_number,allow_alphabets,no_trim); * Usage SQL> SELECT stripSpeciaChars("sdfa7987*&^&*ÂÃ ÄÅÆÇÈÉÊ sd sdfgËÌÍÎÏÑ ÒÓÔÕÖØÙÚàáâã sdkarkhru",0,0,1
@Bane83
Bane83 / gist:5545c7fe470b5ff98682
Created March 24, 2016 15:39
MySQL strip caracters
CREATE DEFINER=`root`@`localhost` FUNCTION `stripSpeciaChars`(`dirty_string` VARCHAR(2048), `allow_space` TINYINT, `allow_number` TINYINT, `allow_alphabets` TINYINT, `no_trim` TINYINT) RETURNS varchar(2048) CHARSET utf8 BEGIN /** * MySQL function to remove Special characters, Non-ASCII,hidden characters leads to spaces, accents etc * Downloaded from http://DevZone.co.in * @param VARCHAR dirty_string : dirty string as input * @param VARCHAR allow_space : allow spaces between string in output; takes 0-1 as parameter * @param VARCHAR allow_number : allow numbers in output; takes 0-1 as parameter * @param VARCHAR allow_alphabets : allow alphabets in output; takes 0-1 as parameter * @param VARCHAR no_trim : don't trim the output; takes 0-1 as parameter * @return VARCHAR clean_string : clean string as output * * Usage Syntax: stripSpeciaChars(string,allow_space,allow_number,allow_alphabets,no_trim); * Usage SQL> SELECT stripSpeciaChars("sdfa7987*&^&*ÂÃ ÄÅÆÇÈÉÊ sd sdfgËÌÍÎÏÑ ÒÓÔÕÖØÙÚàáâã sdkarkhru",0,0,1
-- phpMyAdmin SQL Dump
-- version 4.5.1
-- http://www.phpmyadmin.net
--
-- Host: 127.0.0.1
-- Generation Time: Jun 30, 2016 at 08:58 AM
-- Server version: 10.1.13-MariaDB
-- PHP Version: 7.0.6
SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
CREATE TABLE `appointment_reminders` (
`id` int(11) NOT NULL,
`appointment_id` int(11) UNSIGNED DEFAULT NULL,
`patient_id` int(11) DEFAULT NULL,
`client_id` int(11) DEFAULT NULL,
`remind_option` varchar(32) NOT NULL,
`remind_before` int(2) DEFAULT NULL,
`date` date DEFAULT NULL,
`dates` text COMMENT 'List of dates for repeat reminders',
`repeat_type` varchar(128) DEFAULT NULL,
-- phpMyAdmin SQL Dump
-- version 4.5.1
-- http://www.phpmyadmin.net
--
-- Host: 127.0.0.1
-- Generation Time: Sep 08, 2016 at 02:29 PM
-- Server version: 10.1.13-MariaDB
-- PHP Version: 7.0.6
SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
id
338685
337927
336978
327321
354494
287324
354473
354224
var map;
var i=0;
var modelData = {};
var PlaceEditView = Backbone.View.extend({
el: $('#content'),
imgs: [],
initialize: function () {
this.render();
newPlace.on('change', this.render, this); //change:profile_img
array(
'id' => '1962',
'name00eng' => 'Test',
'description00eng' => '',
'promotions00eng' => '',
'name00srp' => '',
'description00srp' => '',
'promotions00srp' => '',
'email_to' => '',
'reservation_active' => false,
<?php
/**
* Places API V1
*/
class PlacesV1Controller extends ApiAppController {
var $name = 'PlacesV1';
var $uses = ['Place', 'Tag', 'Member', 'Attach', 'PlaceGroup', 'WorkingHour', 'Category', 'Rating','Repertoire','City','Country'];
var $components = ['Upload'];
http://crimson.conveo.net/en/logInUser
1) Pokusaj logovanja I
$_POST
accountType
token
U koliko ne postoji User sa prosledjenim instagram ID-em (cita se iz tokena koji se prosledjuje), vraca se response: