1,050 Discussion / Question Topics
Remove Filter  | |
 | 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 … |
| | Hi everyone, I am Emmanuel Katto. I'm building a high-traffic web application that requires fast and efficient data retrieval from a relational database. To improve performance, I'm considering implementing a caching layer using Redis. But, I'm not sure about the best approach to design and integrate the caching layer into …  |
| | Project Preparation. Business Blueprint. Realization  |
| | 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, …  |
| | An equipment company wishes to create a database to support the hiring of tools and machinery to clients. The company has three types of equipment: power tools, such as drills and vacuum cleaners, plants such as excavators and scaffolding. Each piece of equipment is identified by a number. Power tools … |
| | **I have attached all of the coding needed** I'm using PHP to design a website. The problem that I am facing is that, the button on the add products page isn't taking the inputs and putting them on the products list page. I'm wondering what I can do to get … |
| | I am interested in technology, however I do not wish to go to university and after stumbling upon the MIT Challenge, I have taken it as a proof of concept. Clearly education is changing, and I would like to take a less traditional route. But before I go too far, … |
| | Any programming language or software that can help in database design and manipulation |
| | Hi All, I am going to write a small inventory tracking app for a small company. What they need is only to keep track goods in, goods out, supplier, customer, and purchase price and sell price so we are able to calculate purchase price, sales price, and stock value. [LIST=1] … |
| | Greetings. I am making some Point of Sales system but I have a little problem with the database design. You see, there is this list of products that will be added to a cart. What I need is when these items are added in the cart and then sold, it … |
| | I am making a small example of adding, editing, deleting and saving the treeView directory tree into the SQL Server database, what must I design to store in the database and write code ? |
| | I have dynamic page which is loading and preview page from database retrieved values. I did this with successfully. I want to remove parameters from page url. Note that I only used one parameter in url. My url is something like this. (with parameters) http://ads/ad?this=daihatsu-boon-m700s-new-design-2016-nugegoda-2019-04-05-22-49-04 I tried to remove parameters … |
 | hello everyone im taking database course this year and it's my first time to take it so i need help how to draw a ERD for following busniess case AND IF there many to many relation how i can establish a new relation ! Entity (Artist ) Attribute : death … |
 | I need a help about this i have a log in form design Username Password And my database table Username Password Usertype I want that if admin will login admin form will show. While if employee will log in emlpoyee form will show. How to do that in code. Im …  |
 | Dear Frien, I am working in C# .... I nedd Help/.] I created FROM1 which has DATAGRIDVIEW and fetched data from Database,and on the Form2 has Crystal Report Design , how can transfer data from Datagrideview of FORM1 to Crystal Report of FORM2.......... Code is bellow-: private void btn_CrtRep_Click(object sender, … |
 | Hi, I was hoping someone could help me. I'm trying to create a database to track exam results of students through 4 years of university study. Each year, students sit up to 10 different exams which have different weighting allocated to the results to determine a final aggregate result. I …  |
 | Hello to all, I am working on a project of job posting. There is a table in database. I have a html form and postcode.php (there will be code) , I am facing a problem with this code. **My html form code:-** <form name="posting" action="postcode.php"> <table class="table"> <h4>Job Details: <span>specify …  |
| | Hi All, I'm currently designing a website for my business and would like to have a system that pulls products from my database via PHP and adds them to my products section, but I'm unable to find anything that explains how to do it for the kind of setup I … |
| | his is an example of creating a semi-dynamic pie chart without the use of server-side imaging libraries [url]http://www.surfare.net/~toolman/temp/diagram.html[/url] CSS Diagrams Things to Do With CSS When You’re Bored at Work [url]http://komodomedia.com/blog/index.php/2005/08/24/creating-a-star-rater-using-css/[/url] Star Rater Creating a Star Rater using CSS [url]http://komodomedia.com/blog/index.php/2006/01/09/css-star-rating-part-deux/[/url] CSS Star Rating CSS Star Rating Part Deux [url]http://www.jluvip.com/works/css/starvote/index2-1.html[/url] Star …  |
 | I am working on a table that will hold batch data. The table will have a BatchDate column as a DateTime type. I'm considering adding a column for BatchYear as an integer and BatchPeriod (which could be a week number, a month number or a quarter number) as an integer, … |
| | I'm a beginner with databases and I'm trying to design a database in Microsoft Access that will allow users to make bookings for fitness classes. There are two slots per day that these classes can be booked for and each session can cater for 10 people. What I am struggling …  |
 | Hi to all! I made a class named “Database” I called openOrCreateDatabase in in its constructor but it was giving error. Then I searched on internet and got a solution that in case of non activity class I should also pass context. Then I passed context but then I am … |
| | Hi, I am developing a mobile app for a health care institution. I'd like to get a suggestion on how to approach my database design. There are many user types of this app; residents, nurse, and general-staff. The "resident" has many information that other types don't have; unit_number, food_allergy, emergency_contact, … |
 | Hey fellas. I've been using Windows as my main OS since I sat on an PC with win 95. Now I think is time to finally change to Linux! The main reason I didn't change sooner was because the .NET dev env, but now there's Mono. So, I really would …  |
| | Database systems and Administration Scenario: PEC offers several programs. Each program is supervised / chaired by a Head of the department (HoD) who is a lecturer. One HoD can lead only one program. There are several departments for each program. Many modules are offered by each department. Few departments are …  |
 | Dear folks , I've already created some website from scratch with html and javascript , php etc. On the other hand i also created websites with wordpress. I find the freedom in creating from scratch grandiose to say at least but wordpress to me has the benefits of professionally looking …  |
