[mysql] Forum Topics

i have created database for our site. but i wanted to know that how can i secure my website using session.

Hi With the code snippet given in the following post http://www.daniweb.com/web-development/php/threads/126361/csv-file-uploading-into-a-mysql-database I am able to import csv data into phpmyadmin. However, I am getting an error if csv data contains a text with apostrophe (‘) symbol (e.g. my book’s name is abc). Appriciate any suggestions to resolve this error. Thank …

Hi. I wanted to make a page that I can update a table in a database. But for some reason, I get this error: ***Warning: mysql_query() [function.mysql-query]: Access denied for user 'a1092592'@'localhost' (using password: NO) in /home/a1092592/public_html/folder/file.php on line 10*** and this error: ***Warning: mysql_query() [function.mysql-query]: A link to the …

Hi guys, Just looking for some advice on database design. I'm relatively competent in MySQL (competent at a push, haha) and I'm in a bit of a pickle right now when I'm trying to generate products for a Magento store. Well, Magento is where it ends up, I currently use …

Hi, I want to change this code as given 1 result. I don't need 10 line results. I just need 1 line result. When I tried to change 10 with 1 it doesn't work. Please help me about that. while( $row = mysql_fetch_array($query) ) { $id[] = $row['id']; } $id …

Hi, I'm creating a website/database that my dad and his partner will use to help manage there business. update new appointments / manage customers ect. My dad wanted to host it on our server, however I'm not confident about setting up security so I was just going to use a …

how to add email adress validation code so the validation will dispaly after immideately entered email adress in text box of email adress

Hey everyone, I'm having a little trouble with creating a 'dynamic' calendar with events called from a MySQL database. So basically I would like to have the Month automatically change when the month changes, and highlight the days which have events scheduled, and make those days links to my thickbox …

I just installed Windows 8 Release Preview and my existing wampserver does not work. I tried installing easyphp and after the service was successfully started it can't find the localhost. Is there any fix to this or other local servers to run php and phpmyAdmin the easy way ? Thanks …

I have two ajax mysql php 2 drop down select that I am populating... i'm doing something stupid... anyone have any suggestions... or pointers....? 1.php <?php require_once('dbconfig.php'); ?> <?php if (!function_exists("GetSQLValueString")) { function GetSQLValueString($theValue, $theType, $theDefinedValue = "", $theNotDefinedValue = "") { if (PHP_VERSION < 6) { $theValue = get_magic_quotes_gpc() …

Please help me in the following question: Given the following three tables Table 1: specialization (name,department) Table 2: area (a_name,phone,address) Table 3: dep_loc (area_name,department) where the "area_name" attibute in dep_loc references "a_name" in area. Write a query to give a count of the number of people that work in each …

<?php require_once('mail.inc.php'); $con = mysql_connect("localhost","root","12345"); if (!$con) { die('Could not connect: ' . mysql_error()); } mysql_select_db("billtest",$con); $today=strtotime(date("Y-m-d")); $query1="SELECT * FROM ab_transactions_paypal WHERE status=0 AND expiry_date>$today"; $result=mysql_query($query1); if(mysql_num_rows($result)>0){ $count=mysql_num_rows($result); for($j=0;$j<$count;$j++){ $row=mysql_fetch_array($result); $token_id=$row['token_id']; $account_id=$row['account_id']; $sku=$row["sku"]; $inv_id=$row['invoice_id']; $bill_amt=$row['amount']; $cust_email=$row['cust_email']; $url="https://ssl.3gsecure.net/api/payment/checktoken.asp?TransactionToken=$token_id"; $httpRequest_OBJ = new httpRequest($url, HTTP_METH_POST); $result = $httpRequest_OBJ->send(); $mine=$httpRequest_OBJ->getResponseBody(); echo $httpRequest_OBJ->getResponseBody(); $s = …

Hi i am Trying to delete a page from my site cms and something is not working . the code is: <?php $con = mysql_connect("localhost","matanc_cmd","123123"); if (!$con) { die('Could not connect: ' . mysql_error()); } mysql_select_db("matanc_cms", $con); $id = (int) $_POST['id']; mysql_query("DELETE FROM content WHERE id='$id'"); mysql_close($con); // if successfully …

Hello, I have a bit of challenge that I’m wondering if I can solve by SQL. My source table (thinned out) holds the following two columns: TASK_NAME [VarChar], DUE_DATE [Date] My end state is a list (will be a JQM list element) that will list out every task under headings …

Dear all experts im now creating a rating system with php using mysql databse, im facing the problem about how to calculate rating!, ex. i have totalscore and numofvotes table, which function that we can use to calculate rating like, 7.4, 4.5 something like that thanks in advance

if i have roughly 25 identical tables is it possible to do the following SELECT tm_name, `tablename` as Activity from t1, t2 ,t3 where date = curdate or would it be better to add another column to the table thats hidden from the users and automatically populate with the tablename.

Hi, I have a table with a timedate collumn. I want to get the text of the article and its creation date, than to output them on my page. How can I just get only the date value from a query or php script manupulation?

Warning: mysql_query() [function.mysql-query]: MySQL server has gone away in C:\xampp\htdocs\a_upload\upload.php on line 71 Warning: mysql_query() [function.mysql-query]: Error reading result set's header in C:\xampp\htdocs\a_upload\upload.php on line 71 GalleryUploadMessageProfileStatistticsChange PasswordDelete Account if(!$sql=mysql_query("INSERT INTO image VALUES(NULL, '$user_id_db', '$image', '$image_keyword_p' , '$image_full_name', '$image_short_name_p', '$image_des_p','$file_size' ,'$image_resolution', 0)")) Warning: mysql_fetch_assoc() expects parameter 1 to be resource, …

Warning: mysql_fetch_assoc() expects parameter 1 to be resource, boolean given in C:\xampp\htdocs\a_upload\index.php on line 114 line 144: while($row = mysql_fetch_assoc($R)) $count = 0; $Q = "SELECT (SELECT image_short_name FROM user) as `image_short_name`" .",`image_id`,`user_id`,`image_short_name`,`image`" ." FROM `image`" ." ORDER BY RAND()" ." LIMIT 5"; $R = mysql_query($Q); echo " <!DOCTYPE html> …

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?

I am trying to do something that should be trivial. I have a database table that I want to load into an array so that I can use the elements later on in my code. What I dont understand is how to put the elements into a simple 2 dimensional …