11,093 Topics
 | |
| | les a user come on index.php page. he sees login form. but he forgot his password. so he click forgot password. on forgotpassword.php page he fills a form. <form action = 'forgotpassword.php' method = 'post'> Username: <input type='username' name='username'><br/> E-Mail: <input type='email' name = 'email'><br/> <input type='submit' value='get password'> <a …  |
| | Hello, I need to create a JDBC that connects to a mySQL database, retrieves the data from a table and displays it into a JTable. I have done this successfully, but have ran into a problem. The initial values I entered into the database (for testing) are permament. If I … |
| | Hi guys, I’ve written an application and I’m trying to utilise a database behind it. I’ve created a mysql database, and table which all appears to work correctly. I appear to have connected to the db correctly too. And hit a bit of a brick wall. As a side-note, within … |
| | Hello, I want to edit record in mysql and ive got problem with UPDATE command its giving me syntex problem here is the code: <?php $con = mysql_connect("localhost","root",""); if (!$con) { die('Could not connect: ' . mysql_error()); } mysql_select_db("dbname", $con); $sql="UPDATE users SET (userid, firstname, lastname, email, username, password, role) … |
| | Hello, I am new in all this and i was hoping you could help me with a little thing so here it is ive got 2 files one is for showing movies from database and there is "delete" button that is taking an a id and deleteing the raw display.php … |
| | Guys, I having problem converting the sql server function to mysql function. It work perfect at sql server now it now working at mysql. Please help.Thanks DELIMITER $$ CREATE Function `pearldb`.`SortingAlphanumeric` ( ColValue NVARCHAR(255) ) RETURNS NVARCHAR(1000) BEGIN DECLARE p1 NVARCHAR(255); DECLARE p2 NVARCHAR(255); DECLARE p3 NVARCHAR(255); DECLARE p4 NVARCHAR(255); …  |
| | That is my query. I am trying to select the item details for the items the user has in their inventory, but I DO NOT want to select the ones that are in their collection. So I'm trying to say where item_id IS NOT in the user_collection with their user … |
| | Hello, I try to call a header A if a user is logged in, and a header B if a user is not logged in on some pages I haven't managed to do so, I've tried to create a php function, but didn't manage to make it work. Then, I … |
| | i am using MySQL database. i have one field PurchaseDate. i want following result e.g. : PurchaseDate between May-2010 and Aug-2011 pls help me to solve this problem. its urgent. thanks in advance.... |
| | Hello, I'm trying to get results from a mysql database based on values in an array. My tables look like this 1. id | articles | thumbs | etc 2. tag_id | tag_name | article_id I'd like to get related articles based on the tags for that particular article. So … |
| | Who can help me with the following. a part of my code doesn't work and i do not know wy. <?php //from here it is working $con = mysql_connect("localhost", "bla", "bla"); if (!$con) { die('Could not connect: ' . mysql_error()); } mysql_select_db("wordpress", $con); $sql1 ="CREATE TABLE IF NOT EXISTS stamboom_landen … |
| | When i Connect to Mysql using TURBO C++,im getting error unable to open include file mysql.h mysql_version.h mysql_con.h mysql_time.h i added the include files and set path . even then im getting error . help me :( |
| | Hi there, I am making a spell checker program with php with words stored in mysql. I use it to check unicode languages. But I do not get good suggestions with similar_text with percentage above 82. But if I decrease this percentage, I get many useless words. How can I … |
| | I have a starting query that displays appointments and I am trying to expand to get different statistics: SELECT apt.user_id, apt.appt_id, apt.client_id, apt.time_start AS stime, FROM_UNIXTIME(apt.time_start,'%Y-%m-%d') AS ftime FROM tl_appt apt LEFT JOIN tl_rooms r on r.room_id = apt.room_id WHERE apt.appt_id IS NOT NULL AND apt.appt_status_id = '3' AND FROM_UNIXTIME(apt.time_start,'%Y-%m-%d') …  |
| | Hello! how can i sync or replicate my 2 db's on localhost xampp on windows. I want to replicate themselves as customer order something on my site and i am able to update his order and criteria as aearly as possible and also for security purpose. That if incase any … |
| | Hi I pull data from a MYSQL database to populate a Drop down <td class="<?php print $Bank_ca_error;?>">Bank Name</td> <td> <select name="Bank" id="Bank" tabindex=24 style="color: <?php print $TextColour;?>"/> <option><?php print $_SESSION['Bank_ca'] ;?></option> <?php //Get Data to populate drop down $BankQuery = "SELECT BankName FROM tblbank ORDER BY BankName"; $BankResult = mysql_query … |
 | **Hi guys** I’m new to this site and i really need a professional help out here. I am trying to make a search form in my page and basically i can search my database already but i need to revised the code because the process of my **search form depends …  |
| | I have scoured the web for the answer to this question. I am a nubie to PHP so the answer may be simple I just don’t see it. I’m trying to dynamically create two drop down menus from the results of one query. Sounds simple enough but I want to … |
| | hi, just want to maek sure some thing. so i have a table called user. in user table i want to add a field called date of birth. but i dont know which type to choice. it has int, varchar, date, datetime etc. but no date of birth. do i … |
| | hello all I try to store DateTime to mysql , but when i open the table in mysql command line I see that the hour is decrease 12 by it self , why this can happen ,? my insert command is insert = "Insert into Table1(DtIn)values('"+ hin.ToString("yyyy,MM,dd,HH,mm,ss")+"')";; hope someone help … |
| | [CODE] import java.io.IOException; import java.io.PrintWriter; import java.sql.Connection; import java.sql.DriverManager; import java.sql.ResultSet; import java.sql.Statement; import java.lang.NullPointerException; import javax.servlet.ServletException; import javax.servlet.http.HttpServlet; import javax.servlet.http.HttpServletRequest; import javax.servlet.http.HttpServletResponse; import javax.servlet.http.HttpSession; /** * * @author Animesh Pandey */ public class anilet extends HttpServlet { protected void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException { response.setContentType("text/html;charset=UTF-8"); PrintWriter … |
| | I am developing an java application for for login autentication form, I have pre saved username and password in my database. When admin enter his credetials, it validates to my DB and gives access to actual application Now, my application is used by admin and database is managed by DBA. …  |
| | Hi , I am trying to display images stored in database. Actually, i have stored image names with extenstion in the database, images are stored in my root directory images folder. Now i want to display all the images with other filelds in that table, in same page. I have … |
| | I have two tables namely student and subject joined by a table called student_subject. With the following structure student: +----------------+--------------+------+-----+---------+----------------+ | Field | Type | Null | Key | Default | Extra | +----------------+--------------+------+-----+---------+----------------+ | student_ID | int(11) | NO | PRI | NULL | auto_increment | | studentCode | … |
| | Hi, every members, I am Nur, i want make a complete MLM site. i try to MLM Binary tree downline View on php code. it will be difficalt for me to make MySQL database or php coding. please help me any on. i add a link to example: 1) MLM … |
| | actually i dont know where this post is suitable.anyway i need to know how can i set textarea lenth by annotation in the entity class to be stored in the MYSQL(actually 255 < characters).i used JPA. |
| | Hi, I'm wondering if someone can help me with a problem I've been trying to solve for almost a week now which concerns shared ranking (i.e. whilst I am trying to rank things in order of one field, if two or more entries share the same value then they receive … |
| | I'm trying to create a checkbox where the user will select their 'diseases affected: heartdisease, cancer, diabetes' and hit the submit button and will be saved into the database respective columns as as either '1' for yes or '0' for no. I've tried googling for the answer but I can't …  |
| | How do i collapse data i pulled out of mysql? I have a messaging system that shows all messegse between you and another member. <table border='1' width='100%'> <?php $ID = $_COOKIE['idCookie']; $memberid = $_GET['id']; $query = mysql_query("SELECT * FROM `private_messages` WHERE to_id='$ID' AND To_Deleted='0' AND from_id='$memberid' OR to_id='$memberid' AND from_id='$ID' … |
| | Hi, I have a php file that contains the queries as strings. I have wrote the following query: SELECT message_no, sender, destination, time_received, type, reference_no, message FROM messages WHERE message LIKE '%:substring%'; :substring is then assigned a value from $substring. The query works when i run it directly in cmd …  |
 | Hi I have a single search field ' agent_name' in a form which is a dropdown field of data based on the concatonation of 2 fields: reg_fname and reg_lname When I do the SELECT Query though I'm getting a bit mixed up..... The data from reg_fname & reg_lname does not … |
| | Hi, I would like to know how to set a character set once and permanently, since when i alter the character_set% variables that are shown on 'show varables like 'character_set%', when i alter them the next day they are back with the old values? Thank you very much |
| | Trying to do Parameters for Report in Reporting Services from a database that's in mysql . My Where clause looks like this: Where HD_TICKET.HD_QUEUE_ID="6" WHERE HD_TICKET.CREATED BETWEEN [Start Date] AND [End Date] GROUP BY (HD_PRIORITY.NAME) I get this error: ERROR [42000] [MySQL][ODBC 5.1 Driver][mysqld-5.1.54-log]You have an error in your SQL … |
| | This is a dumb question, but I have honestly spent a long time today trying to figure it out, and I'm sure I'm not the only one who has trouble with this. How do you import a CSV directly into a MYSQL DB? I've tried using [CODE]LOAD DATA LOCAL INFILE … |
| | i created a dll file using vb.net then it has a shared function that will execute a stored procedure of mysql but my code is something long and when accessing it, it has a big risk that it can produce an error if there is an incorrect string input, i …  |
 | Hello, can some one help me with the below code? I am trying to create a multiple image upload form that displays the images. I want to save the image name into my msql database and save the actual image into a folder in my dirrectory. <?php define('UPLOAD_PATH', $_SERVER['DOCUMENT_ROOT'] . … |
| | Hi, I'm passing through hard times in d hands of this. I have created my database and i'm having issues replacing the content of my database table with the values i.v posted from my form. Please someone shld help Moi. |
| | So let me start by saying that I am a complete beginner when coding in C++ windows/forms program. I was able to get my SQL database connection up with my program. I've ran some simple tests and it looks like my program is able to do simple queries such as … |
| | Good day! I would like to ask on how to transfer the contents of JTable to mySQL database. I have seen a lot of codes of putting contents to JTable from database but I need to know the other way around. ^^" I do not have any idea on how …  |
| | Hi guys, I'm quite unsure of what i'm doing here and could use some guidance. I've searched but haven't found any links that were focused enough. My objective is to connect my application to a database for the first time. I've never done this before so it's essentially a learning … |
 | Hello, I've built a timekeeping aplication from a fingerprint machine with automatic import to db and I'm getting some reports. One report is that I'm getting the employees time if they are late from work. But my table is small with 20.000 entries, but with the following query, the results … |
| | Hey Everyone. Im using jquery's Validation plugin to check post values before I submit a form. Im trying to check a mysql table column to match user name to check for a duplicate name before submitting. This snippet of code below works as expected.. [CODE]<?php $request = trim(strtolower($_REQUEST['login'])); //sleep(2); usleep(150000); … |
| | I'm not very good with php or mysql so I can't figure out what I'm doing wrong. I get this error: Failed 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 'tests,'20120508,'5.5,'20120508)' at line … |
| | halo guys, I having problem executing the SQL statement in the visual studio but when in the MySQL it work fine. Here are my code. Dim sql As String = "SELECT * FROM (SELECT @row:= @row + 1 AS rowNum, std.* FROM Student std ,(SELECT @row:= 0) r) AS t … |
| | I know there are multiple variations of this question here, but not in this form. My Ledger table, in a basic form have the following columns. TransactionID | DateOfEntrydate | TransactionDate | ClientID | TrIsDebit | OpeningBalance | Amount | ClosingBalance DateOfEntry is a colums which stores time of insert … |
| | Hi there, I am looking for help to code a php mysql search form with 4 dropdown list. I want the user to search for accommodation establishments by using a citytown, tourism route, accommodation profile and accommodation tariffs. All this will be in the dropdown list which reflects the fields … |
 | Hey guys. Can you have a look at my queries? I can't spot the error with my foreign key linking. As of now, the table staff has already existed: StaffID char(7) Staff_Name varchar(50) Position varchar(50) And now I'm trying to create a new table called SalesInvoice: create table SalesInvoice( SalesInvoiceID … |
| | The following two are methods of joining two tables together but what I want to know is whether the two methods actually have any differences. I tested the two methods on two tables and they didn't give different results but maybe my two tables were just an anomaly. Are these … |
| | Hi all, Can anyone help me or give me an idea on how export data from mysql into multiple excel sheet using php? Below is the code I used to export data from mysql in a single excel sheet. thanks in advance [code] <?php $filename = 'filename.csv'; include 'connection.php'; $date …  |
| | Hi, Daniweb I have this code that works like this: i search for a product and it gives me the name, reference and the image of the product found. My problem is that the image doesn't appear. <?php require_once('Connections/futura.php'); ?> <?PHP $prod=$_GET['q2']; $sql_prod = "SELECT * FROM produtos WHERE nome … |
The End.