Posts

Showing posts from March 2, 2019

mysql select query running okay on phpmyadmin but not with php [closed]

Image
1 This is the mysql query SELECT *, `main`.`email` as useremail, `main`.`ID` as `userID`, `mail_owners`.`country_code_field` as `micountry`, DATE(`main`.`time`) as `mrDate` FROM `main` LEFT JOIN `mail_owners` ON `main`.`ID` = `mail_owners`.`ID` WHERE `main`.`is_deleted` = 0 AND (`main`.`time` BETWEEN '2018-08-01' AND '2018-11-14') ORDER BY `main`.`ID`, `mrDate` DESC This query working perfectly on sql....but it's not working perfectly on php. it's running on php but only getting some data not the total. here describes the php codes: $fdt = $_POST['formDt']; $tdt = $_POST['toDate']; $sqlforData = "SELECT *, `main`.`email` as useremail, `main`.`ID` as `userID`, `mail_owners`.`country_code_field` as `micountry`, DA

Determinant of matrix formed from blocks of a $2 times 2$ block partitioned symplectic matrix.

Image
5 $begingroup$ While working on a problem in quantum optics, I came across the following determinant of a complex matrix of size $n times n$ : $$mathbb{G}=detleft[mathcal{U}_{11}^{}+mathcal{U}_{12}^{}mathcal{D}_{S}^{}right]$$ where $mathcal{U}_{xy}^{}$ are blocks of a $2 times 2$ block partitioned complex Symplectic matrix defined as, $$begin{pmatrix}mathcal{U}_{11}^{} & mathcal{U}_{12}^{} \ mathcal{U}_{21}^{} & mathcal{U}_{22}^{}end{pmatrix}:=mathcal{U}_{2n times 2n}^{}=e_{}^{-mathcal{H}^{}Sigma_{}^{}}$$ with $mathcal{H}^{}Sigma_{}^{}$ being a complex Hamiltonian matrix expressed as a product of complex $2 times 2$ block partitioned symmetric matrix $$mathcal{H}^{}=begin{pmatrix}mathcal{A}_{n times n}^{}=mathcal{A}_{n times n}^{T} & mathcal{B}_{n times n}^{} \ mathcal{B}_{n times n}^{T} &a