I want the code to check if the current user category is admin or superadmin, it will show the edit panel @if (Auth::user()->category=='admin'||Auth::user()->category=='superadmin') <td class="center"> <a href="{{ route('Order.edit', ['id'=>$order->id ]) }}" class="btn btn-warning btn-sm custom"> <i class="glyphicon glyphicon-edit"></i> EDIT</a> </td>…
audio table 1.id 2.artist 3.filename 4.album 5.release 6.audio URL 7.no download 8.no played 9.producer 10.studio, video table 1.id 2.artist 3.filename 4.album 5.release 6.video URL 7.no download 8.no played 9.producer 10.studio album table 1.id 2.album pic 3.title 4.album name 5.release 6.audio…
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");…