| | I have a form on our website that a user can fill out for custom product. I want the form data to be 1) stored into a mysql database AND after storing said data, 2) email the same data to our sales department. 1) The form data DOES get stored … |
 | As the title says, anyone else noticing the activity on DaniWeb suddenly dropping? I usually check the Database and Software Developing sections in the morning. The Database one for awhile was getting a few new topics at least a day, but all of a sudden, it seems to have almost … |
| | Howdy All, I'm creating a database for UFO sightings and would appreciate some feedback or suggestions. Yes I know, strange topic. Some background info so that the problem is understood: I'm extracting data from several large UFO database catalogs, news articles, and other miscellaneous sources, so that the data can …  |
| | **Bold Text Here**Hi there I'm just wondering what the best or a good table layout would be for a little project I'm trying to do at work. I work at a temp to perm agency where companies use us for the probationary peroid of employement and then hire the workers … |
 | The Scenario Wyndham Summer Houses are a construction company based in US. The company specialize in building summer houses and outbuildings such as sheds. They want you to design and implement a database that meets the requirements for their data. These requirements are specified in this scenario and the examples … |
| | Choose a problem that interests you and which can be solved with a program. This problem will be the foundation for your homework assignments and presentation; this is the problem for which you will design a solution during this course. Your chosen problem should be of reasonable complexity. If a …  |
| | How can i design a simple php site with a database like facebook  |
| | Recently in an interview I was asked to design a "send invitation for an appointment to multiple contacts in a company". (Something similar to creating an Appointment in Outlook) Here is what I came up with, I would really appreciate some feedback, suggestions, questions. So, after asking few questions, the … |
| | Dear all, i am trying to design a purchase form in which i wish to use jtable , when i press any character into the cell it should open a jlist with populated values from database and which let me select only one item from there and get the selected … |
| | Hello, I have a little problem , I am currently developing an application with PHP and MySQL , this application should show me more persons, each person must have one or more services and each service can be inversely associated with several people, for this I have 2 tables, one … |
| | Hi I am building this website for a small hotel. The user interface is ready and I have a form as shown below: If I click on submit I can insert the data from the form into the database.My question is where do I go from here? Is my database … |
| | Parse error: syntax error, unexpected '{' in E:\FYP\DB\TWAMPd\htdocs\web\edit_infos.php on line 58 I can't update the information page . Can someone help me? <?php include('config.php'); ?> <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"> <html xmlns="http://www.w3.org/1999/xhtml"> <meta http-equiv="Content-Type" content="text/html; charset=utf-8" /> <link href="<?php echo $design; ?>/style.css" rel="stylesheet" title="Style" /> <style type="text/css"> … |
| | Hi, Please I'm new in database and I need your help, I'm working on my database project and before to continue I would like to be sure that my NORMALIZATION 3NF and my ER Diagram are correct. **Normalization 3NF** DESIGN PARTS SPECIFIED IN DESIGN PARTS PARTS USED AS SPECIFIED IN … |
| | Hi, sorry for my newbie question but I can't understand what is the different between Logical and Conceptual database design. Can you provide me with some samples for those two types of design? Also what design is generated with MySQL Workbench for example when you import database schema? Is it … |
| | Hello... Can anybody explain me Ebay or something like that database structur.Do All Item Categoris Store in One Table(with Differnt types)or do they story in many table .ex books for one table,jewellery in another table and so on.if they are store in differnt tables how do we search them ? … |
| | Hi, I am new to yii and php and i want to deleveop a database design for school exam time table and maintain the time table for school management. How can I procced the same? Please help me? :( |
| | On my view I am trying to get it so if my input link[] is next to the upload button then that link post will be inserted into the database with image I use codeigniter for a mvc frame work. I can insert the links and images fine, but the … |
| | I have a custom php function for my multiple upload function. I cannot figure out how to make it so when I insert the file name to the database that it matches the row id, of that insert. How can I make it so. When I create a new banner … |
| | Hi all, Im starting to use composer, and have installed a few packages - This thread is about illuminate/database component. Im clearly misunderstanding something about how i can use the autoloader. I have the following directory structure: -app -assets -vendor index.php [Request goes to index.php] - This file includes composers … |
 | i have start learning Bootstrap to design my first Searching Website and i use dropdown list for filter topic what user need to search and input text box for key word (like this pic http://upic.me/i/zl/9aaaa.jpg) This below is my code <!-- Search Container--> <div class="container" id="searchBar"> <div class="row"> <div class="col-xs-8 … |
| | I'm making a kind of address book thingy and seem to have confused myself on the best way of organizing the tables. At the moment, I have two tables, Contact and Number. Here's a basic representation of my tables: ___________ | Contact | |-----------| | cid | | fname | … |
 | i have build a project where wordpress themes can be purchased. Build with Codeigniter how to implement multiple coupons for a single Theme / Item for % discount. i need some help regarding database design. |
 | # Introduction # It allows all programs to potentially operate on data managed by this engine. Its structure is similar to Windows Registry with a difference, that it also supports BLOBs and its size is not limited. It could be used instead of filesystem directly. The equivalents of registry keys … |
| | I where to create a report from a mdf database-file. I have named the columns 1 - 70 for the simplicity when reusing the same code in several methods. But when I am to create the report is says that the column name is not cls compliant? How do I …  |
The End.