11,093 Topics
 | |
 | hey guys! this is my first post to daniweb. and also i've not been so long on php. i m trying to manage customer transection records but stuck on one place and i need help.. here is my mysql table for transection of customer id-1 => +-----+------+----------+--------+------+-------| | svn | … |
| | Hi all, I am very new to php and am slowly trying to get something together. I have a MySQL database with a table that has (among others) a field which is TINYINT called "field1". I have managed to be able to store a 1 or 0 in it from … |
 | Hey I'm new to the website but I've been a friend of Dani for a little over a year and attend the DaniWeb meetups. I know I'll need coding help and as a noob I'll be seeking out the help of you experts in javascript w/ jquery & ajax, php, …  |
 | Hi everyone, Please help me to register the sql query exceutor in netbeans and java. I am using ireport 5.5.1 and netbeans 8.0 with jdk 8. The problem is that when i run the reports within netbeans, they run but when i build the project and run it from a … |
| | hey so im trying to save data but i get error: `You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'WHERE event_id = '8'' at line 1` this being the line: `$sql = mysql_query("INSERT … |
 | Hello everyone. I have juste started creating my website and I need some help. I have found a thread about this subject but it have been dead since three months back so I didn't get what I wanted from there. What I need help with is: I want to create … |
 | Hello world, I'm developing two applications: 1. Chat room 2. Forum The two are under the same domain : **chat_room**.ask.com and **forum**.ask.com What I wanna do is this, I want users who login to the forum to at the same time use the chat room without login in again...just like … |
| | here i have to store comapnyname,contactperson,city,place,maincategory,subcategory values.but i have 4 tables with data's like maincategory,subcategory,city,place. so how can i store the below data's in table.in spa table i added maincategoryid and cityid is enough or else these city and category i have to store in another table. please give some … |
 | i have a database 'phar' which need to subract its values 'stk' through the request made and gets updated to the db. i used arrays to do subraction.. but not able to store back the values to the db in its position.. my calculations work perfect, but not able to …  |
| | Im trying to delete from multiple tables using full outer join like this: $del_id = (int) $del_id DELETE contact, child, spouse FROM contact FULL OUTER JOIN child ON child_name = c_name FULL OUTER JOIN spouse ON s_name = name WHERE contact_id = $del_id I get warning/notice: unknown table contact in … |
| | I am new to Qt and I'm trying to connect a remote database. QSqlDatabase db = QSqlDatabase::addDatabase( "QMYSQL" ); db.setHostName("IP ADRESS"); // local or IP db.setPort(3306); // Default port is 3306 db.setUserName("DB USER"); // example root db.setPassword("PASSWORD"); db.setDatabaseName("DB NAME"); if( !db.open() ) { qDebug() << db.lastError(); qFatal( "Failed to connect." … |
 | How to select image from folder by name in mysql. This is mysql query for other rows $query = "SELECT `posts`.`id` AS `post_id`, `categories`.`id` AS `category_id`,`title`,`contents`,`date_posted` ,`categories`.`name` FROM `posts` INNER JOIN `categories` ON `categories`.`id`= `posts`.`cat_id`"; how to select row 'image' where is name of image and call that image from … |
| | Who can help me with the folowing I have javascrip variable and a php datatable And i wand to read the datatable with the javascript variable here is the code i have if(!isset($_POST['bewerk_gegevens'])) { ?> <script language="javascript" type="text/javascript"> var newland = document.getElementById("geboorte_land").value; if ((newland != "" && newland != "Duitsland") … |
| | Is there any syntax error in this code or query because i am not getting the required report? I have created a JFrame with JDatechoosr. When i select the dates and click view report, it gives me empty report while i know there is data within the specified date range. … |
 | I am trying a query in mysql. I have 3 tables which are linked by the same foriegn key ... Table 1 = students (PKey - stdnt_rfid_tag) Table 2 = student_attendance ( FKey - s_id for stdnt_rfid_tag ) Table 3 = users ( Fkey - s_id for stdnt_rfid_tag) In the … |
 | I cant log in to wamp server although i get in the phpmyadmin. When i try to open my project i get access denied for user 'root'@'localhost' (using password yes) |
 | Cek this syntax: root@ubuntu:/opt/lampp# ./lampp startmysql XAMPP: Starting MySQL...ok. root@ubuntu:/opt/lampp# ./lampp status Version: XAMPP for Linux 1.8.3-3 Apache is running. MySQL is not running. ProFTPD is running. I already start mysql yet it's still unable to run. Why is it?  |
 | Hello to everyone. I have this table: CREATE TABLE `documents_category` ( `id` int(11) NOT NULL AUTO_INCREMENT, `parent_id` int(11) NOT NULL, `title` varchar(255) COLLATE utf8_unicode_ci NOT NULL, `description` text COLLATE utf8_unicode_ci NOT NULL, `active` varchar(255) COLLATE utf8_unicode_ci NOT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=37 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; I am trying … |
 | I have two problems with this code. 1. when i refresh the page it uploads the file again. 2. how to i validate the form if required fields are not filled ? i have added the code validation but its not working and there are no errors. <?php if (isset($_POST['upload'])) … |
| | I am trying to add a Mysql Report to Reporting Server. I can call the stored proc and all the info appart from the date will show. So i was wondering if there was a way to do convert the date in mysql |
| | I have two different format of code for insert query using jsp+servlet+mysql. Code-1 ====== Class.forName(JDBC_DRIVER); // Open a connection out.println("Connecting to a selected database..."); con = DriverManager.getConnection(DB_URL, USER, PASSWORD); out.println("Connected database successfully..."); // Execute a query st = con.createStatement(); sql = "insert into users (name,email,password) values ('" + name + …  |
| | I am currently trying to link a mysql Stored Procedure to a Microsoft SQL Reporting Server. It is coming up with a Syntax error. I believe this is down to the Date_from and Date_to Parameters. The query is below any help would be appreciated DELIMITER $$ USE `mydb`$$ DROP PROCEDURE … |
| | I was wondering if there is any way to do a single mysql query to do a count of filled positions in a multi-level structure to an indefinite depth. That sounds a bit cryptic, but this is what I would like to do if it is at all possible. we …  |
 | |
 | Hi guys, Got a problem uploading an image to a directory and then including that directory location into the database so that I can display the image. Here is the code I have so far. <div id="main_right"> <?php if ($picture) { ?> <img src="<?php echo "../images/teacher_photo/" . $picture ?>" alt="<?php … |
 | Im doing a query and Im getting this: Error Code: 3. Error writing file '/tmp/MYYQVeZr' (Errcode: 28) Its not a space issue or a permission issue either:  Whats wrong? |
| | Simple timediff: SELECT time_format(timediff('2014-04-24 09:11:37','2014-04-24 09:09:37'),'%H:%m:%s') as dif Returns 00:00:00 . Im problably missing something stupid, my apoligies... |
| | I'm trying to add some mysql table columns to JSF table. And I'm getting error: /index.xhtml: The class 'logon.User' does not have the property 'description'. Please help User.java package logon; import javax.persistence.Column; import javax.persistence.Entity; import javax.persistence.GeneratedValue; import javax.persistence.GenerationType; import javax.persistence.Id; import javax.persistence.Table; @Entity @Table(name="users") public class User { private int … |
 | I created a Virtual host using WAMP Server.Its working.But its DB connection not working. <VirtualHost *:80> ServerAdmin webmaster@kiwitravel DocumentRoot "c:/wamp/www/kiwi ServerName kiwitravel.localhost ErrorLog "logs/kiwitravel-error.log" CustomLog "logs/kiwitravel-access.log" common </VirtualHost> DB Connection class Database { const DB_HOST = 'localhost'; const DB_USER = 'root'; const DB_PASSWORD = ''; const DB_NAME = 'admin_kiwi'; public … |
| | Dear All, im testing out a way to get data from database depending on the drop down selection and displaying the data into a table by using php. now my first issue which is really really frustrating me because i've done this dozens of time is that i get `Notice: … |
| | I have a bunch of insert querys running and some of them fail with a duplciate entry. I want to see a log where it says "Error: Duplicate key" and that tells me the EXACT INSERT query that fails so I can see what keys are duplicated. Thanks |
| | I was taking a tutorial on PDO with PHP and MySQL and noticed I could not generate an exception from this code. I wonder what setting I need to put in place to generate the exception. If I shut down MySQL I can generate an error but with MySQL running … |
| | Hi i have this image upload script, its giving me errors. this script should get description of the image from user and upload image to database. please someone could take a look at my code. i really messed up the code. i am puzzled now. <?php if(isset($_POST['upload']) && $_FILES['userfile']['size'] > …  |
| | here i want to generate a graph using highchrats library.my graph is spline with column chart (combo chart).but my graph not generate with my code.so please check my code where is i am wrong.i think i am wrong in jason code..but i have a little bit knowledge in json .so … |
| | I have a table that will have several fields, such as counties, age_groups, gender, sports, etc.. on countries I will be storing data with this format["US","CA","DK","FI","RU","SE"] on age groups I will be storing data with this format["2000","1999","1998"] on age groups I will be storing data with this format["M","F"] on age … |
| | I have in a MySQL database with the column type being DateTime the following time: Timestamp: 9:34:09 9:34:23 9:34:45 9:34:50 9:35:09 9:36:17 But a DataGridView in C# only shows me 9:34 9:34 9:34 9:34 9:35 9:36 Why? |
 | Look, Im pretty new to php and sql and need some help. Im trying to make a database that can store contact details of potential customers that are interested in a specific category. My problem is inserting muliple checkbox data into the database. My PHP and form (all in AddContact.php) … |
| | I insert something simple like insert into table(pri1,pri2,value) values (1,1,1); insert into table(pri1,pri2,value) values (1,2,1); And in MySQL 5.6 they show up as: pri1 pri2 value 1 1 1 1 2 1 BUT In MySQL 5.1 I do the same thing and they show up as: pri1 pri2 value 1 … |
| | Hello Sometimes I get a duplicate key which I want to ignore or discard. This is a example and has nothing to do with the actual query. I simple want to state columns/values insert into table(Time_Stamp,Time_Stamp_ms,p1) values (time,timems,'1') Where the first two are my PK. I see that insert into … |
| | I found a php class that seems to help me achieve my objective of doing an advanced search of my database <?php class search { var $table; var $field1; var $field2; function queryRow($query){ //define database settings define("host", "xxxxxxxx"); define("login", "xxxxxx"); define("senha", "xxxxxxx"); //define database name define("data", "xxxxx"); //conection routine try{ … |
| | Hi I have one issue. I do not know how to solve and also no idea. It is my scenario. I have Product table with details,selling price, purchase price and so on. I want to invoice to clients. Clients can buy lots of item in single invoice. If I select … |
| | I am new to java programming and I just created a simple program that connects to a mysql database to update a Jtable right on my laptop. Now I want to install the program on my friends laptop and we want to share the same database. Do I have to …  |
| | Hello i am creating a small project. is there any tutorial that could help me . i have image gallery. it has main categories and then sub categories , i want to upload the images to respective sub category under main category after choosing categ and sub categ from list … |
| | Hey there. I'm building a project in PHP/MySQL and it is a sort of [FaceMash](http://en.wikipedia.org/wiki/History_of_Facebook#Facemash) project. I am able to call the images (with image name and points) from the database. I have managed to use the MySQL Update query in order to increase the points that each image gets …  |
| | Hi guys I know this might be a repeated post, someone has looked at the code and they seem to think that it all look fine, but I'm getting this following message again Warning: mysqli_query(): Couldn't fetch mysqli in C:\xampp\htdocs\submit-form.php on line 19 The following SQL Failed INSERT INTO 'users' … |
| | I decided to use the stored procedures in MySQL. I am able to retrieve only one row value in OUT paramater, but when the returned result contains more than one row, I get nothing! Please see the simple code below for stored procedure which I add it to phpmyadmin direct: … |
| | file.php?sub=3&main=10&date=2010-04-20 sub value has max 3 and main has max 10 , can anybody tell me how many tables or columns this website has ? |
| | I have problem with this code show mi error Warning: mysql_result() expects parameter 1 to be resource, boolean given in C:\wamp\www\blogcode\resources\func\blog.php on line 34 function category_exists($name){ $name = mysql_real_escape_string($name); $query = mysql_query("SELECT COUNT(1) FROM 'categories' WHERE 'name'= '{$name}'"); return (mysql_result($query, 0)=='0') ? false:true; } How to fix this problem? |
 | I use Visaul Studio 2012 and MySQL database I have a unbound datagridview with a DataGridViewImageColumn, name of column is "Picture1". I want to Save the Image from the DataGridViewImageColumn into MySQL table fields name "Pic1", field type is "Blob" How can i do that. Thanks for your help. Andre |
| | I have done task management software using php.now I would to like to write a php code to(restrict) set deadline date and time in users taskmanagement page by admin.Deadline date already entered by admin in the database.if the deadline date expired the user cannot access his task management page and … |
The End.