11,093 Topics
 | |
| | hello guys, i have created a jform which contains these field; ComboBox_decCode(description code) ComboBox_itemCode(item code) combo_Area(Branch_Area) ComboBox_dept(Branch_Code) txt_sn(Serial Number) i want to generate a serial key based on these information in my database. Description Description_Code --------------- ---------------- Lands & Building LB(001) Branch_Area Branch_Code ------------ ------------- Labone LB(001) now the idea … |
| | Can anyone please help I'm having an index error with my php code. When I run the code I get the errors Notice: Undefined index: name in C:\Program Files\EasyPHP-5.3.9\www\Authentication1\update1_ac.php on line 9 Notice: Undefined index: surname in C:\Program Files\EasyPHP-5.3.9\www\Authentication1\update1_ac.php on line 10 Notice: Undefined index: contact_number in C:\Program Files\EasyPHP-5.3.9\www\Authentication1\update1_ac.php on … |
| | I have a silly issue, I am creating a CMS at the moment. it has pages and menus . I created a page to add new pages. on that page i have a drop down list that is populated with data from the menu. I also have an edit page, …  |
| | Hi, I'm sorry if I had post duplicate post. I had join this 2 table (dt_dict_tbl - store dictionary, sdn5_5 - store accumulate value for reporting). Here the table structure **dt_dict_tbl** CREATE TABLE `dt_dict_tbl` ( `dtDictCode` VARCHAR (30), `dtDictDesc` VARCHAR (600), `rptCode` VARCHAR (30), `rptSubCode` VARCHAR (30), `dtCreatedDate` TIMESTAMP , … |
| | Hi, when I try to use a SELECT statement in php, I get an error: > Resource id #18 <?php include("include/session.php"); $get = mysql_query("SELECT value FROM settings WHERE id=2"); echo $get; ?> The file session.php contains the database credentials .etc and it's correct. But then when I try to echo … |
 | Hello Sir, I have a question that when i feed numerice 10 digit mobile no in the form then it does not feed same as i feed. i took phone no type int(10)and also took different differnt value but in mysql database the value is changing when i feed 10 … |
| | Hi, Need Help regarding a query. I want to search all empName from emp table whose name 3rd letter is "s" |
| | I have connected VB.net and mySQL on a the same PC before, but I have no Idea how to connect VB.net to a remote PC(LAN) I've only changed the server This is my code. I removed some of the details, but it works on server=localhost [CODE] conn = New MySqlConnection() …  |
 | Hello, I am working on a query for a dog agility venue where it's calculating award requirements. There are two columns that are identifiers, one is the RegNum which is the dogs identification number, and the other is Class_Subset, which identifies which class the points were earned under. And then … |
| | |
| | Hi Guys I am creating a site and i want users to be able to upload videos to a folder on a server, using SQL to store the path of the video and the name. I have created this Code. And it does upload all the details, but does not … |
 | Notice: Undefined variable: result in C:\Users\User\Desktop\Desktop\htdocs\trip1.php on line 67 Warning: mysqli_fetch_array() expects parameter 1 to be mysqli_result, null given in C:\Users\User\Desktop\Desktop\htdocs\trip1.php on line 67 <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Strict//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-strict.dtd"> <!-- --> <html xmlns="http://www.w3.org/1999/xhtml"> <head> <meta name="keywords" content="" /> <meta name="description" content="" /> <meta http-equiv="content-type" content="text/html; charset=utf-8" /> …  |
 | I want to make data entry form which inserts data to MySQL. Select (Dropdown) from List A --- Values of dropdown to be populate from database A Select (Dropdown) from List B ---- Values of dropdown to be populated from database B .... .... and so on Select (Dropdown) from …  |
 | I have a temp table that is used in a union. But it resulted an error saying "cant reopen table". I've read that I need to rename the tempTable. How could I rename a temporary table when I'm using the tempTable in a union? |
 | Hello Php Forums! I have a script that has point system. and if you have enough points you can get rewards example usb,tshirts etc.. i already done the function when the user redeem his/her points will be deducted based on how much points is needed to redeem that item. now … |
