10,940 Topics

Member Avatar for
Member Avatar for faisal6621

I'm working on a School's fee management module. The client's requirement is: 1. There are 6 types of fee to be paid: * Annual Fee * Tuition Fee * Exam Fee * Games Fee * Development Fee * Other Charges 2. Only tuition fee will be paid monthly and rest …

Member Avatar for Begginnerdev
0
5K
Member Avatar for Indians

in my project i'm using user input form. that form contains serial no, reference no, name, email, phone, address, etc.., in that user input form serial number textfield is readonly option. user can't able edit the serial number. in that textfield i want to show the next auto_increment id from …

Member Avatar for diafol
0
3K
Member Avatar for Benjamin_4

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 …

Member Avatar for Benjamin_4
0
148
Member Avatar for Queos_1

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 …

Member Avatar for Bukhari1986
0
543
Member Avatar for Folaju

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, …

Member Avatar for sachin.padole1
0
10K
Member Avatar for red_ruewei

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 , …

Member Avatar for red_ruewei
0
470
Member Avatar for BadManSam

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 …

Member Avatar for Derice
-1
413
Member Avatar for kumar89hitesh

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 …

Member Avatar for diafol
0
101
Member Avatar for jacob21

Hi, Need Help regarding a query. I want to search all empName from emp table whose name 3rd letter is "s"

Member Avatar for drjohn
0
195
Member Avatar for yorro

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() …

Member Avatar for nathanl.dulguime
0
3K
Member Avatar for ChopTop69

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 …

Member Avatar for ChopTop69
0
180
Member Avatar for sriramkarthick

what will be result of the following ? "$qry_expirydt="SELECT ('".$stdate."' +INTERVAL ".$day." Month) as expirydt";" especially explain about (+INTERVAL) and (Month) used in the query ???

Member Avatar for pritaeas
0
113
Member Avatar for edotman

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 …

Member Avatar for diafol
0
927
Member Avatar for dean.ong.14

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" /> …

Member Avatar for Assembly Guy
-1
8K
Member Avatar for docamitverma

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 …

Member Avatar for Dean_williams
0
79
Member Avatar for Kewne

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?

Member Avatar for Athelas
0
331
Member Avatar for RonnelQdc

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 …

Member Avatar for diafol
0
208
Member Avatar for bumbumpaw

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 :-)

Member Avatar for urtrivedi
0
205
Member Avatar for actolearn

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 …

Member Avatar for actolearn
0
226
Member Avatar for Benjamin_4

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!

Member Avatar for Matt_5
0
66
Member Avatar for mutago

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 = …

Member Avatar for mutago
0
206
Member Avatar for bumbumpaw

please do help me to use prepared statement to load the result in datagridview. Please give me some examples.thanks in dvance :D

Member Avatar for ddanbe
0
65
Member Avatar for PixelatedKarma

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 …

Member Avatar for PixelatedKarma
0
1K
Member Avatar for son jo

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 …

Member Avatar for Thomas84
0
430
Member Avatar for jazz.viper

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 …

Member Avatar for hag++
1
11K
Member Avatar for t_thakar

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 …

Member Avatar for veedeoo
0
229
Member Avatar for Indians

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 …

Member Avatar for hag++
0
1K
Member Avatar for Gobble45

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 …

Member Avatar for rajkumar007
0
269
Member Avatar for Trle94

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 …

Member Avatar for G_Waddell
0
84
Member Avatar for jacob21

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 …

Member Avatar for JorgeM
0
979

The End.