Skip to content

Instantly share code, notes, and snippets.

View phpfact's full-sized avatar
🎯
Focusing

Sachin Sharma phpfact

🎯
Focusing
View GitHub Profile
# Database schema compare tool | Schema Comparison Tool | Schema Compare
https://github.com/dlevsha/compalex
http://compalex.net/
https://www.dbsolo.com/schema_comparison.html
Column Name List with comma seprated in mysql
sql column to comma separated string
table column name in comma seprated string table column column in comma seprated mysql table column name
SELECT CONCAT("'", GROUP_CONCAT(column_name ORDER BY ordinal_position SEPARATOR "', '"), "'") AS columns FROM information_schema.columns WHERE table_schema = 'HERE_IS_DATABASE_NAME' AND table_name = 'HERE_IS_TABLE_NAME'
Free Cpanel for hosting
1. https://cyberpanel.net/
2. https://vestacp.com/
3. https://www.aapanel.com/feature.html
Tor Browser (Because some time we need diff ip address :: some time we blocked for testing time)
// Install Tor Browser
https://www.tutorialspoint.com/mysql-delete-all-rows-containing-string-foo-in-sample-table-bar
mysql> select *from bar;
+----+-------------------------------------+
| Id | Words |
<h1>Test Test</h1>
<h1>Test&nbsp;Test 1 space</h1>
<h1>Test&ensp;Test 2 space</h1>
<h1>Test&emsp;Test 4 space</h1>
/* emoji ratings feedback javascript | Emojy Feedback */
https://adnan-tech.com/download/emoji-ratings-feedback-javascript/
/* Get User Time Zone */
// Dynamic Time Zone From User
https://usefulangle.com/post/31/detect-user-browser-timezone-name-in-php
Sachin I Card Template for family: https://www.canva.com/p/templates/EAE2ynNljcM-professional-employee-id-card/
Only First Name
Phone Number
Short Address
email
https://codepen.io/georgedoescode/full/ExwdJZq
https://codepen.io/georgedoescode/pen/ExwdJZq
https://codepen.io/georgedoescode/pen/bGaEGyq
https://codepen.io/georgedoescode/pen/YzxrRZe
<?php
$ua = strtolower($_SERVER['HTTP_USER_AGENT']);
if(stripos($ua,'android') !== false) {
prx('android');
}else{
prx('not android');
}