10,938 Topics
 | |
| | Hi, I have been trying to import the data from a CSV file (10,000 rows) into a database using SQL and PHP <body> <div id="container"> <div id="form"> <?php $user="root"; $database="test"; mysql_connect("localhost",$user); @mysql_select_db($database) or die( "Unable to select database"); //Upload File if (isset($_POST['submit'])) { if (is_uploaded_file($_FILES['filename']['tmp_name'])) { echo "<h1>" . "File … |
 | So I've been working on a page to locate shops based on zip code and mile distance. I used this tutorial as a walk-through http://htmlcampus.com/build-a-zip-code-store-locator-application-in-php/ Now I've changed a couple of things like the mySQL table is called locations instead of zip_codes. I've tested it and it connects to the …  |
 | I am urgently seeking assistance with the following error: *Commands out of sync; you can't run this command now* here's the code: $sql="select pr1.".$_SESSION['lang'].", pr1.id, pr2.".$_SESSION['lang'].", pr2.id from `project` as pr2 join project as `pr1` on(pr1.id=pr2.parent_project) where pr2.id=?"; $stmt = $mysqli->stmt_init(); $stmt->prepare($sql) or die ("Error preparing statement: ".$mysqli->error); $stmt->bind_param('i',$_GET['id']); $stmt->execute() … |
 | I have city and its corresponding locality. When user clicks city then its locality will show in Dropdown-Checkbox. How I can do with jQuery, AJAX and MySQL. |
| | hello i want to know that how pass parameters to mysql query inside php function i have written function but giveing me error error: mysql_fetch_array(): supplied argument is not a valid MySQL result resource function d_loader($r_ip){ global $con; $result = mysql_query("SELECT * FROM table WHERE h_ip ='$r_ip'"); $row=mysql_fetch_array($result);} |
| | I have problem that when i make autocomplete with jquery and webservice it works fine.but problem is that when i delete my table related to include autocomplete then it still working.but it give error it keep break point but accordind to break point it goes same thing means it show … |
| | **Hi**, #need to generate a report like Table Format(Excel Sheet) # this is an example view of the report which I need of it is for maintaining branch wise details In that product name contin in one table and stock of each branch will contain in another table -------------------------------------------------------------------- | … |
| | hello i have phpmyadmin installed now new version is realeased so i want to upgrade myphpmyadmin to latest i tried from ssh yum upgrade phpmyadmin but yum have no packages for it so pelase help with it i jsut want to upgrade it so that server other modules are not … |
 | Hi, I am trying to use mysql select query in a shell script but i need to know how to store a particular value from the output of the query in a script variable. my script file is given below. I need to store the value under field CheckSum in … |
| | I have two dropdwon box. First box has names of the states. Choosing a state will populate the second dropdown box that contains cities of that selected state. For all states city names are stored in mysql database table. now I am little confussed how to model the table and … |
| | Hey experts. I have two database, i want to fetch values from one of the table from one database and then insert that into another table on another databse, server is same. can i do it? if yes please give some suggestions how to make it hapoen. many thanks in …  |
| | 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> … |
The End.