Tag: mysql

Cann’t delete row in php using AJAX

I am deleting row in PHP using AJAX, but it shows Row can’t delete. My Delete button is like this… while ($row = mysqli_fetch_array($exec)) { ?>

Upload longblob works in local but not in web server

mysql php

I have a php file that loads an image and receives a text, then sends them to another .php that runs a query to save the data in the database … everything works fine in my local version, but in the version Web only the text is saved, the longblob does not. I tried to debug using $_FILES[‘error&#82…

How to disable ONLY_FULL_GROUP_BY in codeigniter?

codeigniter codeigniter-3 mysql php

I have worked may time with Group BY in mysql but recently i have received a problem of Group By. I searched from many sites and I got the problem that its due to upgrading the mysql version in which it is enabled and in old versions it was disabled. I won’t remove it using the query but from the

How to store password securely in database

mysql password-encryption php security ssh

Currently I am working on php project. The project main theme is to login through ssh to some cisco switch in my local network , fetch details and populate it to user. To accomplish this I have created on database in MySQL consisting switch login credentials. And my PHP code will fetch the login credentials f…

How to retrieve the array values from multiples checkbox?

codeigniter codeigniter-3 mysql php

How to retrieve the array values from multiples checkbox? I have problem when I retrieve value array and echo the value. I get this error Severity: Warning Message: in_array() expects parameter 2 to …

Network response not sending ‘allow-origin’ header

mysql php

I’m having this error on my web application when I try to update a database object: Access to XMLHttpRequest at ‘http://localhost:3001’ from origin ‘http://localhost:8080’ has been blocked by CORS policy: No ‘Access-Control-Allow-Origin’ header is present on the reque…

mysqli_query return false instead of 1 row

mysql mysqli php

I do not understand why mysqli_query return false, I seach a lot on internet but I have not found anything. My code : $M1 = “SET @Month = month(TIMESTAMPADD(month, -1, CAST(now() AS DATE))); Set …

How To Extract Information On Login using SQL Injection?

code-injection mysql php sql sql-injection

This is the back-end PHP code which where I will test the vulnerability. This is the code I will inject the login field. It seems I am able to login but what should I do to have the passwords displayed in a error message or anything on the web page once the injection is made? Like what query you guys

Counting specific records MySQL

database mysql php search

I want to show the count of users which have the status 1 (see code) within PHP MySQL. <?php // something like this $result = mysqli_query($mysqli, "SELECT COUNT(*) FROM users WHERE status = '…

How to get list of movies based on genre and language

database mysql php sql

I have stuck to get list of movies based on genre and language. Here’s my database structure: movies table ———————– id | title| ———————- 1 | ABC 2 | PQR 3 | MNC category table —————&#8…