bonanzab

what's wrong with this code?

bonanzab replied to bonanzab's topic in PHP Coding Help

It's pointing to the right path, also if the path is wrong, it would not work on the website

what's wrong with this code?

bonanzab posted a topic in PHP Coding Help

Hi everyone It's been days trying to get this code to work with microweb server. The script works fine on my website, when I try it on microweb (a local server) it works with a minor error. For some unknown reason the leaf image does not show, it skips this code echo '<td width="17%" height="7" bgcolor="#009900" align="center">'; if (file_exists($partpath5)){ echo '<img width="120" height="120" and goes to thise code. Can someone please help me, I'm going nuts. }else{ echo '<img width="120" height="120" src="'.$imgpath5.'N/NPA.jpg">'; <?PHP function alert($alert) { $out .='<script type="text/javascript"> alert("'.$alert.'"); </script> '; print $out; } function find($name, $view){ global $link; switch($view){ case '1': $column = 'Bloom_Name'; break; case '2': $column = 'Pod_Name'; break; case '3': $column = 'Pollen_Name'; break; case '4': $column = 'Hybridiser'; break; case '5': $column = 'Origin'; break; case '6': $column = 'appove'; break; case '7': $column = 'Leaf_Image'; break; default: $column = 'Bloom_Name'; break; } $connection = mysql_connect("localhost","root","")or die(mysql_error()); $db_select =mysql_select_db('internb7', $connection) or die ("Couldn't select database."); $SQL = "SELECT Bloom_Name, Pod_Name, Pollen_Name, Hybridiser, Origin, approve, Leaf_Image " . "FROM ihsreg " . "WHERE " . $column . " LIKE '" . $name . "' AND $column != '' " . "ORDER BY Bloom_Name ASC"; $result = mysql_query($SQL); $num=mysql_num_rows($result); $results = array(); while($row = mysql_fetch_row($result)){ $results[] = $row; } return $results; } $noimagemessage = "No Photo Available"; if(isset($_GET['search'])){ $search = urldecode(urldecode($_GET['search'])); $y = 0; $results[0]=Array(); $results[1]=Array(); $results[2]=Array(); $results[3]=Array(); $results[4]=Array(); $results[5]=Array(); $results[6]=Array(); $results = find($search,$_GET['view']); $y = sizeof($results); } ?> <html> <head> <title>Untitled Document</title> <meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1"> <style type="text/css"> img{ border:0; } </style> <script type="text/javascript"> function open_win(img){ window.open("cvdata1.php?search="+img); } </script> </head> <body bgcolor="#FFFFFF" BACKGROUND="http://localhost/cvimages/b2a.jpg"><body> <div align="center"><img src="http://localhost/SEimages/CVtittle.gif" width="320" height="65"> Click On Image For Details <table border=2 width="100%" bordercolor="#006666" cellpadding="1" cellspacing="1" bordercolorlight="#999900" bordercolordark="#CCCC00"> <?PHP for($x=0; $x<count(@$results); $x++){ echo '<tr>'; echo '<th width="17%" height="7" align="center" bgcolor="#CCFFCC">Cultivar</th>'; echo '<th width="16%" height="7" align="center" bgcolor="#339999">Pod Parent</th>'; echo '<th width="17%" height="7" align="center" bgcolor="#99CCCC">Pollen Parent</th>'; echo '<th width="17%" height="7" align="center" bgcolor="#CCCC99">Hybridizer</th>'; echo '<th width="16%" height="7" align="center" bgcolor="#CCCC33">Origin</th>'; echo '<th width="17%" height="7" align="center" bgcolor="#009900">Leaf</th>'; echo '</tr>'; echo '<tr>'; $pathroot="http://localhost/"; $imgpath=$pathroot.""; $imgpath3=$pathroot."Hybridizer/"; $imgpath4=$pathroot."Origin/"; $imgpath5=$pathroot."Leaf/"; $img0=ucwords(trim($results[$x][0])); $img1=ucwords(trim($results[$x][1])); $img2=ucwords(trim($results[$x][2])); $img3=ucwords(trim($results[$x][3])); $img4=ucwords(trim($results[$x][4])); $img5=ucwords(trim($results[$x][5])); $img_1=ucwords(trim($results[$x][1])); $img_2=ucwords(trim($results[$x][2])); $img_3=ucwords(trim($results[$x][3])); $img_4=ucwords(trim($results[$x][4])); $img_5=ucwords(trim($results[$x][5])); $img_5=substr($img5,0,-4); $appr=strtoupper(trim($results[$x][0])); $subpath0=substr($img0,0,1)."/"; $subpath1=substr($img1,0,1)."/"; $subpath2=substr($img2,0,1)."/"; $subpath3=substr($img3,0,1)."/"; $subpath4=substr($img4,0,1)."/"; $subpath5=substr($img5,0,1)."/"; $partpath0=$subpath0.$img0.".jpg"; $partpath1=$subpath1.$img1.".jpg"; $partpath2=$subpath2.$img2.".jpg"; $partpath3="Hybridizer/".$subpath3.$img3.".jpe"; $partpath4="Origin/".$subpath4.$img4.".jpe"; $partpath5="Leaf/".$subpath5.$img5; $fullpath0=$imgpath.$partpath0; $fullpath1=$imgpath.$partpath1; $fullpath2=$imgpath.$partpath2; $fullpath3=$imgpath.$partpath3; $fullpath4=$imgpath.$partpath4; $fullpath5=$imgpath.$partpath5; echo '<td width="17%" height="7" bgcolor="#CCFFCC" align="center">'; if (trim($appr) == "True" || trim($appr)=="TRUE") { if (file_exists($partpath0)){ echo '<a href="cvdata1.php?search='.$img0.'"'.'target="_blank"><img width="120" height="120" src="'.$fullpath0.'"></a>'; }else{ echo '<img width="120" height="120" src="'.$imgpath.'N/NBA.jpe">'; } } else { echo '<img width="120" height="120" src="'.$imgpath.'B/BRP.jpe">'; } echo ' '.$img0."</td>"; /* No 1 Pod */ echo '<td width="16%" height="7" bgcolor="#339999" align="center">'; if (file_exists($partpath1)){ if ($img1=="Unknown"){ echo '<img width="120" height="120" src="'.$fullpath1.'">'; }else{ echo '<a href="cvdata1.php?search='.$img1.'"'.'target="_blank"><img width="120" height="120" src="'.$fullpath1.'"></a>'; } }else{ echo '<img width="120" height="120" src="'.$imgpath.'N/NBA.jpe">'; } echo ' '.$img_1."</td>"; /* No 2 Pollen */ echo '<td width="17%" height="7" bgcolor="#99CCCC" align="center">'; if (file_exists($partpath2)){ if ($img2=="Unknown"){ echo '<img width="120" height="120" src="'.$fullpath2.'">'; }else{ echo '<a href="cvdata1.php?search='.$img2.'"'.'target="_blank"><img width="120" height="120" src="'.$fullpath2.'"></a>'; } }else{ echo '<img width="120" height="120" src="'.$imgpath.'N/NBA.jpe">'; } echo ' '.$img_2."</td>"; /* No 3 Hybridiser */ echo '<td width="17%" height="7" bgcolor="#CCCC99" align="center">'; if (file_exists($partpath3)){ if ($img3=="Unknown"){ echo '<img width="120" height="120" src="'.$fullpath3.'">'; }else{ echo '<a href="cvdata1.php?search='.$img3.'"'.'target="_blank"><img width="120" height="120" src="'.$fullpath3.'"></a>'; } }else{ echo '<img width="120" height="120" src="'.$imgpath3.'H/HNP.jpe">'; } echo ' '.$img3."</td>"; /* No 4 Origin */ echo '<td width="16%" height="7" bgcolor="#CCCC33" align="center">'; if (file_exists($partpath4)){ if ($img4=="Unknown"){ echo '<img width="120" height="120" src="'.$fullpath4.'">'; }else{ echo '<a href="cvdata1.php?search='.$img4.'"'.'target="_blank"><img width="120" height="120" src="'.$fullpath4.'"></a>'; } }else{ echo '<img width="120" height="120" src="'.$imgpath4.'O/ONP.gif">'; } echo ' '.$img4."</td>"; /* No 5 Leaf */ echo '<td width="17%" height="7" bgcolor="#009900" align="center">'; if (file_exists($partpath5)){ echo '<img width="120" height="120" src="'.$fullpath5.'">'; }else{ echo '<img width="120" height="120" src="'.$imgpath5.'N/NPA.jpg">'; } echo ' '.$img_5."</td>"; echo '</tr>'; echo '<tr><td colspan=5> </td></tr>'; } if(count(@$results[0])==0){ echo '<tr><td width="100%" colspan=5 align="center">No results found.</td></tr>'; } ?> </table> </div> </body> </html>

