Jump to content


  • Posts

  • Joined

  • Last visited

Everything posted by techker

  1. i guess it could be pretty simple.no need for that.i was just referring to it.
  2. hi guys im woundering if any body could help me find a tutorial for this: i have a friend that i made a web site for and he is a distributor. now he has some products that sell like hot cakes. i want to make him a page that contains his monthly hot cakes but i want him to update it. i have an idea but still a newbe at this.. i can make the database and some of the code.but i have now idea how to make this. thx for the help.hope im clear in my explanation..lol
  3. update with what and how?any example of a code?
  4. so basicly with a regular account you can control it but the c panel is only one? i only need something basic and cheap for now im just starting and low cash flow. thx for the link.
  5. hey guys i want to get a reseller account and im looking at so many deals !man every body has different plans and some rape big time!lol so i found one with very good rating and pretty cheap to 10 gigs with 150gigs bandwidth.. no my question is bandwidth.when is the bandwidth used the most is it good 150gigs? have a look at what they are offering.is there more for cheap..lol im not confident anymore there is to mutch out there.... and my regular hoster offers it to but a good price diffrence.. http://www.webhostingstuff.com/review/ScalaHosting.html and my hoster www.yrhost.com there for the help!
  6. hey guy,quick question. is there a way to put an invisible counter on my main page the retrieve the info in my admin panel?
  7. hey guys i have a book (php hack) it shows how to gen a php page with xml spread sheet. http://techker.prophp.org/test/ now is there a way to save that spread sheet in a database and fetch it aftherwords? im new to database so please be gental..lol here is the code index page with upload: PHP Code: <html> <body> <form enctype="multipart/form-data" action="import.php" method="post"> Excel XML file: <input type="hidden" name="MAX_FILE_SIZE" value="2000000" /> <input type="file" name="file" /><br/> <input type="submit" value="Upload" /> </form> </body> </html> import page (generater) PHP Code: <html> <body> <?php $data = array(); if ( $_FILES['file']['tmp_name'] ) { $dom = DOMDocument::load( $_FILES['file']['tmp_name'] ); $rows = $dom->getElementsByTagName( 'Row' ); foreach ($rows as $row) { $cells = $row->getElementsByTagName( 'Cell' ); $datarow = array(); foreach ($cells as $cell) { $datarow []= $cell->nodeValue; } $data []= $datarow; } } ?> <table> <?php foreach( $data as $row ) { ?> <tr> <?php foreach( $row as $item ) { ?> <td><?php echo( $item ); ?></td> <?php } ?> </tr> <?php } ?> </table> </body> </html> there is this to in the book but i have no clue how to use it.do i link it to the upload form? generates sql from xml <?php $tables = array(); $indata = 0; function encode( $text ) { $text = preg_replace( "/'/", "''", $text ); return "'".$text."'"; } function start_element( $parser, $name, $attribs ) { global $tables, $indata; if ( $name == "WORKSHEET" ) { $tables []= array( 'name' => $attribs['SS:NAME'], 'data' => array() ); } if ( $name == "ROW" ) { $tables[count($tables)-1]['data'] []= array(); } if ( $name == "DATA" ) { $indata = 1; } } function text( $parser, $text ) { global $tables, $indata; if ( $indata ) { $data =& $tables[count($tables)-1]['data']; $data[count($data)-1] []= $text; } } function end_element( $parser, $name ) { global $indata; if ( $name == "DATA" ) $indata = 0; } $parser = xml_parser_create( ); xml_set_element_handler( $parser, "start_element", "end_element" ); xml_set_character_data_handler( $parser, "text" ); while( !feof( STDIN ) ) { $text = fgets( STDIN ); xml_parse( $parser, $text ); } xml_parser_free( $parser ); foreach( $tables as $table ) { $name = $table['name']; $data =& $table['data']; $cols = implode( ", ", $data[0] ); for( $in = 1; $in < count( $data ); $in++ ) { $sqldata = implode( ", ", array_map( "encode", $data[$in] ) ); ?> INSERT INTO <?php echo( $name )?> ( <?php echo( $cols ) ?> ) VALUES ( <?php echo( $sqldata ); ?> ); <?php } } ?> what is command-line version of PHP ? they say to use it with this? this is what it says Use the command-line version of PHP to run the SQL generator script on the Excel XML data: % php gen.php < data.xml INSERT INTO Publisher ( ID, Name ) VALUES ( '0', 'O''Reilly' ); INSERT INTO Publisher ( ID, Name ) VALUES ( '0', 'Manning' ); INSERT INTO Publisher ( ID, Name ) VALUES ( '0', 'Wiley' ); INSERT INTO Publisher ( ID, Name ) VALUES ( '0', 'Addison-Wesley' ); INSERT INTO Publisher ( ID, Name ) VALUES ( '0', 'Pragmatic Press' ); INSERT INTO Publisher ( ID, Name ) VALUES ( '0', 'APress' ); You can also pipe this right into a file, for example: % php gen.php < data.xml > publishers.sql
  8. no it isnt in this case tryed it..
  9. any body know how to use this? so basicly it is good for importing excell sheets on a linux server and it converts it to php?? i have tryed it but i don't know how to retreive it from the database?
  10. well i do hav a login systeme but it is on the index page not the splash. thx for the link
  11. hey guys i have a splash page thats hase a choice of french or english site. but i want to add a remember choise button on the page so the clients don't have to always go tru the splash page every time? is it possible to do it in a simple way without going tru the login script?
  12. hey guys i need to scripts for a web site but im not shure what they are called or what to look for?: the first i need to be able to view excel sheets cause the distributor works with excel for price lists.i want him to be able to updates his lists him self.. is there such an apps that converst excell to html or pdf? and the other,he hase many price lists availible on the site i want to be able to list them and have check boxes in front to chose the ons they want to view and print.. i have that at work on are main intern web site ,when i want to view planogrames i chose which one i want and it merges to pdf. thx
  13. lol i have been looking at that work for about 10 minutes now and i new something was wrong with it..and even and i got the confirmation in anather forum to. now if i rename it to x_check will it have any concequence's to my script? and another guy told me to need to normalize that table what does he mean? what about this? fax VARCHAR(50), moneyorder VARCHAR(50), cc VARCHAR(' at line 61 mysql error number: 1064
  14. so i looked at the page and i can't find any words on my sql? its says on line fax VARCHAR(50), moneyorder VARCHAR(50), cc VARCHAR(50), so basicly i wold have to `fax` and `cc`? maybe http://www.mysql.com/news-and-events/newsletter/2002-10/a0000000075.html
  15. so if i change these words will it mess up my script?
  16. hey guys i got this when installing a script..i can't seem to find the probleme? <!-- Database error in SunShop Installer: Invalid SQL: CREATE TABLE options ( title VARCHAR(100), hometitle VARCHAR(100), shopurl VARCHAR(100), homeurl VARCHAR(100), securepath VARCHAR(100), companyname VARCHAR(100), address TEXT, city VARCHAR(30), state VARCHAR(20), zip VARCHAR(20), country VARCHAR(30), phone VARCHAR(20), faxnumber VARCHAR(20), contactemail VARCHAR(100), taxrate VARCHAR(10), shipups VARCHAR(5), grnd VARCHAR(5), nextdayair VARCHAR(5), seconddayair VARCHAR(5), threeday VARCHAR(5), canada VARCHAR(5), worldwidex VARCHAR(5), worldwidexplus VARCHAR(5), fixedshipping VARCHAR(5), method VARCHAR(15), rate VARCHAR(20), productpath VARCHAR(50), catimage VARCHAR(50), catopen VARCHAR(50), viewcartimage VARCHAR(50), viewaccountimage VARCHAR(50), checkoutimage VARCHAR(50), helpimage VARCHAR(50), cartimage VARCHAR(50), tablehead VARCHAR(50), tableheadtext VARCHAR(50), tableborder VARCHAR(50), tablebg VARCHAR(50), shipchart VARCHAR(50), ship1p1 VARCHAR(50), ship1us VARCHAR(50), ship1ca VARCHAR(50), ship2 VARCHAR(50), ship2p1 VARCHAR(50), ship2p2 VARCHAR(50), ship2us VARCHAR(50), ship2ca VARCHAR(50), ship3 VARCHAR(50), ship3p1 VARCHAR(50), ship3p2 VARCHAR(50), ship3us VARCHAR(50), ship3ca VARCHAR(50), ship4p1 VARCHAR(50), ship4us VARCHAR(50), ship4ca VARCHAR(50), visa VARCHAR(50), mastercard VARCHAR(50), discover VARCHAR(50), amex VARCHAR(50), check VARCHAR(50), fax VARCHAR(50), moneyorder VARCHAR(50), cc VARCHAR(50), payable VARCHAR(100), paypal VARCHAR(50), paypalemail VARCHAR(100), shopimage VARCHAR(100), centerborder VARCHAR(50), centerheader VARCHAR(50), centercolor VARCHAR(50), centerfont VARCHAR(50), centerbg VARCHAR(50), useheader VARCHAR(50), usefooter VARCHAR(50), myheader VARCHAR(50), myfooter VARCHAR(50), thumbheight VARCHAR(50), thumbwidth VARCHAR(50), picheight VARCHAR(50), picwidth VARCHAR(50), showstock VARCHAR(50), showitem VARCHAR(50), showintro VARCHAR(50), orderby VARCHAR(50), outofstock VARCHAR(50), cs VARCHAR(5), po VARCHAR(5), license VARCHAR(50), handling VARCHAR(20), imagel VARCHAR(1), showbestsellers varchar(5), showspecials varchar(5), language varchar(20), showcattotals varchar(5), shipcalc varchar(5), shipusps varchar(5), itemsperpage int(5), usesecurefooter varchar(5), mysecurefooter varchar(50), usesecureheader varchar(5), mysecureheader varchar(50), mustsignup varchar(5), uspsserver varchar(200), uspsuser varchar(100), uspspass varchar(100), catsdisplay VARCHAR(10), allwidth VARCHAR(10), centerwidth VARCHAR(10), tablewidth VARCHAR(10) ) mysql 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 'VARCHAR(50), fax VARCHAR(50), moneyorder VARCHAR(50), cc VARCHAR(' at line 61 mysql error number: 1064
  17. i juste need to make it more user frendly and less messy. cause it looks bad .lol i wold like to make a form with all of that but separeded so it looks nicer and when you receive it as well.
  18. the thing is is that in the texte area i put item and qty. but the hoel script is there.
  19. il try it thanks this is what i get in my email Visitor mail Messsage: Item# QTY: Item# QTY: Item# QTY: Item# QTY: Item# QTY: Item# QTY: Item# tie raps QTY:2 Item# me QTY:1 Item# QTY: Item# QTY: Item# tie QTY:2 Item# QTY: Item# QTY: Item# QTY: Item# QTY: Item# QTY: Item# QTY: Item# QTY: Item# QTY: Item# QTY: Item# QTY: Item# QTY: Item# QTY: Item# QTY: Item# QTY: Item# QTY: Item# QTY: Item# QTY: Item# QTY: Item# QTY: Item# QTY: Item# QTY: Item# QTY: Item# QTY: Visior IP: Email techker@gmail.com Messsage: Please do not forget your phone number.thx #sgsdgasdg
  20. hey guys i have this order form http://techker.vipzone.biz/enligne.php <? // Enter your Email below $myemail = ""; $ipi = getenv("REMOTE_ADDR"); if ($Submit) { if(!trim($visitor_name)) { $message = "<font color=red>Ton nom?</font>"; } else if(!trim($visitor_email)) { $message = "<font color=red>Ton email?</font>"; } else if(!trim($visitor_message)) { $message = "<font color=red>Ton messages?</font>"; } else { $todayis = date("l, F j, Y, g:i a"); $subject = "Commende en ligne"; $email_message = "Visitor mail \r Messsage: \r $visitor_message \r Visior IP: $ip \r Email $visitor_email\r Messsage: \r $visitor_comments "; $from = "De: $visitor_name<$visitor_email>"; mail ($myemail,$subject,$email_message,$from); $status = "sent"; } } ?> <!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=iso-8859-1" /> <title>ORDER FORM</title><style type="text/css"> <!-- body { background-color: #FFFFFF; } .style1 {color: #0000FF} .style2 {color: #003399; } --> </style></head> <body> <table width="530" height="746" border="0" align="center" cellpadding="0" cellspacing="0" bgcolor="#eaedef"> <tr> <td width="13" valign="top" bgcolor="#003399"> </td> <td width="507" height="19" valign="top" bgcolor="#003399"> </td> <td width="10" valign="top" bgcolor="#003399"> </td> </tr> <tr> <td width="13" valign="top" bgcolor="#003399"> </td> <td height="708" valign="top" background="finisht/members/images/feature_bg_bgw.gif"><table width="496" height="708" border="0" cellpadding="0" cellspacing="0"> <tr> <td width="496" height="708" valign="top"><? if ($status == "sent") { ?> <div align="center"> <span class="style2">Merci <? echo $visitor_name ?></span>(<? echo $visitor_email?>)<span class="style2"><br> Votre commande à été envoyer!<br> <br> Votre IP: <? echo $ip ?> </span><br> </div> <? } else { ?> <div align="center"><? echo $message ?></div> <form method="post" action="<? echo $_SERVER['finisht/members/PHP_SELF'] ?>"> <input type=hidden name="ip" value="<?php echo $ipi ?>"> <table width="100%" border="0" cellspacing="0" cellpadding="0"> <tr> <td bgcolor="#FFFFFF" class="style1"><div align="center" class="style1"></div> <div align="center" class="style1"></div></td> </tr> <tr> <td><div align="center"></div></td> </tr> <tr> <td><div align="center" class="style2">Name</div></td> </tr> <tr> <td><div align="center"> <input name="visitor_name" type="text" id="visitor_name" value="<? echo $visitor_name ?>"> </div></td> </tr> <tr> <td><div align="center" class="style2">Email </div></td> </tr> <tr> <td><div align="center"> <input name="visitor_email" type="text" id="visitor_email" value="<? echo $visitor_email ?>"> </div></td> </tr> <tr> <td><div align="center" class="style2">Your order (Please don't forget the QTY) </div></td> </tr> <tr> <td height="179"><div align="center"> <textarea name="visitor_message" cols="50" rows="15" id="visitor_message"><? echo $visitor_message ?> Item# QTY: Item# QTY: Item# QTY: Item# QTY: Item# QTY: Item# QTY: Item# QTY: Item# QTY: Item# QTY: Item# QTY: Item# QTY: Item# QTY: Item# QTY: Item# QTY: Item# QTY: Item# QTY: Item# QTY: Item# QTY: Item# QTY: Item# QTY: Item# QTY: Item# QTY: Item# QTY: Item# QTY: Item# QTY: Item# QTY: Item# QTY: Item# QTY: Item# QTY: Item# QTY: Item# QTY: Item# QTY: Item# QTY: Item# QTY: Item# QTY:</textarea> </div></td> </tr> <tr> <td height="97" valign="middle"><label><span class="style2">COMMENTS</span> <textarea name="visitor_comments" cols="60" rows="5"id="textarea"><? echo $visitor_comments ?> Please do not forget your phone number.thx #</textarea> </label></td> </tr> <tr> <td><div align="center"> <input name="Submit" type="submit" id="Submit" value="SEND"> <input type="reset" value="RESET"> </div></td> </tr> </table> </form> <? } ?></td> </tr> </table></td> <td width="10" valign="top" bgcolor="#003399"> </td> </tr> <tr> <td width="13" valign="top" bgcolor="#003399"> </td> <td height="19" valign="top" bgcolor="#003399"> </td> <td width="10" valign="top" bgcolor="#003399"> </td> </tr> </table> </body> </html> se the probleme is that it is very ugly and hard to read when i receive it in my emails. i need help for the reason that i wold like to make this form in one.not seperated. or if there is one that is already made . any body have an idea how i could make it nicer? thx for the help. ???
  21. hey guys i have this login script and the signup confirmation email does not work for hotmail accounts? is there a code i have to add or something??lol thx
  22. perfect thx buddy how does this work?i did but i can't explain it?
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.