10,942 Topics
 | |
 | $cartOutput = ""; $cartTotal = ""; $ctr= 0; $collector = array(); $product_id_array = ''; if (!isset($_SESSION["cart_array"]) || count($_SESSION["cart_array"]) < 1) { $cartOutput = "<h2 align='center'>Your shopping cart is empty</h2>"; } else { $i = 0; foreach ($_SESSION["cart_array"] as $each_item) { $item_id = $each_item['item_id']; $sql = mysql_query("SELECT * FROM products WHERE … |
 | im on win 8. neither can i find the bin folder as i could on my xp machine , nor do i get any command line. googleing didnt help much either. either i got some really hard to understand mysql doc page , with no specific answer to my problem … |
| | my insert php cannot save data to phpmyadmin when it enter the details. localhost:locahost , username:root password: databasename:b_database tablename:my_library tablecolumn:2 contains : isbn(primary key) and title. index.php <html> <head> <meta name="description" content="Php Code for View, Search, Edit and Delete Record" /> <meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1" /> <title>Search Library Record</title> </head> …  |
 | hi guys, am trying to make a simple PHP form submission and insert some data to MySQL, my tables are: category: -id -category_name table1: -category_id(FK) -title -description table2: -table1_id(FK) -filetype -filesize -filedate -filename Form: -Date -Title -description -category(drop down) -upload file (get the file info like type,ext,size,filename) Or is there … |
| | I get this message quite often and it has popped up again here, any ideas as to why? Warning: mysql_num_rows() expects parameter 1 to be resource, boolean given in C:\xampp\htdocs\.... on line 76 line 76 is this line in bold. [CODE] $productlist = ""; $sql = mysql_query("SELECT * FROM products …  |
| | hey guys... i know this is a very common problem and has been posted earlier also... but nobody seems to have figured out a solution... i am making a program using PHP/MySQL. I need to update 3 columns in a table. when i use a single UPDATE-SET command(using commas/AND etc …  |
 | Hi! Got errors on site... Warning: mysql_fetch_array() expects parameter 1 to be resource, boolean given in /home/content/13/11394913/html/header.php on line 30 Warning: mysql_fetch_array() expects parameter 1 to be resource, boolean given in /home/content/13/11394913/html/config.php on line 4 Warning: mysql_fetch_array() expects parameter 1 to be resource, boolean given in /home/content/13/11394913/html/index.php on line 16 … |
| | Hello. I created a little recover page. Users write the email and a random password is sent to them. The random password is successfully send in their emails but when they login with the new password it doesn't login. I think the new password does not updates in my database. …  |
| | How to do the code for design and develop an PHP/MySQL application involves insert, view, search, delete, update/modify a record from a database  |
| | Design PHP/MySQL application that involves insert, view, search, delete, update/modify a record from a database. "The application is mylibrary and we have to insert, view, search, delete, update/modify the isbn(length:13) and title of the book (length:128)" Can someone show me the code ? I already done mine but I want …  |
 | Hi guys, I've created a simple plugin for Wordpress that interacts with an API in the backend. The problem is that everything is inserted twice in the database, and I cannot figure out why. The form is submiting only once, not twice. What could it be ? Redirects from my … |
| | I have these templates: temp1(id,country_id,county_id,town_id,location_id,street_id) country(country_id, language,country_name) county(county_id, language,county_name) town(town_id, language,town_name) location(location_id, language,location_name) street(street_id, language,street_name) For now i am joining all these for the selected language to find the names of temp1 id's location. Is there a better way to retrieve the informations? Would be better to make a table …  |
| | A friend asked me to rewrite a program for him. Though the problem is it s using a rdb database, i am assuming this is a dec/oracle rdb database. Which i honestly never used and have no knowledge of. So i was wondering if there is any way to convert …  |
| | i am new to study web development..can anyone help me to how i can connect my website with the database..what are the requirements..very basic please.!!  |
 | Hi there, I have a really irritating site problem that I just can't get my head around. I only have fairly basic coding skills and hope that someone here can help crack my issue. I own a small php/mySQL based job board which I have moved from hosting to hosting …  |
| | Hi All, I am currently working on a MySQL database, and am using mySQL Workbench to create a local server. From this computer(the one that is hosting the server) i have no problem connecting to the mysql server through 127.0.0.1:3306, however when I try to connect from another computer, I … |
| | I've been trying to use mysqli instead of mysql. I have a file from another site which will fit nicely to this site im doing now, but i havent a clue what i need to do to convert it to mysqli. This is the file <?php include 'connect.php'; //populate form … |
| | Show me example design PHP/MySQL application involves insert, view, search, delete, update/modify a record from a database  |
| | PHP help , please asap , need your email to email you my problem  |
| | I have a mysql query that seperates an array of variables and uses each variables to compare inside the database. The query uses a OR clause and I want to make it so it can also use an AND clause. The trick is I want the left side of the … |
| | Hi, - Why use paging? It's not really cool to print out all 2000 rows you have in a table to the page, so it'd be nice to page them. Special cases? Yeah, if you have 1000 rows.. and you've set the maximum row per page to 20, well.. you're … |
| | Hello, I have a members area on my website. I'm trying to check if a user with a specific username and id has logged in, and then echo a string of text on page B (members area page) if its them. The user logs in on page A (login page). … |
| | hi guys, 1. i use this script from w3schools it works with real escape string. But my problem is it is slow displaying the table and i dont know how to check the problem. assuming password and table is correct. 2. can i change the "ajax_demo" value or delete? reference: … |
| | Hi I have a php header file that displays a random image from a mysql table each time the page is reloaded. I have done this just using rand() in the query. But doing it like this means that the same image could come up 3,4,5 times in a row! … |
| | I have a form that shows images whos paths are stored in mysql. The form has 'hide' and 'show' submit buttons for each image. Pressing the hide button should set the value of the 'status' field to 2 (hidden). But it does nothing, my queries don't seem to execute. Here … |
 | I need the steps to make an daily Back Up to my data base i am using SQL 2008 and when i do the backup job it gives me an error unsuccessfull complete , any one can tell me why ??  |
 | can you help me in 1 cell in a row can handle many data ? for example in the picture for costumer 1, he order a banana, it cost 50 apple, it cost 60 orange, it cost 70 and my program will retrieve the datas and it will get the … |
| | <?php $mysql_host = "***"; $mysql_database = "***"; $mysql_user = "***"; $mysql_password = "***"; mysql_connect($mysql_host,$mysql_user,$mysql_password); mysql_select_db($mysql_database); $query = "SELECT * FROM people coming"; $result = mysql_query($query); while($w=mysql_fetch_array($result)) { echo $w['Name']; } ?> this doesnt work--Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource y? |
| | Hi All, I have a table of about 120,000 records which are mostly chemical products all with 100 byte varchar for the 'name'. I've indexed the 'name' and looked at the list here http://www.ajaxline.com/32-tips-to-speed-up-your-mysql-queries for ideas. But can't really find a solution because it's taking about 20 seconds to retrieve …  |
| | i have database with tables like these: t_09_students t_10_students t_11_students where 09, 10, 11 show year and this table will increase over the year. how do i select all the data from the tables (using union) with flexible table name? ask me, if it is not clear yet |
The End.