Text database to Mysql

bonanzab posted a topic in PHP Coding Help

Hi Everyone, Let me start by saying that I do not know anything about PHP script. I have this script that I would like to change but I don't have the foggiest idea on how to do it. Presently this script reads from a text file that use this type of “|”separator, now I would like to change this code to read from a Mysql database, plus add other fields that are not currently read. I know that some of you like the challenge and I can tell you that this will be so. Is there anyone that will do this for free? This is part of the script, I can post the rest or email the rest to the person who is willing to help. [!--quoteo--][div class=\'quotetop\']QUOTE[/div][div class=\'quotemain\'][!--quotec--]<?PHP if(isset($_POST['search'])){ $fp = file("reg.txt"); $search = "/".$_POST['search']."/i"; $y = 0; $results[0]=Array(); $results[1]=Array(); $results[2]=Array(); $results[3]=Array(); $results[4]=Array(); for($x=0; $x<count($fp); $x++){ $search_text = ""; if(@$_POST['radiobutton']==5){ $search_text = split("\|",$fp[$x]); $search_text = $search_text[4]; }else if(@$_POST['radiobutton']==4){ $search_text = split("\|",$fp[$x]); $search_text = $search_text[3]; }else if(@$_POST['radiobutton']==3){ $search_text = split("\|",$fp[$x]); $search_text = $search_text[2]; }else if(@$_POST['radiobutton']==2){ $search_text = split("\|",$fp[$x]); $search_text = $search_text[1]; }else{ $search_text = split("\|",$fp[$x]); $search_text = $search_text[0]; } if(preg_match($search,$search_text)){ list($results[0][$y],$results[1][$y],$results[2][$y],$results[3][$y],$results[4][$y])=split("\|",$fp[$x]); $y++; } } [/quote]

March 17, 2006

Sign In

Posts

Joined

Last visited

Profile Information

bonanzab's Achievements

Newbie (1/5)

Reputation

what's wrong with this code?

what's wrong with this code?

Text database to Mysql

Browse

Activity

Important Information