php-windows Digest 1 Mar 2011 23:09:09 -0000 Issue 3919 Topics (messages 30515 through 30520):
Re: Error while inserting data into mysql
30515 by: nagendra prasad
30516 by: Richard Quadling
30517 by: Richard Quadling
Need help with an extra backslash
30518 by: nagendra prasad
Dynamic Charting Assistance Requested
30519 by: Charles W Buege
Re: [PHP-DB] Need help with an extra backslash
30520 by: Design in Motion Webdesign
Administrivia:
To subscribe to the digest, e-mail:
php-windows-digest-subscr...@lists.php.net
To unsubscribe from the digest, e-mail:
php-windows-digest-unsubscr...@lists.php.net
To post to the list, e-mail:
php-wind...@lists.php.net
----------------------------------------------------------------------
--- Begin Message ---Hi All, I have attached the table structure and the PHP code. Best, Guru.===Database dream == Table structure for table dream |------ |Field|Type|Null|Default |------ |mwool40|varchar(100)|Yes|NULL |gwool25|varchar(100)|Yes|NULL |wmesh24|varchar(100)|Yes|NULL |shkote30|varchar(100)|Yes|NULL |scloth100|varchar(100)|Yes|NULL |macomp40|varchar(100)|Yes|NULL |pop|varchar(100)|Yes|NULL |hcloth95|varchar(100)|Yes|NULL |mwool40_qty|int(10)|Yes|NULL |gwool25_qty|int(10)|Yes|NULL |wmesh24_qty|int(10)|Yes|NULL |shkote30_qty|int(10)|Yes|NULL |macomp40_qty|int(10)|Yes|NULL |pop_qty|int(10)|Yes|NULL |hcloth95_qty|int(10)|Yes|NULL |mwool40_utp|int(20)|Yes|NULL |gwool25_utp|int(20)|Yes|NULL |wmesh24_utp|int(20)|Yes|NULL |shkote30_utp|int(20)|Yes|NULL |scloth100_utp|int(20)|Yes|NULL |macomp40_utp|int(20)|Yes|NULL |pop_utp|int(20)|Yes|NULL |hcloth95_utp|int(20)|Yes|NULL |mwool40_val|int(20)|Yes|NULL |gwool25_val|int(20)|Yes|NULL |wmesh24_val|int(20)|Yes|NULL |shkote30_val|int(20)|Yes|NULL |scloth100_val|int(20)|Yes|NULL |macomp40_val|int(20)|Yes|NULL |pop_val|int(20)|Yes|NULL |hcloth95_val|int(20)|Yes|NULL |mwool40_vatr|int(10)|Yes|NULL |gwool25_vatr|int(10)|Yes|NULL |wmesh24_varr|int(10)|Yes|NULL |shkote30_vatr|int(10)|Yes|NULL |scloth100_vatr|int(10)|Yes|NULL |macomp40_vatr|int(10)|Yes|NULL |pop_vatr|int(10)|Yes|NULL |hcloth95_vatr|int(10)|Yes|NULL |mwool40_vatp|int(20)|Yes|NULL |gwool25_vatp|int(20)|Yes|NULL |wmesh24_vatp|int(20)|Yes|NULL |shkote30_vatp|int(20)|Yes|NULL |scloth100_vatp|int(20)|Yes|NULL |macomp40_vatp|int(20)|Yes|NULL |pop_vatp|int(20)|Yes|NULL |hcloth95_vatp|int(20)|Yes|NULL |mwool40_totamt|int(20)|Yes|NULL |gwool25_totamt|int(20)|Yes|NULL |wmesh24_totamt|int(20)|Yes|NULL |shkote30_totamt|int(20)|Yes|NULL |scloth100_totamt|int(20)|Yes|NULL |macomp40_totamt|int(20)|Yes|NULL |pop_totamt|int(20)|Yes|NULL |hcloth95_totamt|int(20)|Yes|NULL |total|int(20)|Yes|NULL |trans_chgs|int(15)|Yes|NULL |gtotal|int(20)|Yes|NULL |rupees|varchar(100)|Yes|NULL |//**party_name**//|varchar(400)|No| |tin_no|varchar(50)|Yes|NULL |invoice_no|varchar(50)|Yes|NULL |invoice_date|varchar(20)|Yes|NULL |order_no|varchar(15)|Yes|NULL |order_date|varchar(20)|Yes|NULL |dc_no|varchar(20)|Yes|NULL |dc_date|varchar(15)|Yes|NULL == Dumping data for table dream<?php $con = mysql_connect("localhost","root",""); if (!$con) { die('Could not connect: ' . mysql_error()); } mysql_select_db("dream", $con); $sql="INSERT INTO dream (mwool40, gwool25, wmesh24, shkote30, scloth100, macomp40, pop, hcloth95, mwool40_qty, gwool25_qty, wmesh24_qty, shkote30_qty, scloth100_qty, macomp40_qty, pop_qty, hcloth95_qty, mwool40_utp, gwool25_utp, wmesh24_utp, shkote30_utp, scloth100_utp, macomp40_utp, pop_utp, hcloth95_utp, mwool40_val, gwool25_val, wmesh24_val, shkote30_val, scloth100_val, macomp40_val, pop_val, hcloth95_val, mwool40_vatr, gwool25_vatr, wmesh24_vatr, shkote30_vatr, scloth100_vatr, macomp40_vatr, pop_vatr, hcloth95_vatr, mwool40_vatp, gwool25_vatp, wmesh24_vatp, shkote30_vatp, scloth100_vatp, macomp40_vatp, pop_vatp, hcloth95_vatp, mwool40_totamt, gwool25_totamt, wmesh24_totamt, shkote30_totamt, scloth100_totamt, macomp40_totamt, pop_totamt, hcloth95_totamt, total, trans_chgs, gtotal, rupees, party_name, tin_no, invoice_no, invoice_date, order_no, order_date, dc_no, dc_date) VALUES ('$_POST[mwool40]','$_POST[gwool25]','$_POST[wmesh24]','$_POST[shkote30]','$_POST[scloth100]','$_POST[macomp40]','$_POST[pop]','$_POST[hcloth95]','$_POST[mwool40_qty]','$_POST[gwool25_qty]','$_POST[wmesh24_qty]','$_POST[shkote30_qty]','$_POST[scloth100_qty]','$_POST[macomp40_qty]','$_POST[pop_qty]','$_POST[hcloth95_qty]','$_POST[mwool40_utp]','$_POST[gwool25_utp]','$_POST[wmesh24_utp]','$_POST[shkote30_utp]','$_POST[scloth100_utp]','$_POST[macomp40_utp]','$_POST[pop_utp]','$_POST[hcloth95_utp]','$_POST[mwool40_val]','$_POST[gwool25_val]','$_POST[wmesh24_val]','$_POST[shkote30_val]','$_POST[scloth100_val]','$_POST[macomp40_val]','$_POST[pop_val]','$_POST[hcloth95_val]','$_POST[mwool40_vatr]','$_POST[gwool25_vatr]','$_POST[wmesh24_vatr]','$_POST[shkote30_vatr]','$_POST[scloth100_vatr]','$_POST[macomp40_vatr]','$_POST[pop_vatr]','$_POST[hcloth95_vatr]','$_POST[mwool40_vatp]','$_POST[gwool25_vatp]','$_POST[wmesh24_vatp]','$_POST[shkote30_vatp]','$_POST[scloth100_vatp]','$_POST[macomp40_vatp]','$_POST[pop_vatp]','$_POST[hcloth95_vatp]','$_POST[mwool40_totamt]','$_POST[gwool25_totamt]','$_POST[wmesh24_totamt]','$_POST[shkote30_totamt]','$_POST[scloth100_totamt]','$_POST[macomp40_totamt]','$_POST[pop_totamt]','$_POST[hcloth95_totamt]','$_POST[total]','$_POST[trans_chgs]','$_POST[gtotal]','$_POST[rupees]','$_POST[party_name]','$_POST[tin_no]','$_POST[invoice_no]','$_POST[invoice_date]','$_POST[order_no]','$_POST[order_date]','$_POST[dc_no]','$_POST[dc_date]')"; if (!mysql_query($sql,$con)) { die('Error: ' . mysql_error()); } echo "1 record added"; mysql_close($con) ?>
--- End Message ---
--- Begin Message ---On 1 March 2011 10:59, nagendra prasad <nagendra802...@gmail.com> wrote: > Hi All, > > I have attached the table structure and the PHP code. > > Best, > Guru. > > -- > PHP Windows Mailing List (http://www.php.net/) > To unsubscribe, visit: http://www.php.net/unsub.php > Thank you for that. Can you tell me what column in the table is scloth100_qty? I can't find it. -- Richard Quadling Twitter : EE : Zend @RQuadling : e-e.com/M_248814.html : bit.ly/9O8vFY
--- End Message ---
--- Begin Message ---On 1 March 2011 10:59, nagendra prasad <nagendra802...@gmail.com> wrote: > Hi All, > > I have attached the table structure and the PHP code. > > Best, > Guru. > > -- > PHP Windows Mailing List (http://www.php.net/) > To unsubscribe, visit: http://www.php.net/unsub.php > The scloth100 columns I can see are ... |scloth100_totamt|int(20)|Yes|NULL |scloth100_utp|int(20)|Yes|NULL |scloth100_val|int(20)|Yes|NULL |scloth100_vatp|int(20)|Yes|NULL |scloth100_vatr|int(10)|Yes|NULL |scloth100|varchar(100)|Yes|NULL No scloth100_qty. -- Richard Quadling Twitter : EE : Zend @RQuadling : e-e.com/M_248814.html : bit.ly/9O8vFY
--- End Message ---
--- Begin Message ---Hi All, I have a list of product in which WIRE MESH 24G X 3/4" is one of them. When I am trying to print the same its coming like WIRE MESH 24G X 3/4\". I want to remove the extra "\" backslash from the result page. Please help me with this. Best, Guru.
--- End Message ---
--- Begin Message ---Hello out there - If anyone can help me, it'll be greatly appreciated!! I'm working with the pChart (http://www.pchart.net) PHP chart framework and think it is a fantastic program/product. I am NOT knocking pChart at all - I'm just looking for help from my fellow users out there and trying to use pChart in a way that it isn't really designed for/may not be able to do. Here is the project I'm working on: I'm retrieving data from an IBM iSeries AS/400 with a DB2 data source back end and I'm getting the data fine (MAD props out to ADOdb Database Abstraction Library for PHP - http://adodb.sourceforge.net - works like a CHAMP!!!) but I need to create some graphs off of said data. Well, pChart works GREAT for the graphs now that I understand a bit more about how it created the PNG graphs on the fly. Rather, my users have two specific requests for capabilities on these charts: 1. When they mouse-over the actual data, they want to be able to have a fly-over window show up with the exact value of what they are looking at (lower priority) 2. When they are moused-over the data, they want the ability to 'drill down' into the data by simply clicking on the column/data point/slice of pie chart/etc. (MUCH higher priority) My idea with pChart is to find out what the coordinates are for each of the points of data on the chart, overlay the image that is generated with an image map, and have the image map do the work then allowing them to 'click into' the chart, bringing them to either a new page or new chart, depending on the page they are on. So, first off, does anyone have any suggestions of a better/different way to do something like this? This is just the idea I've come up with so far, so I'm not committed/married to it. I just think that using the image map would be the best/fastest way of doing this. The next question I would pose to everyone out there is if they know of any other charting frameworks out there that do this same thing that they would recommend. If you have any more detailed questions or I am neglecting anything, please feel free to e-mail me at (cbuege at moreycorp dot com) or just post a reply to this message. Now, I'm aware that Google Charts can do this very nicely, but we are trying to keep all of the applications in house as the charts that will be generated won't always be on machines that will have internet access, so we don't want to depend on Google for files external to the company. Thanks in advance to anyone out there that can help!! Charles This e-mail, including attachments, may contain information that is confidential and/or proprietary, and may only be used by the person to whom this email is addressed. If the recipient of this e-mail is not the intended recipient or an authorized agent, the reader is hereby notified that any dissemination, distribution, or copying of this e-mail is prohibited. If this e-mail has been delivered to you in error, please notify the sender by replying to this message and deleting this e-mail immediately.
--- End Message ---
--- Begin Message ---Try the stripslashes() function. See on http://php.net/manual/en/function.stripslashes.php for details. Best regards. StevenHi All,I have a list of product in which WIRE MESH 24G X 3/4" is one of them. When I am trying to print the same its coming like WIRE MESH 24G X 3/4\". I want to remove the extra "\" backslash from the result page. Please help me withthis. Best, Guru.
--- End Message ---