| | Hi,i have this tblProductAttribute with ProductAttributeID|ProductID|AttributeID|AttributeValue| 1|1|Blue 2|2|medium (AttributeID 1 = Color,2= size) i want to get result from select query like this ProductName|Color|Size sampleproduct|Blue|Medium inshort i need to get row data to be the column name please help me.thanks :-) |
| | Example 1 below works: echo "<p><h2>".$results['title']."</h2>".$results['shortdesc']."</p>"; I need to make the title linkable to the page url. I'm probably putting the ' and " in the wrong places for the link part. Example 2 - I've added the url code but does not work: echo "<p><h2><a href=http://www.example.com/".$results['url'].".$results['title']."</a>"</h2>".$results['shortdesc']."</p>"; Any help would … |
| | Is it possible to populate my Jcombobox with my database column names? the name of my jcombobox is 'jComboBox_AReport' and the db_Table is 'asset_report'. please am still learning so i will appeciate the help THANK YOU! |
| | Hello everyone, this mysql_deprecated works very fine and retrieves information but when i tried moving it to PDO it displays nothing. can someone help me thank you working mysql_deprecated.php <?php require('config.php'); $user = $_SESSION['log']['username']; $sql = "SELECT * FROM users WHERE username='$user' OR friend='$user' AND status = 'accepted'"; $result = … |
| | please do help me to use prepared statement to load the result in datagridview. Please give me some examples.thanks in dvance :D  |
 | Hey everyone, So I am having trouble getting my head wrapped around a php script I need to build. What I am trying to do is pull data from a MySQL database table (dynamic content) and match it to an html table with static content. I guess an example of … |
| | Attach above is my question & answer(not correct) can someone edit it for me :) MY QUESTION : develop an online application called ‘mylibrary’. The purpose my ‘my library’ application is to record all the books that you have purchased. Information that you have to record are International Serial Book … |
| | Hello , I am a new user of this site and also new to web development.Recently while developing my site on tourism by php/mysql i thought of placing a search bar at the top of my website where users can search topics and results would be provided according to the … |
| | Hi I was taught not to use global variables and one of my friend is using global variable for database handle for his website... could you please explain if there is an issue if he uses global variable for database handle? he is using it to access database from anywhere …  |
 | in my db have 20+ columns. i added 19 columns throught input form and stored in db succesfully. i fetch few details from db in my main page. in my main page 1 more column is there. that is status column, it is a combo box. if i click status … |
| | Hi All, Firstly I will say that this exercise is for my learning experiences through an online course. However I have spent a combined total of about 6 hours working on this question and I am completely stumped on how to get the correct answers. The question: > List the … |
 | Hello, is there anyone who could help me to get all databases and their tables in treeview? Please? All i could find is how to get tables only but not all databases from mysql server. Here is some screen that could maybe help out: http://screencast.com/t/6ysNFSlz7 If anyone could help me … |
