10,946 Topics
 | |
 | I am currently creating a MySQL back-end database system and have come across a problem. Whilst building my ERD, I have noticed that one table requires 3 Foreign Keys. Is this acceptable database design? Thanks for all your help |
| | I created two dropdown which is filled with data fetched from mysql database by using the ajax and php function, Second dropdown is dependent on the first one and show relevant data. I placed both dropdown in adjacent to one another in table cell format. For the first row the … |
| | Hello All, I wonder if someone could help me, I'm about to start work on a pretty heavy system that will be massively database driven. I was wondering if there was a framework out their a bit like jQuery for example that will assist me in all my MySql funcitonality. … |
| | Hello everyone, I have 1 raspberrypi and 1 windows server which already has mysql (phpmyadmin) inside it. I need to insert data by using a python script inside the raspberrypi (I work from the raspberrypi) but the data must go to the windows server (it doesn't work yet), the point …  |
 | when i click upload button, it takes long to load wthout csv, but when i upload csv it dispays csv pocessed..but there is no data uploaded...what could be the wrong with my code?...please assist me <form enctype="multipart/form-data" method="POST" action="" > <input type="file" name="file" /><br /> <input type="submit" value="upload csv" name="submit"/> … |
| | Hello, my website is created almost intirely in php, its dynamic and we have everything working under mysql database. It has printable cuppons for free, the coupons are inside a form, everything works perfectly. Now im trying to find a (php preferably) script that will count how many times that …  |
| | |
| | As some of you might know I'm working on a movie database to help track my movie collection. For a while I was having trouble getting the output I wanted for that, but I finally figured out some sql code to help with that problem. I'm going to be working … |
| | how to update /delete and search in datagrid using mysql database? |
 | I have been racking my brain trying to think of how this would work to no success. Can anyone explain how this could be done? |
 | Hi all, I am working on Bank Management System,,i wanna connect my programm to MySql Can anyone refer me Book(s)/links where i can learn so...i have know how of Mysql already and worked on it  |
| | Complaint table id company_id user_id source id=coplaint_id user_id=user which filed complaint company_id=complaint againt company source=source of complaint I am trying to get user_id who have filed complaint via same user_id and against same company. one user can filed multiple complaints against same/different company  |
 | Hi, I'm currently working on a site in which a user basically clicks a button repeatedly, gaining 1 extra point each time he clicks it. Anyway, I'm trying to do a MySQL update so that when the button is clicked, it updates his score in one of the MySQL tables: … |
| | My dear friends, I'm stuck in the middle of my project because I'm unable to figure out how this problem could be resolved. I have to implement a time constraint ( admin supplied ), MCQ type of quiz with a fixed structure of only 4 options which is to be … |
| | Hello, I want to insert single or double quotes into mysql without using \ or anything else i tried mysql_real_escape_string but it did not work it gives SQL Syntax Error : Check what to use near error...Plz Help... Here's the code... [CODE]<?php $name = isset($_POST['name']) ? $_POST["name"] : ""; $description … |
| | A Database Error Occurred Unable to connect to your database server using the provided settings. the above error am getting when i load the localhost and my database.php and db_driver codings are given below $db['default']['hostname'] = "etc.com"; $db['default']['username'] = "etc"; $db['default']['password'] = "etc@etc"; $db['default']['database'] = "visiting_link"; $db['default']['dbdriver'] = "mysql"; $db['default']['dbprefix'] … |
 | I am trying to search a mySQL database in PhP using POST, but I get these errors: **Notice:** Undefined variable: ban1 in /Applications/XAMPP/xamppfiles/htdocs/bans.php on line 266 **Notice:** Undefined variable: banner1 in /Applications/XAMPP/xamppfiles/htdocs/bans.php on line 268 **Notice:** Undefined variable: bantl1 in /Applications/XAMPP/xamppfiles/htdocs/bans.php on line 270 **Notice:** Undefined variable: banreason1 in /Applications/XAMPP/xamppfiles/htdocs/bans.php …  |
| | hey buddy's, i'm creating the program of employee details and i will inserted the fields are ADD,UPDATE,DELETE,EXIT,. I hope the all thing to find the exact solutions but, particular one thing only, that was UPDATE and these are the following some tips and code: 1.the input is not going store … |
| | I am using MYSQL and php version 5.4.16.My table structure is as given below. I want to sort the temp_id cat_id and colors based on the cat_id as given in the second table. The com_id same values should not come at once. My Table is something like this: col1 col2 … |
 | Recently I've need to do some table repair and got into my variables and noticed some bizzare numbers. For those of you that know MySQL, these may be familiar to you, so I'll just list the variables and values: max_join_size: 18446744073709551615 max_seeks_for_key: 18446744073709551615 max_write_lock_count: 18446744073709551615 myisam_max_sort_file_size: 9223372036853727232 myisam_mmap_size: 18446744073709551615 The … |
 | Hello there.. I want to backup my database (MySQL) using a command button in VB6...How can I do that? thank you for answering... :) |
