ashour

22 followers · 1 following

View GitHub Profile

Recently created

Least recently created

Recently updated

Least recently updated

ashour / select_article_data.sql

Created March 25, 2020 12:33

	SElECT articles_i18n.id AS id, published_at, title, body
	FROM articles_i18n
	INNER JOIN articles_i18n_translations ON article_id = articles_i18n.id
	WHERE locale = "fr";

ashour / articles_i18n_separated.sql

Last active March 25, 2020 13:13

	CREATE TABLE `articles_i18n` (
	`id` int(11) unsigned NOT NULL AUTO_INCREMENT,
	`published_at` datetime NOT NULL,
	PRIMARY KEY (`id`)
	) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

	CREATE TABLE `articles_i18n_translations` (
	`id` int(11) unsigned NOT NULL AUTO_INCREMENT,
	`article_id` int(11) NOT NULL,
	`locale` varchar(5) COLLATE utf8mb4_unicode_ci NOT NULL,

ashour / articles_i18n_simple.sql

Last active March 25, 2020 12:23

	CREATE TABLE `articles_i18n_simple` (
	`id` int(11) unsigned NOT NULL AUTO_INCREMENT,
	`published_at` datetime NOT NULL,
	`title_en` varchar(2000) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
	`title_fr` varchar(2000) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
	`body_en` text COLLATE utf8mb4_unicode_ci,
	`body_fr` text COLLATE utf8mb4_unicode_ci,
	PRIMARY KEY (`id`)
	) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

ashour / per-local-font.css

Last active March 25, 2020 11:07

	// default
	body { font-family: sans-serif; }

	:lang(en) { font-family: Times, serif; }

	:lang(ar) { font-family: Tahoma, sans-serif; }

ashour / injecting-localized-content.css

Created March 25, 2020 11:00

	p:lang(en)::before {
	content: "Hello ";
	}

	p:lang(ar)::before {
	content: "أهلاً ب";
	}

ashour / i18n_1_to_many.sql

Created March 24, 2020 13:26

	CREATE TABLE `users` (
	`id` int(11) unsigned NOT NULL AUTO_INCREMENT,
	`email` varchar(1000) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
	PRIMARY KEY (`id`)
	) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

	CREATE TABLE `user_translations` (
	`id` int(11) unsigned NOT NULL AUTO_INCREMENT,
	`user_id` int(11) DEFAULT NULL,
	`locale` varchar(5) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',

ashour / select_join.sql

Created March 24, 2020 13:24

	SELECT users.id AS id, first_name, last_name, email
	FROM users
	JOIN user_translations
	WHERE user_id = users.id
	AND locale = "ar";

ashour / select_simple.sql

Created March 24, 2020 13:16

	SELECT id, name_en AS name
	FROM users;

ashour / create_simple_i18n.sql

Created March 24, 2020 13:14

	CREATE TABLE `users` (
	`id` int(11) unsigned NOT NULL AUTO_INCREMENT,
	`email` varchar(1000) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
	`name_en` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
	`name_ar` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
	PRIMARY KEY (`id`)
	) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

ashour / locale-overrides.php

Created March 24, 2020 11:29

	<!DOCTYPE html>
	<html dir="<?php echo $dir?>" lang="<?php echo $locale?>">

	<head>
	<!-- ... -->
	<link rel="stylesheet" href="/framework.css" />
	<link rel="stylesheet" href="/app.css" />

	<?php if ($dir == 'rtl'): ?>
	<link rel="stylesheet" href="/framewor-rtl.css" />