lilywong

any ideas? thanks.

I need to send email to my hotmail. below is my php code <? $from = "test"; $to_mail = "testing@hotmail.com"; $message = "Hello Admin Here is a Request mail from user"; $subject = "Request Mail From User"; $headers = "From: $from \r\n"; $headers .= "MIME-Version: 1.0\n" . "Content-type: text/html; charset=iso-8859-1"; $message = stripslashes($message); mail($to_mail, $subject, $message, $headers); print("Sent"); ?> below is the setting in php.ini however, i receive this msg while i run the script Warning: mail(): SMTP server response: 530 5.7.0 Must issue a STARTTLS command first in C:\Program Files\Apache Group\Apache2\htdocs\testfolder\testforemail.php on line 13 can any one advise?

i need to output mysql query to PDF. i am using the below writehtml() function. however, i cannot have align & rowspan. pls advise where can i add so i can adjust my td align= "right", or rowpsan="2". ths. <?php //Based on HTML2PDF by Clément Lavoillotte require('fpdf.php'); //function hex2dec //returns an associative array (keys: R,G,B) from //a hex html code (e.g. #3FE5AA) function hex2dec($couleur = "#000000"){ $R = substr($couleur, 1, 2); $rouge = hexdec($R); $V = substr($couleur, 3, 2); $vert = hexdec($V); $B = substr($couleur, 5, 2); $bleu = hexdec($B); $tbl_couleur = array(); $tbl_couleur['R']=$rouge; $tbl_couleur['G']=$vert; $tbl_couleur['B']=$bleu; return $tbl_couleur; } //conversion pixel -> millimeter in 72 dpi function px2mm($px){ return $px*25.4/72; } function txtentities($html){ $trans = get_html_translation_table(HTML_ENTITIES); $trans = array_flip($trans); return strtr($html, $trans); } //////////////////////////////////// class PDF extends FPDF { //variables of html parser var $B; var $I; var $U; var $HREF; var $fontList; var $issetfont; var $issetcolor; function PDF($orientation='P', $unit='mm', $format='A4') { //Call parent constructor $this->FPDF($orientation,$unit,$format); //Initialization $this->B=0; $this->I=0; $this->U=0; $this->HREF=''; $this->tableborder=0; $this->tdbegin=false; $this->tdwidth=0; $this->tdheight=0; $this->tdalign="L"; $this->tdbgcolor=false; $this->oldx=0; $this->oldy=0; $this->fontlist=array("arial","times","courier","helvetica","symbol"); $this->issetfont=false; $this->issetcolor=false; } ////////////////////////////////////// //this function is to add the PDF header function Header() { //Logo //$this->Image('../../image/SIF_Logo3.jpg',10,8,33); //Arial bold 15 $this->SetFont('Arial','B',15); //Move to the right //$this->Cell(80); //$this->Cell(30,10,'Title',1,0,'L'); //Line break //$this->Ln(15); } //this function is to add the PDF footer function Footer() { //Position at 1.5 cm from bottom $this->SetY(-15); //Arial italic 8 $this->SetFont('Arial','I',; //Page number $this->Cell(0,10,' Page '.$this->PageNo().'/{nb}',0,0,'C'); } //html parser function WriteHTML($html) { $html=strip_tags($html,"<b><u><i><a><img><p><br><strong><em><font><tr><blockquote><hr><td><tr><table><sup>"); //remove all unsupported tags $html=str_replace("\n",'',$html); //replace carriage returns by spaces $html=str_replace("\t",'',$html); //replace carriage returns by spaces $a=preg_split('/<(.*)>/U',$html,-1,PREG_SPLIT_DELIM_CAPTURE); //explodes the string foreach($a as $i=>$e) { if($i%2==0) { //Text if($this->HREF) $this->PutLink($this->HREF,$e); elseif($this->tdbegin) { if(trim($e)!='' && $e!=" ") { $this->Cell($this->tdwidth,$this->tdheight,$e,$this->tableborder,'',$this->tdalign,$this->tdbgcolor); } elseif($e==" ") { $this->Cell($this->tdwidth,$this->tdheight,'',$this->tableborder,'',$this->tdalign,$this->tdbgcolor); } } else $this->Write(5,stripslashes(txtentities($e))); } else { //Tag if($e[0]=='/') $this->CloseTag(strtoupper(substr($e,1))); else { //Extract attributes $a2=explode(' ',$e); $tag=strtoupper(array_shift($a2)); $attr=array(); foreach($a2 as $v) { if(preg_match('/([^=]*)=["\']?([^"\']*)/',$v,$a3)) $attr[strtoupper($a3[1])]=$a3[2]; } $this->OpenTag($tag,$attr); } } } } function OpenTag($tag, $attr) { //Opening tag switch($tag){ case 'SUP': if( !empty($attr['SUP']) ) { //Set current font to 6pt $this->SetFont('','',6); //Start 125cm plus width of cell to the right of left margin //Superscript "1" $this->Cell(2,2,$attr['SUP'],0,0,'L'); } break; case 'TABLE': // TABLE-BEGIN if( !empty($attr['BORDER']) ) $this->tableborder=$attr['BORDER']; else $this->tableborder=0; break; case 'TR': //TR-BEGIN break; case 'TD': // TD-BEGIN if( !empty($attr['WIDTH']) ) $this->tdwidth=($attr['WIDTH']/4); else $this->tdwidth=40; // Set to your own width if you need bigger fixed cells if( !empty($attr['HEIGHT']) ) $this->tdheight=($attr['HEIGHT']/6); //the below here is the set line spacing else $this->tdheight=4.5; // Set to your own height if you need bigger fixed cells if( !empty($attr['ALIGN']) ) { $align=$attr['ALIGN']; if($align=='LEFT') $this->tdalign='L'; if($align=='CENTER') $this->tdalign='C'; if($align=='RIGHT') $this->tdalign='R'; } else $this->tdalign='L'; // Set to your own if( !empty($attr['BGCOLOR']) ) { $coul=hex2dec($attr['BGCOLOR']); $this->SetFillColor($coul['R'],$coul['G'],$coul['B']); $this->tdbgcolor=true; } $this->tdbegin=true; break; case 'HR': if( !empty($attr['WIDTH']) ) $Width = $attr['WIDTH']; else $Width = $this->w - $this->lMargin-$this->rMargin; $x = $this->GetX(); $y = $this->GetY(); $this->SetLineWidth(0.2); $this->Line($x,$y,$x+$Width,$y); $this->SetLineWidth(0.2); $this->Ln(1); break; case 'STRONG': $this->SetStyle('B',true); break; case 'EM': $this->SetStyle('I',true); break; case 'B': case 'I': case 'U': $this->SetStyle($tag,true); break; case 'A': $this->HREF=$attr['HREF']; break; case 'IMG': if(isset($attr['SRC']) && (isset($attr['WIDTH']) || isset($attr['HEIGHT']))) { if(!isset($attr['WIDTH'])) $attr['WIDTH'] = 0; if(!isset($attr['HEIGHT'])) $attr['HEIGHT'] = 0; $this->Image($attr['SRC'], $this->GetX(), $this->GetY(), px2mm($attr['WIDTH']), px2mm($attr['HEIGHT'])); } break; case 'BLOCKQUOTE': case 'BR': $this->Ln(5); break; case 'P': $this->Ln(10); break; case 'FONT': if (isset($attr['COLOR']) && $attr['COLOR']!='') { $coul=hex2dec($attr['COLOR']); $this->SetTextColor($coul['R'],$coul['G'],$coul['B']); $this->issetcolor=true; } if (isset($attr['FACE']) && in_array(strtolower($attr['FACE']), $this->fontlist)) { $this->SetFont(strtolower($attr['FACE'])); $this->issetfont=true; } if (isset($attr['FACE']) && in_array(strtolower($attr['FACE']), $this->fontlist) && isset($attr['SIZE']) && $attr['SIZE']!='') { $this->SetFont(strtolower($attr['FACE']),'',$attr['SIZE']); $this->issetfont=true; } break; } } function CloseTag($tag) { //Closing tag if($tag=='SUP') { } if($tag=='TD') { // TD-END $this->tdbegin=false; $this->tdwidth=0; $this->tdheight=0; $this->tdalign="L"; $this->tdbgcolor=false; } if($tag=='TR') { // TR-END $this->Ln(); } if($tag=='TABLE') { // TABLE-END //$this->Ln(); $this->tableborder=0; } if($tag=='STRONG') $tag='B'; if($tag=='EM') $tag='I'; if($tag=='B' || $tag=='I' || $tag=='U') $this->SetStyle($tag,false); if($tag=='A') $this->HREF=''; if($tag=='FONT'){ if ($this->issetcolor==true) { $this->SetTextColor(0); } if ($this->issetfont) { $this->SetFont('arial'); $this->issetfont=false; } } } function SetStyle($tag, $enable) { //Modify style and select corresponding font $this->$tag+=($enable ? 1 : -1); $style=''; foreach(array('B','I','U') as $s) { if($this->$s>0) $style.=$s; } $this->SetFont('',$style); } function PutLink($URL, $txt) { //Put a hyperlink $this->SetTextColor(0,0,255); $this->SetStyle('U',true); $this->Write(5,$txt,$URL); $this->SetStyle('U',false); $this->SetTextColor(0); } }//end of class ?>

