10,940 Topics
 | |
| | Hi all, I've a problem with my insert sql..I didn'y know why. here is my insert sql $goodsDesc = $_POST['goodsDesc']; $k8goodsQty = $_POST['k8goodsQty']; $valuePerUnit = $_POST['valuePerUnit']; $sql_k8goodsIn = "INSERT INTO k8_goodsin (k8regID,goodsDesc,k8goodsQty,valuePerUnit) VALUES ( '".$k8regID."', '".addslashes(strtoupper($goodsDesc[$y]))."', '".$k8goodsQty[$y]."', '".$valuePerUnit[$y]."')"; for goodsDesc the input is like this goodsDesc = 2-1/2" suction pump … |
 | Hi Everyone, get a really strange problem I have been trying to fix for a few days now and I am unable to get it working. I have the following script as update.php file if (isset($_GET['tx'])) { $tx = $_GET['tx']; // collect all parameters herer $request = print_r($_REQUEST, true); $sqlcode … |
 | I have a php page which is logged in with a user account. Now i want to change my password here, also I'm getting two errors here. "Notice: Undefined variable: password in C:\xampp\htdocs\fyp\cms\cms-settings.php on line 73 Warning: mysql_affected_rows() expects parameter 1 to be resource, boolean given in C:\xampp\htdocs\fyp\cms\cms-settings.php on line …  |
| | For those that have a good understanding of PHP arrays, I have a form that takes in multiple inputs that can be added to the form by js, the data is added to the codeRef[] array and I have tried to do several different things to get the data into … |
| | hey guys so ive been asked to add an import csv function to my contacts page. <?php require "connection.php"; if ($_FILES[csv][size] > 0) { //get the csv file $file = $_FILES[csv][tmp_name]; $handle = fopen($file,"r"); if ($data[0]) { mysql_query("INSERT INTO contact (fname,lname,email) VALUES ( '".addslashes($data[0])."', '".addslashes($data[1])."', '".addslashes($data[2])."' ) "); } } … |
| | I have the following code in my php files, but i am having a following error while loading my page? "Notice: Undefined variable: username in C:\xampp\htdocs\fyp\cms\cms.php on line 48" My page is successfully loading up, but username is not being shown in the page and the error is popped up …  |
| | I have the following code, and i am having these errors: "Warning: mysql_fetch_array() expects parameter 1 to be resource, integer given in C:\xampp\htdocs\fyp\qmc-login\login.php on line 58 Warning: mysql_fetch_array() expects parameter 1 to be resource, integer given in C:\xampp\htdocs\fyp\qmc-login\login.php on line 59" Can somebuddy find out whats the problem? Thanks in … |
| | Hi this is Sukhdev, I am new in php and wish to know how to import the data from excel sheet to mysql Table; 1. I have a table with the name of city in mysql with following fields; city_id,city_name,tier_id,tier_name,state_id,state_name 2. what would be the function for uploading above fields, …  |
| | Hello, I need to run a report against a database, and I am having a difficult time thinking of a way to run a particular report. What I need to do is run a report which selects students that have no course registrations for three consecutive semesters. The semester table …  |
| | Hello Anyone could you help i have got a strange problem when i update any record i get an error 2147467259 -(8000405) Insert Field failed. Where as on the same application i can add a new record. Please see below the code i have used dont know where am going …  |
 | I have 1 or actually 2 problems. I have 2 sites, the first one generates a table with avatar, coins, and name (which links to a more detailed view like this `/stats/user/?name=<dynamic name>`. It looks like this: <table> <thead> <tr> <th>#</th> <th>Points</th> <th>Name</th> </tr> </thead> <tbody> <?php error_reporting(E_ALL); define ( … |
| | Hey there. I'm trying to retrieve a date from an SQL table. The original formate of the date is as follows: 0000-00-00 00:00:00 I want to try and change the format into: Month Date, Year e.g. May 17, 2014 <?php $page_title = 'View the current users'; include('header.inc'); require_once('mysql_connect.php'); try{ $query … |
 | i am trying to command mysql to sum until it reaches certain value from my table 'purchase', for each 'sid' starting from the last row, i need sum of 'pqty' until the result equals a value from string (but to try i've given a certain value). let me define with … |
| | hey, i have stored a few images in mySQL database as BLOB.Now i want to retrieve and display the images on frame as a gallery/grid view.I have displayed one image in a frame but when i tried to add more images it fails...Can anyone help with sample code,coz im new …  |
 | Hi all I need some advice making my query work properly. I already played around it a dozen of times and still can't get it work. So as my last option im here:) . what im trying to achieve is sum all amount of a particular rows and display the … |
| | Hello Below is the schema with sample data of table es_preadmission  I am trying to get the number of male and female students from each categories (GEN, SC,ST,OBC), bpl, sgc, handi,ser_cat class wise. Example class 1 => GEN => Male = 3, class 1 => GEN => Female … |
| | i just dowloaded a fiverr clone from http://phpvalley.com/phpvalley-micro-jobs-site-script/ but am unable to install it on my localhost.am told to change 644 to 777, but i dont know where or how. I rigth click on connect.php and tryed changing its propaties, but it too did'nt work... |
 | Warning: mysql_fetch_array() expects parameter 1 to be resource, boolean given in C:\wamp\www\firewall\php\allresults.php on line 3 The annoying thing is, I have used this multiple times on different applications, I dont know why it think the result is boolean? the exact same code works on a different database, I just cant … |
 | Hello I am able to display the images that i am retrieving from the database as a list. But i want to know how i will be able to display the same images as a grid or table. I have posted my code below.Can you please let me know how …  |
 | Hi guys, OK, here is the issue I am having. Perform a search and when you click the submit button, it takes you to the page that displays the info. Now, when the user clicks the back button on the browser it tries to re-submit the info. I don't want … |
 | I have a table called "mytable". The columns are Time_Stamp (datetime) PK Time_stamp_ms (int) PK data1 (int) data2 (int) data3 (int) data4 (int) data5 (int) data6 (int) cycle (int) name (varstring) I want to order by Time_Stamp and Time_stamp_ms and then each time cycle reaches 1, I want to get … |
 | Hi All, I'm trying to connect to a mysql database using the MySQL Connector from Oracle. I'm hitting my first issue of linking the libraries and was hoping that someone could nudge me in the right direction. What I have done so far: Downloaded mysql-connector-c-6.1.3-osx10.7-x86_64.dmg from http://dev.mysql.com/downloads/connector/c/ In XCode, in … |
| | hey guys! this is my first post to daniweb. and also i've not been so long on php. i m trying to manage customer transection records but stuck on one place and i need help.. here is my mysql table for transection of customer id-1 => +-----+------+----------+--------+------+-------| | svn | … |
| | Hi all, I am very new to php and am slowly trying to get something together. I have a MySQL database with a table that has (among others) a field which is TINYINT called "field1". I have managed to be able to store a 1 or 0 in it from … |
 | Hey I'm new to the website but I've been a friend of Dani for a little over a year and attend the DaniWeb meetups. I know I'll need coding help and as a noob I'll be seeking out the help of you experts in javascript w/ jquery & ajax, php, …  |
 | Hi everyone, Please help me to register the sql query exceutor in netbeans and java. I am using ireport 5.5.1 and netbeans 8.0 with jdk 8. The problem is that when i run the reports within netbeans, they run but when i build the project and run it from a … |
| | hey so im trying to save data but i get error: `You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'WHERE event_id = '8'' at line 1` this being the line: `$sql = mysql_query("INSERT … |
 | Hello everyone. I have juste started creating my website and I need some help. I have found a thread about this subject but it have been dead since three months back so I didn't get what I wanted from there. What I need help with is: I want to create … |
 | Hello world, I'm developing two applications: 1. Chat room 2. Forum The two are under the same domain : **chat_room**.ask.com and **forum**.ask.com What I wanna do is this, I want users who login to the forum to at the same time use the chat room without login in again...just like … |
| | here i have to store comapnyname,contactperson,city,place,maincategory,subcategory values.but i have 4 tables with data's like maincategory,subcategory,city,place. so how can i store the below data's in table.in spa table i added maincategoryid and cityid is enough or else these city and category i have to store in another table. please give some … |
The End.