10,946 Topics
 | |
 | How can I identify and delete unused MySQL indexes? I have a large table that has somehow accumulated way too many indexes over the years, and I'd now like to identify and delete indexes that are no longer used by the application. |
| | I ran into a bit of a snag in my code, and I'm trying to make heads or tails as to whether this will work. From within my PHP script, can I write to a database using a MySQL connection in the middle of a transaction with a different connection? … |
| | After the customer fills the form, the form data is sent to mysql and an email gets sent to me with the last form data that the customer submitted. But, the email "last mysql data" is not going as inline text. Please help me. Sample code is given below. ` …  |
 | Hello all! I have been away from this forum for far too long and would like to help with my experience/knowledge. This place helped me get through college and early professional work as a web developer. Is there a section to post random code snippets for tasks that may help … |
| | Hi guys/gals! I've read through a lot, great site but I'm stuck and have started pulling out teeth:( I would like to selectively display markers (that change everyday) on a Google map, using a a couple of checkboxes (areacode)and a selection list (prices). [CODE] <!--Based off of code from: http://tips4php.net/2010/10/use-php-mysql-and-google-map-api-v3-for-displaying-data-on-map/--> …  |
 | A script that was working fine on 100 records per batch choked when I fed it 1,000 records. It gave: mysql.connector.errors.OperationalError: 1040 (08004): Too many connections So I went ahead and made sure to connect.close() everywhere that I opened a connection, and the script made it much further but eventually … |
| | This week I'm working on the data warehousing capabilities of my application. Now most people here who have built more than a couple of applications can tell you how useful it is to include a datestamp on records or requests as they come in. The advantages are numerous. So much …  |
| | I’m looking for practical advice and best practices that can help improve a site's speed, considering factors like image optimization, code minification, and server response times. How do you balance performance improvements with maintaining a rich user experience? What tools or techniques have you found most useful in diagnosing and … |
| | Hello Gang! I'm grateful once again for the advice to use MySQL over Postgres. It's been a pretty smooth experience so far. Unfortunately I had to migrate to a different host and have been getting an undefined variable error. Mysql is Running. I used the package manager to get python-mysql.connector … |
 | I am having a problem understanding the following ... I am an okay web developer. I am not great. But I want to make money from my skills. Having said that, when I go to websites like Freelancer to search for a project to work on everyone is asking for …  |
| |    here is three Sql table name of them - 1. orders 2.order_item 3. target_value I am trying Two way here is may two code : 1 SELECT I.target_id as Iid, I.target_date as Idate, I.customer_name as Icust, I.target_product as Icat, I.target_pay as Ipay, I.target_rec as Irec, I.active as … |
| | Hi People, I am having displaying categories and subcategories: i have one table where i ise parentid in the same table as: pid, cat, parentid, details i am able to list all cats/sub cats but i want to display as like this: animal » doggie » companion but my list … |
| | |
| | Recently made a decision for an app I'm working on to accumulate data in batches AND THEN to insert it into the database with one statement rather than adding 1,000 records through one thousand separate inserts. Is this done better through file or memory? If I write the segments of …  |
| | Hey Gang! I'm hitting a point with my (python/mysql/linux) app for processing large amounts of network records where I need to make a design decision. I definitely want my app to have high performance. Because optimization as a skill set is so rare there is no reason not to employ … |
| | I was consistently receiving MySQL "Packets out of order" error messages when attempting to connect to MySQL, mostly on my AJAX pages, but I couldn't attribute it to anything or reproduce it in any way. I did notice, however, that when switching MySQL persistent connections from on to off, the … |
| | Hello I am trying to query a database to show records only for the current user using variable I get the correct data but only 1 row with results any guidance? // Query database to retrieve records associated with the user $sql = "SELECT * FROM table_name WHERE variable_name = … |
| | What are some ways to improve MySQL performance on queries against large tables that include the HAVING BY clause. It's my understanding that anything in there doesn't benefit from table indexes. |
| | Hello webmasters, I am currently building a template that I am going to sell on different websites like Codester and CodeGrape. I want to build a business directory. Here is what I have come up with ... 1. users can register and add listings. 2. admin can create categories for … |
| | Hi, can you recommend a cool site that will help with transportation of things?  |
| | Hey Gang! OK today I am having trouble with my transaction processing application implemented in python/MySQL. Here is some "working" testing code. import psycopg2 from psycopg2 import Error import binascii from binascii import unhexlify import mysql.connector as mysql sql='''CREATE PROCEDURE testprocedure(OUT tacos INT) BEGIN show tables; SET tacos := 1 … |
| | Hey! I've been asked to store some data from a client in mysql in an encoded format using python. Nothing could be easier, right? I will later need to decode the same data using mysql exclusively. Given that constraint, I thought that base64 would be the go to since nearly … |
 | Security matters. How can I guard against things like SQL injection or cross-site scripting? It will be really helpful if somebody could help. |
| | Hey guys, so I've been trying to create a website that allows users to update and delete records through the database I've set up in SQLyog. In my update confirmation file I've added location theme description to be updated and changed for all users. but for some reason its unable …  |
| | I'm working on an SQL query for a complex reporting system that involves multiple tables and joins. However, the query's performance is not meeting my expectations, and I suspect that the way I've structured my joins might be inefficient. Here's a simplified version of my query: SELECT orders.order_id, customers.customer_name, products.product_name, … |
| | Sometimes you need to delete duplicate rows in a database :) In the future, set UNIQUE keys when you need them :) In the example below, we have a table appropriately named `TABLE_NAME` and there are multiple rows that have the same value for the `duplicate_field` field. In this example, … |
| | Web development refers to the creating, building, and maintaining of websites. It includes aspects such as web design, web publishing, web programming, and database management. It is the creation of an application that works over the internet i.e. websites.  |
| | Anyone seen or had this happen before, whenever I add, edit or delete in this datable. It only does this when I add the js pagination\search  |
| | Hello There, Look at this PAGINATION I built. This script I built from scratch and is working fine to query my Mysql DB and show results. But I need your feed-back to know if I managed to use the functions in the correct order or not. //FUNCTIONS IN USE TO …  |
| | Hello! I have created a project on Android studio, and i use java as langage, i want to create a biometric system with fingerprint, what i mean is that i want to use android fingerprint device to get fingerprint id and store it in MySQL with some personal informations, so … |
| | Hiya, I need to learn the SQL query that counts all the points from more than one column and orders the matching rows based on most points in descending order. EXAMPLE 1: I do a keyword search for "mobile phone tutorial apps". Note 4 words. Sql should find all the … |
| | PHP Warning: mysqli_num_rows() expects parameter 1 to be mysqli_result, null given in <?php include("header.php"); $_SESSION['loc'] = "viewkeyowners.php"; if ($_SESSION['loggedin'] <> 1) { header("Location: logintest.php"); exit(); } //this is done because if user closes a tab/page, and logs back in(still in session), it would redirect to the last opened tab/page function … |
| | What are the top 3 most important things to consider for a successful ecommerce website? |
| | I am having trouble showing the export buttons, it works perfectly if the data is not fetched from database with the basic example however they are not showing with my php code, I have included the script and necessarry files from https://live.datatables.net/kugajayu/1/edit. Please help, below is my script. <!DOCTYPE html> … |
| | Hi Wanted to utilize the php/mysql insert into the FPDI pdf export tool. I have it working just as plain text which is nice. But, i'd like to to have mysql place db entries into it. I've declared my sql connection, just using dreamweaver at the moment. I'm struggling to … |
| | Hiya, It seems to me that if I put a condition on ```` mysqli_stmt_fetch($stmt); ```` to check if user credentials was ok enough for the data to be fetched, then the whole purpose of using the following function is defeated. ```` password_verify() ```` This is what I mean .. ```` …  |
| | I have a database which contains authors and books. Some of those authors and books contain slashes in the name or title fields. When I query the database for authors, it matches just fine, with or without slashes. When I query books, however, it only finds books without slashes in … |
| | I need to check db for matching user credential on login script. There must be atleast one matching row. Else, script should alert user not registered. Need to check the db using the function ````mysqli_stmt_num_rows()````. Assignment is to list all the various valid ways this function can be used to … |
| | Helle Fellow Programmers! Unlike last time where I was checking for matching rows count using mysqli_stmt_rows_count(): https://www.daniweb.com/programming/web-development/threads/539306/login-with-prepared-statements-mysqli-stmt-num-rows-function On this thread, I am checking for matching rows count using Sql's COUNT function. This means, both threads are not same so mods do not close them. Issue is, on both threads, no … |
| | Hiya, Which of these IF CONDITION codes are valid ? And can you rank the valid ones according to your choice by giving reasons to your choices ? Thanks! 1. ```` $conn = mysqli_connect("localhost","root","","buzz"); $sql = "INSERT into users (username,email) VALUES (?,?)"; if($stmt = mysqli_prepare($conn,$sql)) { mysqli_stmt_bind_param($stmt,"ss",$_POST[username'],$_POST['email']); if(!mysqli_stmt_execute($stmt)) //FIRST CHOICE … |
 | What are some essential skills every web developer should have? |
| | I want to populate report in browser, i prepare this report in i-net clear report, and report file having extension of rpt. I also want to pass parameter  |
| | Hello, I do not see $data defined, so what is it ? ```` function prepared_insert($conn, $table, $data) { $keys = array_keys($data); $keys = array_map('escape_mysql_identifier', $keys); $fields = implode(",", $keys); $table = escape_mysql_identifier($table); $placeholders = str_repeat('?,', count($keys) - 1) . '?'; $sql = "INSERT INTO $table ($fields) VALUES ($placeholders)"; prepared_query($conn, $sql, … |
| | Howdy once more, Just got another question on Sql and Php Prepared Statement. How would you confirm a successful row insertion to a mysql table ? Which one of the following lines would you add the IF condition to in order to check insertion successful or not ? 1). mysqli_stmt_execute() … |
 | I am not that much of an expert in PHP as it has been few months since I started playing with it. Currently I am working on creating a basic CRUD operation in PHP. I follow this tutorial on CRUD in PHP (https://www.cloudways.com/blog/execute-crud-in-mysql-php/ ) to create it on a local … |
 | create table customer ( cname char(20) not null, street char(30), city char(30), primary key(cname) ) create table branch create table account ( bname char(15) not null, bcity char(30), assets integer, primary key(bname), check(assets>0) ) ( account # char(10) not null, ( bname char(15), balance integer, primary key(account#) forigen key (bname) … |
| | Thank you for looking at this problem, details are all below. Below is the code <form style="overflow: hidden;" method="post"> <input type="checkbox" aria-label="Checkbox for following text input" name="kursus[]" value="<?php echo $row['IDKursus']; ?>"> <div class="d-flex justify-content-between mt-3"> <button type="submit" class="btn btn-success" name="daftar_kursus">Daftar Kursus</button> <button type="reset" class="btn btn-primary">Reset</button> </div> </form> if (isset($_REQUEST['daftar_kursus'])) { … |
| | Hey everyone, I have started a new position as an HR recruiter in a Website Development Company, can you guys suggest to me some questions I can ask fresher as well as experienced candidates? |
| | I have a programming code problem, I need help to solve the problem. How to explode data array using MYSQL and using NOT IN. The program code is below <form style="overflow: hidden;" method="post"> <div class="table-responsive"> <?php $sql = "SELECT * FROM kursus WHERE KodKursus NOT IN (SELECT kursusList FROM pensyarahkursus … |
| | hii, i want to ask how to loop this array for menu like in images public $list = [ [ 'id' => 'dashboard', 'text' => 'Dashboard', 'icon' => 'feather-home', ], [ 'id' => 'data_tables', 'text' => 'DataTables', 'icon' => 'feather-layers', 'children' => [ ['id' => 'basic', "text" => "Basic"], ['id' …  |
The End.