Anyone know how to import excel to Mysql front? i have some listing data in excel, and i wanna import the data to MySQL front db... thanks thanks:)

i wish to get the result as pepsi, for example, i want to select the top selling drink in the shop, so i need to query to return me pepsi, coz pepsi appear 5 times. thanks.

i have a table data as below: [b] Item[/b] pepsi pepsi orange milo orange milo milo orange pepsi pepsi pepsi i want to count and get the maximum data, which is pepsi in this case, how should i do in mysql

<table> <? echo getName(); ?> <table> <? function getName() {   $a = "test";   return $a; } ?> when i echo the function, i should get test, right ? anything wrong there as when i echo i see nothing. thanks.

i have today date 20060727111953 (DateCreate), i want the DateAssign to be automatically become 20070727111953 , how should i do that ?

i found a solution of this, but the data output is all in one line, i have  use the "\n", but everything still printed out in one line, just wondering, i wanna the record to be printed out in many lines based on different ID. for ($i = 0; $i < $fields; $i++) {     $header .= mysql_field_name($export, $i) . "|"; } while($row = mysql_fetch_row($export)) {     $line = '';     foreach($row as $value) {         if ((!isset($value)) OR ($value == "")) {             $value = "|";         } else {             //$value = str_replace('|', '', $value);             $value = "|".$value."|";         }         $line .= $value;     }     //$data .= trim($line). "\n";     $data .= $line."\n"; } //$data = str_replace("\r","",$data); if ($data == "") {     $data = "\n(0) Records Found!\n"; } header("Content-type: application/x-msdownload"); header("Content-Disposition: attachment; filename=extraction.txt"); header("Pragma: no-cache"); header("Expires: 0"); print "$header\n$data";

just want to export some data, possibly 100 records from database, and save in abc.txt, that's it. not for backup, is for a report. like CSV file.

[quote author=legohead6 link=topic=102045.msg404886#msg404886 date=1154052078] Pg 1 [code]SESSION_START(); $_SESSION['user']="$variable"; [/code] the $variable i have is not a defined variable, it is an object, and point to a class file to get the data. in pg1, if i echo echo $user->UserName, it just work fine. when i click to pg2, and echo the same thing, nothing comes out! if i simply define $_SESSION['user']="test";, and i echo $_SESSION['user'] in pg2, it just works fine.

i did this, but no print out comes out. //register session $user = $this_user; echo $user; the echo print out Object id #2 when i do this //register session $user = $this_user; echo $user->domainName; the echo can print out the domainName, for eg, homeHosting

i am using the old session syntax to create the session, it works fine in index.php, but while i click a hyperlink to page2, the session is gone, where when i echo nothing comes out, usually what kind of problem is it ? thanks

Any idea of exporting a mysql data to a textfile, saved it as file.txt ?

I have a set of checkbox as below * Soft Drink * Cold Drink * Mineral Water * None <code> <input type="checkbox" name="chkFolder1" value="001">Soft Drink <input type="checkbox" name="chkFolder2" value="002">Cold Drink <input type="checkbox" name="chkFolder3" value="003">Mineral Water <input type="checkbox" name="chkFolder4" value="004">None </code> User allow to select multiple choice from the set of checkbox, for eg, user select soft drink and mineral water, these 2 items will be saved into a database, as (001,003) in a same field called choice. when i retrive from database, how should i separate the data from choice so that soft drink and mineral water is checked when i retrive the data? thanks