7,368 Topics
| |
Good Evening People, No matter what I do in mysql, why I get this following error where the rows do not get deleted ? **Error SQL query: Copy Edit Edit DELETE FROM `phpmyadmin`.`pma__column_info` WHERE db_name = 'buzz' AND table_name = 'submitted_links_index2' AND column_name = 'title' MySQL said: Documentation #1142 - … | |
Hi, first of all let me thank anyone willing to help out with this. Jquery / Ajax update Span or Div by ID without refreshing page <!DOCTYPE html> <html lang="en"> <head> <meta http-equiv="refresh" content="60"> <!-- Esta línea hará que la página se actualice automáticamente cada 15 segundos--> <meta charset="utf-8" /> … | |
So I'm new to php but I've managed to create a drop-down that fetches products and displays them, I want to display quantity in the drop-down below it and I have set that up too it fetches other data if the query is modified. The problem is I don't know … | |
Hi, Are these MySql queries (with Php) correct ? Wild Card match. Fuzzy Match query. Imagine there are 7 columns in the Mysql table. $sql = "SELECT * from $tbl WHERE $col_1 LIKE ? OR $col_2 LIKE ? OR $col_3 LIKE ? OR $col_4 LIKE ? OR $col_5 LIKE ? … | |
> Hi, this should be simple but I'm having trouble and need help, please. I just want to update the "expiry" value in the "ctltbl" and relocate depending on the value. The update doesn't happen and it goes to sysnav even when expiry is 0. "ctltbl" is 1 row. <?php … | |
Work with visual basic 2019 and Mysql database Save and edit record with a imge in picturebox is ok but when i scroll the datagrid i get a datagrid error so i can not show the picture when i scroll picturebox1.image blocking my program | |
Hi, I am trying to create a login page using the sql's mysqli_stmt_num_rows() function. Issue is, no matter if I give correct password or incorrect, I always get message 'Incorrect user Credentials'. Why is that ? The details on Mysql Looks like this: id|domain|password 0|gmail.com|373b29d2837e83b9ca5cec712a5985843df271cc Obviously, password is hashed using … | |
Php Programmers, Getting to build a login page using the php's password_verify_() function. Issue is, no matter if I give correct password or incorrect, I always get message 'Incorrect user Credentials'. Why is that ? The details on Mysql Looks like this: id | domain | password 0 | gmail.com … | |
Help me! I have this number 1726.16723958045672098127. How Can I register in my db MySql. Why is the number truncated? | |
What is best way to get one row from a mysql table (with many columns) so I can use several several fields from that row for calculations in a C program? After executing a succesful SELECT command using mysql_query, is there an alternative to using mysql_store_result? | |
> Hi, I'm having trouble coding the if/else statement. No matter what value the expiry has, line 17 is echoed. If it is =>1 I want to sysnav.html. <?php $link = mysqli_connect("localhost", "root", "", "homedb"); // Check connection if($link === false){ die("ERROR: Could not connect. " . mysqli_connect_error()); } //MySqli … | |
| Hi,This code creates a friendly link on user mentions in comments... However, it is not case sensitive and vice versa. Examples; @test works @Test doesn't work The regular expression takes both values. But the query is not catching. I figured it would be a case-sensitive collation on the database. But … |
| Hi,This code creates a friendly link on user mentions in comments... However, it is not case sensitive and vice versa. **Examples;** **@test** works **@Test** doesn't work What do I do? text = "@test @Test"; $pattern = "/\@(\w+)/"; preg_match_all($pattern,$text,$matches); if($matches){ $sql = "SELECT * FROM users WHERE username IN ('" .implode("','",$matches[1]). … |
Hello, I am building a searchengine with php. Nearly finished. Now, I need to build the web crawler. Since most websites have xml sitemap for web crawlers to use to find their site links, I prefer to build an xml site map crawler than a general http crawler. I am … | |
i have 3 tables : users, deposit, withdraw **table users :** id , username, referral 1. 1, a1, null 2. 2, a2, a1 3. 3, a3, a2 4. 4, a4, a1 5. 5, a5, a2 **table deposit :** id, users_id, amount, status, approve_date 1. 1, 1, 10000.00, approve, 2022-10-01 14:52:53 … | |
I am trying to insert into table with PHP and MySQL but the page only refresh it self when i press the button. I haven't done debugging, i have an IF statement that displays any errors that fires if the SQL query have errors. But the thing is even the … | |
I'm wondering how to update my database using a modal and multiple data from another form. This is how it looks like, ![1.png](https://static.daniweb.com/attachments/4/9f1a52cdeffddb99e65e6d73d8febd7b.png) When you click any checkbox there, the release request button will enable. ![2.png](https://static.daniweb.com/attachments/4/1db9299fc8e0995c48be16f9b41f4cc0.png) When it was clicked there's a modal will pop up: ![3.png](https://static.daniweb.com/attachments/4/4bc7fe8fc346f118c3c3282c341ac6bb.png) Now, the modal … | |
So, I have made a table called `supplies_table` and inside the table is `id`, `name`, and `files`. And I also made an upload button where it can upload a pdf BLOB file into the `files` column. Yes, it can upload a pdf file in the `files` column but the problem … | |
I have this code foreach loop it will get the first data form my table every iteration on the next output. I would like to have a guidance on this <select class="selectpicker form-control" data-live-search="true"> @foreach ($IncidentTypes as $Incident) <optgroup label="{{ $Incident->incident_type ." ". $Incident->id }}"> @foreach ($Incident->IncidentSubType as $subTypes) <option> … | |
Hi ppl I want to known about the availability check of hall booking I'm developing a website which is based on the venue booking system but i want to add availability chrck form in it so the same hall not booked at the same start time or same date There … | |
I have a project that no one can or wants to engage in. The data is in a database table. The code displays a menu, selects a target (url - http://.....), displays the record - so far so good....then I want to click the button and redirect to the url.... … | |
I have this form where I'm editing a student's information like changing the provider assigned to him. I'm having a problem with it since the dropdown menu is coming from MySQL database that has the full name. ![provdata.png](https://static.daniweb.com/attachments/4/c03e715e350cced146c03f6dd137b822.png) Here's what it looks like. ![provider.png](https://static.daniweb.com/attachments/4/0e91d237fb3e840d96ee1c350432a974.png) When I try to select one … | |
I am in the middle of making a web based system for shows and each show as a different closing date for entries. The closing date is stored in a database. I need to display a export to excel button once the closing date has passed for each show. I … | |
Hello all, I would like to set a time after 2 requests that someone can make a request again does anyone have an example for this. thanks in advance | |
| Hi. Please could someone help me understand what's happening here. I have a MySQL database which has a table with some data in the following format: 2022-03-15 06:55:39:<br/>LineOfSight:<br/>java.lang.Exception:<br/> UNAVAILABLE TELEMETRY BR$0 The field collation is utf8 and the data is stored as text. This data is provided via a 3rd … |
This question is relation to a Node.js - express - Sequelize - MYSQL application. I am trying to test my application using Curl command but I am getting "Invalid Departure Time" error. This application is also using Luxon. I have tried all the possible fixes I could but nothing is … | |
Hello everyone! This question is related to using Sequelize with Node.js and MySQL. I have come across a small doubt and need your help. To enable CLS with Sequelize we initialize a CLS namespace using the following lines of code: ``` const cls = require('continuation-local-storage'); const namespace = cls.createNamespace('custom-sequelize-namespace'); const … | |
I want to make a pdf file in php. I write code like this: <?php require_once __DIR__ . '/vendor/autoload.php'; include('conn.php'); $res = mysqli_query($conn, "select * from smash"); if (mysqli_num_rows($res) > 0) { $html = '<table>'; $html = '<tr><td>ID</td><td>Name</td><td>FatherName</td><td>Address</td><td>Phone</td><td>Class</td><td>Qualification</td><td>Branch</td><td>rollno</td></tr>'; while ($row = mysqli_fetch_assoc($res)) { $html .= '<tr><td>' . $row['id'] . '</td><td>' … |
The End.