10,938 Topics
 | |
| | Hi, I have a database table filled with interesting data. On my webpage I would like to let a user pick two rows in the table and compare the data to see how it differs. Picking what rows to compare would be done by two dropdown lists. The data in … |
| | Here is the code for my login page <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"> <html xmlns="http://www.w3.org/1999/xhtml"> <head> <meta http-equiv="Content-Type" content="text/html; charset=utf-8" /> <title>Login</title> <style type="text/css"> #apDiv1 { position:absolute; width:200px; height:115px; z-index:1; left: 608px; top: 201px; } #apDiv1 form table tr td { font-family: "Trebuchet MS"; } </style> </head> … |
| | My table (employee) has this description Field Type Null Key Default Extra Emp_id int(4) NO PRI Null Emp_name varchar(20) YES Null Mgr_id int(4) YES Null Hire_date date YES Null Salary int(5) YES Null Commission int(4) YES Null Dept_id int(3) YES Null I ran this query alter table employee modify Emp_name …  |
| | I am trying to add an username and password into a database using JSON. I cannot get it to work, any ideas? Thank you. <?php mysql_connect("localhost","sdr001","************"); mysql_select_db("tristate"); $userID = $_POST['userID']; $password = $_POST['password']; $q=mysql_query("INSERT INTO users VALUES(>'".$_REQUEST['userID']."'"); while($e=mysql_fetch_assoc($q)) $output[]=$e; print(json_encode($output)); mysql_close(); ?> |
| | Hey. So here is my code... config.php <?php $localhost = "localhost"; $dbuser = "root"; $dbpass = ""; $dbname = "test2"; $connect = mysql_connect($localhost, $dbuser, $dbpass); mysql_select_db("$dbname", $connect); ?> regprocess.php <?php include"config.php"; $username = $_POST['username']; $email = $_POST['email']; $password = md5($_POST['password']); $insert = 'INSERT into users(username, email, password) VALUE("'.$username.'","'.$email.'","'.$password.'")'; mysql_query($insert); ?> …  |
| | I have this form that i need to save on Mysql database but i'm stuck on what I should do. This form needs to be done every 3 or 4 months. Every saved information stays saved in a row. This form has alot of radiobuttons,textboxes and comboboxes that I save …  |
 | I have city and its corresponding locality. City is showing dropdwon and Locality in Dropdown-Checkbox I got code Dropdown-Checkbox, when user clicks city then its locality will show in Dropdown-Checkbox. It is showing multilist control in thepage but when I choose city it is showing multilist-box rather Dropdown-Checkbox. How I … |