| | Hi, Below code is working for uploading and insertion in database. How below can be done without Without Reloading the Page. <?php session_start(); $userId=3; //stored userid of current login user from session include("../db.php"); //include db part if (isset($_FILES["csv"])) { $uploadedFile = $_FILES["csv"]; $uploadedFileName = $uploadedFile ["name"]; //name of uploaded file …  |
| | Hi, I want to know that how can I get the timestampdiff return as zero instead of null. For example I have a query in which both dates are exactly same but the query returns me null instead of 0. My query is SELECT (TIMESTAMPDIFF(HOUR,'2012-12-01 11:15:00','2012-12-01 11:15:00')) And this code …  |
| | i stored few values through input form. (for example tax and rate field) if i entered tax = 777.77 and rate = 10000 it stored the details to db successfully. retrieve function also done successfully. but i want to show add these two values(tax+rate = total) from db when i … |
| | i have the db with serial no and reference no. serial no is auto_increment value. it is worked perfectly. but i want ref no column also as auto_increment value start with 0000001,0000002,0000003...., how to do that? i cannot able to add two auto_increment values in mysql.  |
| | OKay so this my have been asked before but I have more of a general question than an issue. I don't understand Mysql_num_rows() becuase I don't have any information within my database table so the number or rows should be 0 but what happens is I get an error and … |
| | I can not access the database with Mysqli_connect(). I have all the correct information into the funciton but it wont let me. This is the syntack that I use $link = mysqli_connect("hostname", "username", "password", "db_name"); I get this error 10-01 22:20:27.182: E/JSON(8700): <br />n<b>Warning</b>: mysqli_connect() [<a href='function.mysqli-connect'>function.mysqli-connect</a>]: (42000/1044): Access denied …  |
| | Hi I am starting my final year project and was wanting to know how to connect visual studio to my database. I am using phpmyadmin which is on the uni's server so I can work on it at uni and at home but I am having trouble finding out how … |
| | i created main.php page. this page includes these following php codes, <?php $user = ""; $pass = ""; $db = ""; $connect = mysql_connect("", $user, $pass); if(!$connect) { die ("Could not connect to MySQL"); } mysql_select_db($db, $connect) or die ("Could not open $db: " .mysql_error()); $sql = mysql_query ( "SELECT … |
 | Hello, I am trying to update 3 tables that i have in my db. the second and third INSERT commands there is a specific field that needs to have the ID of the first table last row inserted. first table, admin: +--------------------+ |id username passcode| |1 admin test | +--------------------+ … |
| | i am making a reservation system and i am having a a problem with time conflicts(the system must not accept a reservation where in there is already an event reserved art that time. . my table looks like this   |
 | **Can anybody help me??? I'm newbie in php, I'm trying to make this code as one below.But it always gives me an error. Any help would greatly appreciated ** my table name is trans ![Fields[1] * *$id = $_POST['id']; if(isset($_REQUEST['command']) && $_REQUEST['command'] == 'update'){ $name = $_POST['name']; $email = $_POST['email']; … |
| | Hi **I have doing the project for my purpose. it is working properly on localhost engine. after i have uploaded to server(cpanel) it is not working. i have posted my code here for reference: Please help me anyone!!!** ** Login.php** `Inline Code Example Here` <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 …  |
| | Hi, I am creating a function in mysql and I want to make the order by and limit section dynamic. What I want to do is to call the function and enter the limit and order by condition dynamic. How can I achieve this. Thanks in advance |
| | Hi, I have a table named as appointment. In appointment there are two fields appointment_date and person_id. There can be multiple appointment for same person. What I want to achieve here is that the date difference of both appointments for the same person should be greater or equal to 90 … |
| | hello i just want to ask if how to echo value/details using this API link that have given - http://themesnmotifs.com/api/wp/f6f60a0e7091a627641f01b9d1dd7536ea4b8496/list_wp - for example i want to echo all the companyand wp_cellphone -- . thank you  |
| | Here i am uploading data through a form which contains some input fields and one image. But i want to upload multiple images here instead of one image. I am attaching my php code here to upload the data and single image. Can anyone edit this code to add mutliple … |
 | Hi, i have successfully stored a link to docx and pdf files into mysql db. I'm trying to retrieve it from db and display it similar to pictures. Now when the user click on it, it should open the file and display it. If any one have a code sinppet … |
| | i want to calculate the depreciation of an asset and i want my accumulated value to automatically add the previous monthly depreciation value with the current one any time the user calculates for the monthly depreciation, the accumulated value should pick the results from monthly depreciation and add it to …  |
 | Hello, Recently I am trying to make a php file than when it is opened it should backup a database and promt the user to save the .sql file... This is a feaure that has phpmyadmin but I want something very simple, just clicking http://mywebsite.com/backup.php and the file should be …  |
| | I have this code $request = mysql_query("SELECT note_title,image_file FROM notez"); while($row=mysql_fetch_array($request)) { echo $row['image_file'].'<br />'; echo $row['note_title'].'<br />'; } and the path to the folder where i stored the files is userimages_doc when i click on note_title , i want to download the file  |
| | I want to populate my jtable with columns from different table in mysql database but it only displays the column names and not the data or information under those columns. i hope this code helps u undertand what i mean. thanks private void Update_table(){ try{ String sql = "select Date_Acquired …  |
| | Hi. I'm confuse on how I will create my temporary table. Need some clarification here. I want to create a temporary table that will hold some column and values. And later on I would alter/update the table to add another column and data with respect to the existing columns. ammm... … |
| | Hi all, i have a table in db which contain some pdf and docx files. Am trying to display it in a way, so that when the user click on it, it will load the pdf and/or docx file from db in another/same window. this is what i have done … |
The End.