| | Im using LOAD DATA INFILE to import a csv file, the files date format is 29/11/2010 and the database format is 2010-11-29, what can i use to format the date inside the query? I've tried str_to_date: `SET date_start = STR_TO_DATE(@from_date,'%Y-%m-%d'),` but that only inserts 0000-00-00  |
 | I have a project that must have centralization of databases that will have access to the web on a PHP script. I can merge MSSQL and MySQL databases if and only if they were both: 1.) On a same server or 2.) Of the same server type The problem is … |
 | Hey everyone, I'm looking for a free tool to administer MySQL databases. I currently use PHPMyAdmin, which is great, but I'm looking for the same functionality in a desktop software. I've actually found quite a few, but wondered if you any of you could recommend one for me. My only … |
| | <?php include 'connectMySql.php'; $emri=$_REQUEST["emri"]; $mbiemri=$_REQUEST["mbiemri"]; $email=$_REQUEST["email"]; $data=$_REQUEST["data"]; $ora=$_REQUEST["ora"]; $nr_persona=$_REQUEST["nr_persona"]; $query="INSERT INTO rezervim(emri,mbiemri,email,data,ora,nr_persona) VALUES(' ".$emri." ',' ".$mbiemri." ',' ".$email." ',' ".$data." ',' ".$ora." ' , '".$nr_persona."')"; mysql_query($query) or die(mysql_error()); mysql_close($conn); ?> |
| | i have a problem,i log in even though im not registered in database, please help me urgent!!!!!!!!!!!! |
 | Hey I want to make a backup and restore of a MySQL **SERVER** to another machine. Please note the **SERVER** part; I want to backup/restore datebases, tables, procedures, users, configuration, etc....**EVERYTHING** What is the best way to do this? Thank you |