| | Hello Everybody please help me out i am in big problem the problem is my organization people gave me the WEB Application to edit it (the application was written in the C# language and it is web application so it is designed in ASP.NET MVC3 ) and i have to … |
| | Hi. i was wondering if somebody could help me. Im looking for a php function to check a get and post methods for any type of hack or injection i.e. xss php java html mysql injection. the function needs to check the get or post methods prior to using it … |
| | Hi, I am in urgent need for converting sql procedure to postgre sql procedure.Please help me ASAP. CREATE FUNCTION sp_get_id_des (IN cellid INT, IN mcc VARCHAR(3), IN mnc VARCHAR(3), IN nwtype INT, IN mlac INT , IN mrac INT ) returns SETOF record AS' declare pscnt int ; declare cscnt … |
| | Hi, I've made an application and it connects to my database. But the issue is the details of the database can be found out through packet logging or something. How can I stop this from happening and secure it, without having to have a third party such as PHP script …  |
 | Dear friends, This is my table: CREATE TABLE IF NOT EXISTS `exam_student` ( `exam_roll_no` int(10) unsigned NOT NULL AUTO_INCREMENT, `enrol_id` int(10) unsigned NOT NULL, `exam_id` int(10) unsigned NOT NULL, PRIMARY KEY (`enrol_id`,`exam_id`), KEY `exam_roll_no` (`exam_roll_no`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=5 ; I am trying to get the field **exam_roll_no reset … |
| | Hi, I want to update a column in **same table** if another column is updated but I'm getting error message. > Can't update table 'tbl' in stored function/trigger because it is already used by statement which invoked this stored function/trigger I tried two different approaches but no luck. Same error. … |
| | Hi all, i have 2 shared host server(www.nextsoftech.com(ip:64.202.123.78) and www.simpletelecomltd.co.uk (ip:208.91.198.107)). i want to access nextsoftech.com 's database from simpletelecomltd.co.uk 's script. that's means i stor all script simpletelecomltd.co.uk this server. Would any one help me how can configure and what is the connect code in php? thanks you sumain |
| | I need some help. I'm loading a .php file using jquery. the php is a mysql query that pulls all the cities from Alaska. The problem is that I wrote my query a certain way and it seems jquery changes it when it loads it. state_alaska.php include 'config.php'; include 'opendb.php'; … |
| | Hi all, I'd like to know if it is possible to create a perl script that would take the names of image files with its extension of say 10,000 images from out of a folder and place them into a database table in separate rows to use as sample data? … |
| | Hi all, I'd like to know if it is possible to create a php script that would take the names of image files with its extension of say 10,000 images from out of a folder and place them into a database table in separate rows to use as sample data? … |
| | Hi I have two Mysql tables, one with the information in and another with payment information in. I want to echo the results that have paid first and then the rest of the results. If information has no payment associated with it it does not appear in the payment table. … |
| | I am developing an sql query to use to grab information from a postgres db. The scenario is as follows: the database I am grabbing information is the backend postgres database of an application (Tableau). My objective is to pull all of the workbooks, views, and datasources (considered objects) that … |
| | Hi, If i want to create a user in MySQL only to allow the Php program file to access the database and show results in my website what priviliges should i give to the user. So that access to my database is never compromised if someone can get the password … |
| | I am using Hindi Font and storing into database. While inserting I use mysql_real_escape_string() function; its working fine on local but not on server. **showing on server** Its adding extra slashes; but in local its showing correct INSERT INTO `tbl` (`num`, `address`, `name`, `father`, `state`, `city`, `gender`, `mobile`, `namdan_date`, `file`, … |
| | I'm trying to develop an interactive website using php and i want to display image(retrived from mysql database) and some text on the home pag. but the image retrived from my database fills the whole page. how can i display both text and image on the same page? |
 | hello there - been awhile since ive been about but im ready to crack on with my learning :) kk i used to have this installed on my last "free" host and it worked fine now im on a paid host (hosting24) it doesnt seem to want to work correctly.. … |
| | i want to go inside the if statment if i have both things in one row. so if i have image_id = $image_id_g and user_id=$user_id_s on same row. i wan tto go inside the if statment. but this is not working. i thinkg this query is testing two things sepeartly. …  |
| | I recently decided to try out a simple PHP/MySQL pagination script I found online. After replacing all the required data and creating a connect.php file with my db information, I got a bunch of errors on the page with the script: here they are, in order: Warning: include(connect.php) [function.include]: failed … |
| | Hi all, I have a registration page which allows the user to open up separate windows to include additional information. But for some reason it freezes the page and doesn’t allow data to be submitted into the MySQL database table. I’m mot sure whether this is a php or a … |
| | Hi all, I have a registration page which allows the user to open up separate windows to include additional information. But for some reason it freezes the page and doesn’t allow data to be submitted into the MySQL database table. I’m mot sure whether this is a php or a … |
| | I have a project in which I desire to upload and download blob files in php. I have written the codes to upload the files into mysql however, when I try to download the files, be it pdf, .doc or jpeg, the error message I get is "The selected file … |
| | > Here **My Application is used MySQL as a database. and on my server MySQL is running. server is highly configured on Win XP Os and other on Win 7. Mysql version - 4.0.18-nt My problem is , Mysql is stopped working everday after 5 to 6 hours. It is … |
| | I'm a novice to PHP and MySQL, and would like to create a mailing list on my site, which can send HTML documents (basically styled to match the actual website). Can someone point me towards a good tutorial, or show me how to do so? |
The End.