10,946 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? |
| | how to display a record from mysql database list with php  |
| | 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,  When you click any checkbox there, the release request button will enable.  When it was clicked there's a modal will pop up:  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.  Here's what it looks like.  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 … |
| | Hi, I am not sure which mysqli error reporting function to use here. Which of the two is correct ? 1. if(!mysqli_stmt_prepare($stmt,$sql_count)) { echo __LINE__; echo '<br>';//DELETE echo 'Mysqli Error: ' .mysqli_stmt_error(); //DEV MODE. echo '<br>'; echo 'Mysqli Error No: ' .mysqli_stmt_errno(); //DEV MODE. echo '<br>'; die('Registration a Failure!'); } … |
 | 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>' …  |
| | |
| | I have created a form using HTML, now I won't save the input data into my browser's local storage DB. I want to same multiple inputs, not just one. how do I do it I believe I need to use javascript but I'm not strong with it and am still …  |
| | The term SQL stands for Structured Query Language, it's a programming language that's used to update and communicate with the database. SQL skills are indispensable and are in demand as with the boost in technology, data is piling up. And, In today's world this data has become a necessity for … |
| | I need help on how to calculate the total work hours in a 12 hour format. I have a database that has the columns for the time in and time out as well as the total hours. Try If txtSCANRFID.Text = "" Then Else reloadtxt("SELECT * FROM students WHERE RFIDNumber= …  |
| | hey I'm beginner learning php have hard time to Insert data to product in database with image because the category I did make it work but now I need to update data the same style that I add it with the Insert Code: <?php include('./pro_crud/config.php'); $sql_cat = "SELECT * FROM … |
 | I have a couple of scripts from the same template but different version. I am using php and mysql. I need to know how to update the mysql database and the script from version 1 to version 2 with a single click.  |
| | Hello there, I created a "users" table on MySQL and created a few columns namely "accountbalance", "ledgerbalance" and "dailybalance" (all three: BIGINTs). I created a test user and added some random figures. I am trying to retrieve the value of this columns (unique to the user) and them pasted separately … |
| | I want to auto generate the id number. I write this code. But it's not work. I don't make primary key for id in database. function getData() { $data = array(); $data[1] = $_POST['name']; $data[2] = $_POST['fname']; $data[3] = $_POST['address']; $data[4] = $_POST['phone']; $data[5] = $_POST['class']; $data[6] = $_POST['qualification']; $data[7] … |
| | import net.proteanit.sql.DbUtils; import javax.swing.*; import javax.xml.transform.Result; import java.awt.event.ActionEvent; import java.awt.event.ActionListener; import java.sql.*; public class EmployeeRegistriation { private JPanel Main; private JTextField txtName; private JTextField txtSalary; private JTextField txtMobile; private JButton saveButton; private JTable table1; private JButton updateButton; private JButton deleteButton; private JButton searchButton; private JTextField txtId; private JScrollPane tabla_1; public … |
| | hii guys i have web site need to generate random progress like this  can some one suggest me how can i make it |
| | Hi all, I hope someone can help me with the following. I have a script that reads a txt file and displays the correct values. I only want to add it to the database now, but I can't manage this. below the script <?php include '../includes/connect.php'; if(!$conn) { die(mysqli_error()); } … |
| | hi, i have some problem with my php code. when i run the php, the page keep loading and no output displayed. here is my code: $dayBeforeNew = $_GET['daybefore']; $dayAfterNew = $_GET['dayafter']; $sql = "SELECT reference.LOCID, reference.Region, Sitename, (SELECT `Data Total Traffic` from 4g_statistic where reference.LOCID = 4g_statistic.LOCID AND 4g_statistic.Day …  |
| | Guys, what am I doing wrong? The database "expiry" value is > 0 but I go to expiredpage.html. ======================================================== the code: <?php $link = mysqli_connect("localhost", "root", "", "numbersdb"); // Check connection if($link === false){ die("ERROR: Could not connect. " . mysqli_connect_error()); } echo "<center>";echo date('m/d/y');echo "<br />"; $id='id'; $expiry='expiry'; if($expiry==7) … |
 | I have a subform called "Contacts" embedded on my "Tickets" page. I want to create an edit button to jump to my contacts_edit.php page and use the 'ContactEntryNumber' (the unique key from my Contacts table) for the displayed contact record as the updateID. I have played with this and read … |
| | Hello webmasters, I am trying to create a script using vanilla PHP. I am familiar with the language and I have created a cronjob before, but only using cPanel. I want to create cronjobs using PHP if possible with out the need to go to cPanel. I am trying to … |
| | Hi everyone, I am getting an undefined array key with a session variable. The code works fine once I set the variable. Can someone please help me with that issue? Thanks <?php session_start(); $servername = "localhost"; $username = "xxx"; $password = "xx"; $database ="xx"; // Create connection $conn = mysqli_connect($servername, … |
 | Hi DW. I'm creating a chat system which will alow guests to send DMs to the operator and the operator can reply to it. I'm using MYSQL as my database, fingerprint2js for identifying the user since user has not yet logged in or registered but want to first communicate with … |
| | So far, we have gotten lots of innovative social media models. I am not too sure if this has already been tried, but I want to innovate on ownership model. Basically, I envision a Reddit that is owned by its mods and users. Maybe a hybrid FB and Reddit. It …  |
The End.