I have two table events and session which looks like this Events table Sessions table I want to display data based on date ranges Here is my solution SELECT sessions.sid, events.datetime, count(*) as num_rows, count(distinct sessions.sid) as sessions, sum( targetbuttonname…
So I ran a php file where I'm connecting it to a Database and executing a query, but I ended up getting an error stating Error updating record: You have an error in your SQL syntax; check the manual that…
I've got a XAMPP installation (Apache, MySQL, php, phpmyadmin) on a Windows 10 machine, in D:xampp, which I've been using for at least 3 months without any issues. Since today, without having changed any config or installed anything, when trying…
I'm getting this warning when importing mysql dumps in phpMyAdmin: Warning: #1681 Integer display width is deprecated and will be removed in a future release. I found this on https://dev.mysql.com/worklog/task/?id=13127 Deprecate the ZEROFILL attribute for numeric data types and the…
I have two table events and session which looks like this Events table Sessions table Here is expected results Here is my solution <table> <tr> <th>Sessions </th> <th>konto</th> <th>Mobile</th> <th>Komputer</th> <th>Date</th> </tr> <?php $conn = mysqli_connect("localhost", "root", "", "ideabank_julia"); //…
Consider: Now I am getting this error. How can I resolve this issue? I found found some related issue, but that told me change max-size inside file php.ini, so how can I edit file php.ini (phpmyadmin-config)? Importing into MySQL, the…
Specifications: Laravel Version: 5.4 PHP Version: 7.0.9 Composer version 1.9.0 XAMP Description: In Connection.php line 647: SQLSTATE[42S01]: Base table or view already exists: 1050 Table 'users' already exists (SQL: create table users ( id int unsigned not null auto_increment primary…
I have this PHP code in which I try to edit a row in the database $sql="SELECT * FROM `event` where `EId`='".$_GET['EId']."'"; $res=$conn->query($sql); $numrows=mysqli_num_rows($res); if ($numrows>0) { $obj = mysqli_fetch_object($res); } if ($_REQUEST["mode"]=="save") { if ($_FILES['image']['name']!="") { del_img("event/",$obj->Picture); $Picture=post_img($_FILES['image']['name'], $_FILES['image']['tmp_name'],"event");…
I created a new laravel project, changed the application key, and the database data in .env and database.php files. Here is the .env: APP_NAME=NewSite APP_ENV=local APP_KEY=base64:Sh8WFAEfaUTDadmmpFiTDE8gbgUAOm7zgIywx8ZKRUo= APP_DEBUG=true APP_URL=http://localhost LOG_CHANNEL=stack DB_CONNECTION=mysql DB_HOST=127.0.0.1 DB_PORT=3306 DB_DATABASE=NewSite DB_USERNAME=NewSite DB_PASSWORD=NewSite BROADCAST_DRIVER=log CACHE_DRIVER=file QUEUE_CONNECTION=sync SESSION_DRIVER=file SESSION_LIFETIME=120…
I have a problem with docker and mysql (i am pretty new with docker) I am trying to use symfony 3.4 with docker. I have this error : In AbstractMySQLDriver.php line 103: An exception occured in driver: SQLSTATE[HY000] [2002] php_network_getaddre…