| | this front page: Form.jsp <html> <head> <title> Data Inserting Form </title> <meta http-equiv="content-type" content="text/html; charset=iso-8859-1"> </head> <body> <h1>ENTER THE EMPLOYEE DETAILS</h1> <form action="./Insert.jsp" method="post"> <table cellspacing="5" cellpadding="5" border="5"> <tr> <td align="right">Employee Name:</td> <td><input type="text" name="EmployeeName"></td> </tr> <tr> <td align="right">Employee_id:</td> <td><input type="text" name="Employee_id"></td> </tr> <tr> <td align="right">Nationality:</td> <td><input type="text" name="Nationality"></td> </tr> …  |
| | I have an accommodation reservation system that allows managing agents to list all the properties under their control. There are various 'locations' that have a priority such as:- 'Beach Front' has priority of 1 and 'Off beach' a priority of 2 etc. Setting these are pretty much a straight forward … |
| | <?php include 'connectMySql.php'; if(! $conn ) { die('Could not connect: ' . mysql_error()); } $sql = 'SELECT * FROM users '; $result = mysql_query( $sql); if(! $result) { die('Could not get data: ' . mysql_error()); } while($row = mysql_fetch_assoc($result, MYSQL_ASSOC)) { echo "ID : {$row['id']} <br> ". "USERNAME : {$row['username']} …  |
 | Successfully calculated TotalTime a person has worked and overtime he has done if total working time is greater than 08:00 but if not greater than it puts duration of time person has not worked in Overtime column BUT NOW overtime column should display that time in proper negative format e.g. … |
 | I am creating a site and I am trying to put all the posts within a mysql database (phpmyadmin). How do i put articles/posts in the DB? |
 | I am trying to do a count of all types in there(hardware and software) I thought i had the correct structure...but I guess i am wrong... $count = mysqli_query($mysqli, "SELECT COUNT(*) AS total_count FROM assets WHERE cust_id=$custID AND (asset_type='hardware' AND asset_type='software') "); echo mysqli_error($mysqli); $count = mysqli_fetch_object($count); $count = $count->total_count; … |
| | I have the following query which joins 5 related tables to get the desired result set of 10 rows, I did my best to solve the issue by adding indexes and re-writing the query in many different ways but I ended up either unexpected result or a very slow query. … |
| | I want to be able to insert the data from a range function into mysql table the range values comes from 2 textfields that are user inputted, for example the user inputs 1 and 50 the range function generates numbers from 1 to 50 in an array, my problem is … |
| | Hi I"m sorry that there is no code, it's just a question in my mind .. How can I sort the request results as rows.In every row 4 results then the next row 4 results and so on.? |
| | While extending a mysqli class, I ran into an issue with binding parameters. I've read that db names and table names should not be used as parameters, but while I was pondering this statement... SELECT SCHEMA_NAME FROM INFORMATION_SCHEMA.SCHEMATA WHERE SCHEMA_NAME = '$dbname' I thought, as the db name is a … |
| | Hello! I'm needing some help integrating HighCharts into my CodeIgniter application and getting data from my MySQL database! I've followed a YouTube video on actually integrating HighCharts and it was extremely straightforward. However, that method included a hardcoded array and I'm needing to generate an array from data stored in … |
| | While learning php I found this common statement $add_tel_sql = "INSERT INTO telephone (master_id, date_added, date_modified, tel_number, type) VALUES ('".$master_id."', now(), now(), '".$safe_tel_number."', '".$_POST['tel_type']."')"; What I do not understand why in the '".$master_id."' we are using the " and also the dot. why we do not only use $master_id without … |
| | I'm retriving a youtube link from mysql db with this code <?php //echo $embed; $yt_url=$embed; function get_youtube_id_from_url($url) { if (stristr($url,'youtu.be/')) { preg_match('/(https|http):\/\/(.*?)\/([a-zA-Z0-9_]{11})/i', $url, $final_ID);return $final_ID[3]; } else { preg_match('/(https|http):\/\/(.*?)\/(embed\/|watch\?v=|(.*?)&v=|v\/|e\/|.+\/|watch.*v=|)([a-zA-Z0-9_]{11})/i', $url, $IDD); return $IDD[5]; } } $variable= get_youtube_id_from_url($yt_url); ?> and extracting the id part of the link and placing it in …  |
| | i am trying to generate pdf file using fpdf selecting data from two different tables i.e. table custreg and table slabpay, but getting MySQL error: "Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in D:\inetpub\vhosts\kisan.net\httpdocs\greengold\exportpdf.php on line 124". Code: $strSQL = "SELECT custreg.mobno1, slabpay.ac_no, slabpay.cust_name, slabpay.install_no, GROUP_CONCAT(`slabpay.install_amt` … |
| | HI Hope somebody can help. My query updates a colomn in tab1 from a row in tab2 but only if a colomn in tab1 is equal to that of a row in tab2. tab 1 has 360000 rows tab 2 has 477 rows The update query runs for ages and …  |
 | i have store an image into my database. but i am unable to display the image what i have done till now is under.... any help will be appreciated. thanks in advance! <? $query="SELECT * from testimonial"; $ret = mysqli_query($mysql,$query); if (isset($ret) && $ret->num_rows>0) { while($row=mysqli_fetch_array($ret)) { $body=$row['body']; $name=$row['name']; $image=$row['img']; … |
| | ClassNotFoundException:com.mysql.jdbc.Driver |
| | [CODE]Hi Friends, I have written a code with some example script for generating report in PDF with PHP and MYSQL. But i am unable to fetch the data from my table. So Please help me to solve this issue. Thanks <?php $today=date('Y-m-d'); $hostname = "localhost"; $database = "bdname"; $username = … |
| | i have managed to code this CSV file and it is working well..the only problem i am getting is the variable error on the form..i get this error ...Notice: Undefined variable: data in C:\xampp\htdocs\helper.php(527) : runtime-created function on line 22 how do i resolve the error? this this my sample … |
| | Hi all, I have an array: [CODE]<?php $product_id = $_GET[id]; //the product id from the URL $action = $_GET[action]; //the action from the URL //if there is an product_id and that product_id doesn't exist display an error message if($product_id && !productExists($product_id)) { die("Error. Product Doesn't Exist"); } switch($action) { //decide … |
| | Hi! Anyone can help me about my problem on HOW TO UPDATE TABLE USING THE CONTENTS FROM ANOTHER TABLE? Thank you in advance for those who can help me. Anyway, I'm using VB.Net 2010 I hope you guys can help  |
| | Hi, I have 5 tables..a.b,c,d,e While doing equi join : 1)a.id=b.id, b.id=c.id, c.id=d.id, d.id=e.id a.id=c.id, a.id=d.id b.id=d.id How internally equi join works.should i need all PK to Join Could you suggest me some tutorial which shows how internally works. |
 | Hello Community, I have recently been having a big of a look into connecting to a database using PDO but I'm not too sure what I should stick with, the normal way to connect to a MySql database or should I start using PDO. What would be better to use? … |
The End.