techker

October 17, 2007

i guess it could be pretty simple.no need for that.i was just referring to it.

October 17, 2007

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

September 20, 2007

You don't even need that get stuff, just update the counter each time.

You could also use a txt file instead.

update with what and how?any example of a code?

September 19, 2007

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.

September 19, 2007

if($_GET[""]){

$query = mysql_query("UPDATE table SET field = field+1");

}

Then just use a database fetching code to display it.

i put this on the main page?

September 19, 2007

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!

September 19, 2007

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?

July 27, 2007

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

July 26, 2007

no it isnt in this case tryed it..

July 26, 2007

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?

July 19, 2007

well i do hav a login systeme but it is on the index page not the splash.

thx for the link

July 19, 2007

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?

May 30, 2007

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

April 4, 2007

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

April 4, 2007

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

April 4, 2007

so if i change these words will it mess up my script?

April 4, 2007

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

February 7, 2007

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.

February 7, 2007

the thing is is that in the texte area i put item and qty.

but the hoel script is there.

February 7, 2007

il try it thanks

this is what i get in my email

Visitor mail

Messsage:

Item# QTY:

Item# tie raps QTY:2

Item# me QTY:1

Item# QTY:

Item# tie QTY:2

Item# QTY:

Visior IP: 74.12.225.178

Email techker@gmail.com

Messsage:

Please do not forget your phone number.thx

#sgsdgasdg

February 7, 2007

Change those \r to \r\n

sorry im confused

February 7, 2007

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. ???

January 31, 2007

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

January 16, 2007

thx buddy

January 15, 2007

perfect thx buddy

how does this work?i did but i can't explain it?

Sign In

techker

Posts

Joined

Last visited

Content Type

Profiles

Forums

Posts posted by techker

like a cms

like a cms

counter in admin panel

web hosting question

counter in admin panel

web hosting question

counter in admin panel

excel to php

PHP Excel Parser Pro how to

PHP Excel Parser Pro how to

remember setting box

remember setting box

need to script names please

error i can't find..

error i can't find..

error i can't find..

error i can't find..

order form help please

order form help please

order form help please

order form help please

order form help please

login script help

htaccess with existing login script?

htaccess with existing login script?

Browse

Activity

Important Information