Monday, August 15, 2022

Update Records Into Tables Using SQL Join Query

 this query is used for update record into tables with join and where query which update all matching records.

UPDATE `product`

inner join `category` on `category`.`id` = `product`.`category_id` and `category`.`deleted_at` IS NULL

 SET `product`.`category_id` = category.id WHERE `product`.`deleted_at` IS NULL AND `id` = '1'

How To install PHP 7.0 Into Ubuntu And Its Maths Functions Using CMD

 this commands is used for install php 7.0 with cmd and various type of maths function 

sudo apt install -y php7.0

sudo apt install -y php7.0-cli php7.0-fpm php7.0-common php7.0-json php7.0-opcache php7.0-mysql php7.0-phpdbg php7.0-mbstring php7.0-gd php7.0-pgsql php7.0-intl php7.0-curl php7.0-zip php7.0-xml php7.0-mcrypt php7.0-sqlite3 php7.0-xmlrpc php7.0-xsl

sudo sed -i  "s#user = www-data#user = username#"  /etc/php/7.0/fpm/pool.d/www.conf

sudo sed -i  "s#group = www-data#group = username#"  /etc/php/7.0/fpm/pool.d/www.conf

sudo sed -i  "s#;cgi.fix_pathinfo=1#cgi.fix_pathinfo=0#"  /etc/php/7.0/fpm/php.ini

sudo service php7.0-fpm restart

Saurashtra University Old Exam Papers for Andorid

How To Count Duplicate Records Using SQL Query.

SELECT count_id, COUNT(count_id)

FROM select_table_name

where where_id > 1 and

GROUP BY count_id

HAVING COUNT(count_id) > 1

Generate Even Numbers in a Range In PHP.

$start = 1; $end = 20; for ($i = $start; $i <= $end; $i++) {     if ($i % 2 == 0) {         echo $i . " is even.<br>";   ...