-
Posts
2 -
Joined
-
Last visited
Never
Posts posted by cyber-drugs
-
-
http://cyber-lane.com/Clients/Projects/1/2...t/PC/images.php
The above image is being cropped when it should be re-sizing, can someone help me with the code to fix it?
[!--PHP-Head--][div class=\'phptop\']PHP[/div][div class=\'phpmain\'][!--PHP-EHead--]
[span style=\"color:#0000BB\"]<?
$flag [/span][span style=\"color:#007700\"]= [/span][span style=\"color:#0000BB\"]imagecreatefrompng[/span][span style=\"color:#007700\"]([/span][span style=\"color:#DD0000\"]\'Graphics/Backgrounds/africa.png\'[/span][span style=\"color:#007700\"]);
[/span][span style=\"color:#0000BB\"]$mask [/span][span style=\"color:#007700\"]= [/span][span style=\"color:#0000BB\"]imagecreatefrompng[/span][span style=\"color:#007700\"]([/span][span style=\"color:#DD0000\"]\'Graphics/Nodes/shapes.png\'[/span][span style=\"color:#007700\"]);
[/span][span style=\"color:#0000BB\"]imagealphablending[/span][span style=\"color:#007700\"]([/span][span style=\"color:#0000BB\"]$flag[/span][span style=\"color:#007700\"], [/span][span style=\"color:#0000BB\"]1[/span][span style=\"color:#007700\"]);
[/span][span style=\"color:#0000BB\"]imagealphablending[/span][span style=\"color:#007700\"]([/span][span style=\"color:#0000BB\"]$mask[/span][span style=\"color:#007700\"], [/span][span style=\"color:#0000BB\"]1[/span][span style=\"color:#007700\"]);
[/span][span style=\"color:#0000BB\"]imagecopy[/span][span style=\"color:#007700\"]([/span][span style=\"color:#0000BB\"]$flag[/span][span style=\"color:#007700\"], [/span][span style=\"color:#0000BB\"]$mask[/span][span style=\"color:#007700\"], [/span][span style=\"color:#0000BB\"]200[/span][span style=\"color:#007700\"],[/span][span style=\"color:#0000BB\"]200[/span][span style=\"color:#007700\"],[/span][span style=\"color:#0000BB\"]0[/span][span style=\"color:#007700\"],[/span][span style=\"color:#0000BB\"]0[/span][span style=\"color:#007700\"],[/span][span style=\"color:#0000BB\"]135[/span][span style=\"color:#007700\"],[/span][span style=\"color:#0000BB\"]101[/span][span style=\"color:#007700\"]);
[/span][span style=\"color:#FF8000\"]//------------------------------------
[/span][span style=\"color:#0000BB\"]$mask [/span][span style=\"color:#007700\"]= [/span][span style=\"color:#0000BB\"]imagecreatefrompng[/span][span style=\"color:#007700\"]([/span][span style=\"color:#DD0000\"]\'Graphics/Nodes/shapes2.png\'[/span][span style=\"color:#007700\"]);
[/span][span style=\"color:#0000BB\"]imagealphablending[/span][span style=\"color:#007700\"]([/span][span style=\"color:#0000BB\"]$flag[/span][span style=\"color:#007700\"], [/span][span style=\"color:#0000BB\"]1[/span][span style=\"color:#007700\"]);
[/span][span style=\"color:#0000BB\"]imagealphablending[/span][span style=\"color:#007700\"]([/span][span style=\"color:#0000BB\"]$mask[/span][span style=\"color:#007700\"], [/span][span style=\"color:#0000BB\"]1[/span][span style=\"color:#007700\"]);
[/span][span style=\"color:#0000BB\"]imagecopy[/span][span style=\"color:#007700\"]([/span][span style=\"color:#0000BB\"]$flag[/span][span style=\"color:#007700\"], [/span][span style=\"color:#0000BB\"]$mask[/span][span style=\"color:#007700\"], [/span][span style=\"color:#0000BB\"]400[/span][span style=\"color:#007700\"],[/span][span style=\"color:#0000BB\"]400[/span][span style=\"color:#007700\"],[/span][span style=\"color:#0000BB\"]0[/span][span style=\"color:#007700\"],[/span][span style=\"color:#0000BB\"]0[/span][span style=\"color:#007700\"],[/span][span style=\"color:#0000BB\"]135[/span][span style=\"color:#007700\"],[/span][span style=\"color:#0000BB\"]101[/span][span style=\"color:#007700\"]);
[/span][span style=\"color:#FF8000\"]//------------------------------------
[/span][span style=\"color:#0000BB\"]$final [/span][span style=\"color:#007700\"]= [/span][span style=\"color:#0000BB\"]imagecreatefrompng[/span][span style=\"color:#007700\"]([/span][span style=\"color:#DD0000\"]\'Graphics/PDA.png\'[/span][span style=\"color:#007700\"]);
[/span][span style=\"color:#0000BB\"]$mask [/span][span style=\"color:#007700\"]= [/span][span style=\"color:#0000BB\"]$flag[/span][span style=\"color:#007700\"];
[/span][span style=\"color:#0000BB\"]imagealphablending[/span][span style=\"color:#007700\"]([/span][span style=\"color:#0000BB\"]$final[/span][span style=\"color:#007700\"], [/span][span style=\"color:#0000BB\"]1[/span][span style=\"color:#007700\"]);
[/span][span style=\"color:#0000BB\"]imagealphablending[/span][span style=\"color:#007700\"]([/span][span style=\"color:#0000BB\"]$mask[/span][span style=\"color:#007700\"], [/span][span style=\"color:#0000BB\"]1[/span][span style=\"color:#007700\"]);
[/span][span style=\"color:#0000BB\"]imagecopy[/span][span style=\"color:#007700\"]([/span][span style=\"color:#0000BB\"]$final[/span][span style=\"color:#007700\"], [/span][span style=\"color:#0000BB\"]$mask[/span][span style=\"color:#007700\"], [/span][span style=\"color:#0000BB\"]0[/span][span style=\"color:#007700\"],[/span][span style=\"color:#0000BB\"]0[/span][span style=\"color:#007700\"],[/span][span style=\"color:#0000BB\"]0[/span][span style=\"color:#007700\"],[/span][span style=\"color:#0000BB\"]0[/span][span style=\"color:#007700\"],[/span][span style=\"color:#0000BB\"]400[/span][span style=\"color:#007700\"],[/span][span style=\"color:#0000BB\"]300[/span][span style=\"color:#007700\"]);
[/span][span style=\"color:#FF8000\"]//------------------------------------
[/span][span style=\"color:#0000BB\"]Header[/span][span style=\"color:#007700\"]([/span][span style=\"color:#DD0000\"]\"Content-type: image/jpeg\"[/span][span style=\"color:#007700\"]);
[/span][span style=\"color:#0000BB\"]imagepng[/span][span style=\"color:#007700\"]([/span][span style=\"color:#0000BB\"]$final[/span][span style=\"color:#007700\"]);
[/span][span style=\"color:#0000BB\"]?>
[/span]
[/span][!--PHP-Foot--][/div][!--PHP-EFoot--]
Many thanks.
PHP CSV
in Editor Help (PhpStorm, VS Code, etc)
Posted
This file used to work, and then I changed something, and now it's messed...
I can't seem to find the problem.
ERROR:
URL: http://www.cyber-lane.com/Clients/Projects.../Script/CSV.php
[!--PHP-Head--][div class=\'phptop\']PHP[/div][div class=\'phpmain\'][!--PHP-EHead--]
[span style=\"color:#0000BB\"]<?php
[/span][span style=\"color:#FF8000\"]//----------------------------------------------------------------------------------------------------------
// Connect to Database Function
//----------------------------------------------------------------------------------------------------------
[/span][span style=\"color:#007700\"]function [/span][span style=\"color:#0000BB\"]DatabaseConnect[/span][span style=\"color:#007700\"]([/span][span style=\"color:#0000BB\"]$location[/span][span style=\"color:#007700\"], [/span][span style=\"color:#0000BB\"]$username[/span][span style=\"color:#007700\"], [/span][span style=\"color:#0000BB\"]$password[/span][span style=\"color:#007700\"], [/span][span style=\"color:#0000BB\"]$database[/span][span style=\"color:#007700\"])
{
[/span][span style=\"color:#0000BB\"]$conn [/span][span style=\"color:#007700\"]= [/span][span style=\"color:#0000BB\"]mysql_connect[/span][span style=\"color:#007700\"]([/span][span style=\"color:#0000BB\"]$location[/span][span style=\"color:#007700\"],[/span][span style=\"color:#0000BB\"]$username[/span][span style=\"color:#007700\"],[/span][span style=\"color:#0000BB\"]$password[/span][span style=\"color:#007700\"]);
if (&[/span][span style=\"color:#FF8000\"]#33;$conn) die (\"Could not connect MySQL\");
[/span][span style=\"color:#0000BB\"]mysql_select_db[/span][span style=\"color:#007700\"]([/span][span style=\"color:#0000BB\"]$database[/span][span style=\"color:#007700\"],[/span][span style=\"color:#0000BB\"]$conn[/span][span style=\"color:#007700\"]) or die ([/span][span style=\"color:#DD0000\"]\"Could not open database\"[/span][span style=\"color:#007700\"]);
}
[/span][span style=\"color:#FF8000\"]//----------------------------------------------------------------------------------------------------------
// Connect to Database
//----------------------------------------------------------------------------------------------------------
[/span][span style=\"color:#0000BB\"]DatabaseConnect[/span][span style=\"color:#007700\"]([/span][span style=\"color:#DD0000\"]\"localhost\"[/span][span style=\"color:#007700\"], [/span][span style=\"color:#DD0000\"]\"****\"[/span][span style=\"color:#007700\"], [/span][span style=\"color:#DD0000\"]\"****\"[/span][span style=\"color:#007700\"], [/span][span style=\"color:#DD0000\"]\"****\"[/span][span style=\"color:#007700\"]);
[/span][span style=\"color:#0000BB\"]?>
[/span]<!DOCTYPE HTML PUBLIC \"-//W3C//DTD HTML 4.01 Transitional//EN\" \"http://www.w3.org/TR/html4/loose.dtd\">
<html>
<head>
<title>Cyber-Lane™</title>
<meta http-equiv=\"Content-Type\" content=\"text/html; charset=iso-8859-1\">
</head>
<body>
[span style=\"color:#0000BB\"]<?php
[/span][span style=\"color:#FF8000\"]//----------------------------------------------------------------------------------------------------------
// Extract information from comma separated values
//----------------------------------------------------------------------------------------------------------
[/span][span style=\"color:#0000BB\"]$csv [/span][span style=\"color:#007700\"]= [/span][span style=\"color:#0000BB\"]file[/span][span style=\"color:#007700\"]([/span][span style=\"color:#DD0000\"]\"imi_gallery_database.csv\"[/span][span style=\"color:#007700\"]);
[/span][span style=\"color:#0000BB\"]$count [/span][span style=\"color:#007700\"]= [/span][span style=\"color:#0000BB\"]count[/span][span style=\"color:#007700\"]([/span][span style=\"color:#0000BB\"]$csv[/span][span style=\"color:#007700\"]);
[/span][span style=\"color:#FF8000\"]//----------------------------------------------------------------------------------------------------------
// Drop Table
//----------------------------------------------------------------------------------------------------------
[/span][span style=\"color:#0000BB\"]$sql[/span][span style=\"color:#007700\"]=[/span][span style=\"color:#DD0000\"]\"DROP TABLE `Imoderni_Gallery`\"[/span][span style=\"color:#007700\"];
[/span][span style=\"color:#0000BB\"]mysql_query[/span][span style=\"color:#007700\"]([/span][span style=\"color:#0000BB\"]$sql[/span][span style=\"color:#007700\"]);
[/span][span style=\"color:#FF8000\"]//----------------------------------------------------------------------------------------------------------
// Re-Create Table
//----------------------------------------------------------------------------------------------------------
[/span][span style=\"color:#0000BB\"]$sql[/span][span style=\"color:#007700\"]=[/span][span style=\"color:#DD0000\"]\"CREATE TABLE `Imoderni_Gallery` ( `ID` INT NOT NULL AUTO_INCREMENT\"[/span][span style=\"color:#007700\"];
[/span][span style=\"color:#0000BB\"]$i [/span][span style=\"color:#007700\"]= [/span][span style=\"color:#0000BB\"]1[/span][span style=\"color:#007700\"];
[/span][span style=\"color:#0000BB\"]$o [/span][span style=\"color:#007700\"]= [/span][span style=\"color:#0000BB\"]0[/span][span style=\"color:#007700\"];
while ([/span][span style=\"color:#0000BB\"]$o [/span][span style=\"color:#007700\"]<= [/span][span style=\"color:#0000BB\"]1[/span][span style=\"color:#007700\"])
{
[/span][span style=\"color:#0000BB\"]$info [/span][span style=\"color:#007700\"]= [/span][span style=\"color:#0000BB\"]explode[/span][span style=\"color:#007700\"]([/span][span style=\"color:#DD0000\"]\',\'[/span][span style=\"color:#007700\"], [/span][span style=\"color:#0000BB\"]$csv[/span][span style=\"color:#007700\"][[/span][span style=\"color:#0000BB\"]$o[/span][span style=\"color:#007700\"]]);
while ([/span][span style=\"color:#0000BB\"]$i [/span][span style=\"color:#007700\"]<= [/span][span style=\"color:#0000BB\"]33[/span][span style=\"color:#007700\"])
{
[/span][span style=\"color:#0000BB\"]$sql [/span][span style=\"color:#007700\"]= [/span][span style=\"color:#0000BB\"]$sql[/span][span style=\"color:#007700\"].[/span][span style=\"color:#DD0000\"]\" , `\"[/span][span style=\"color:#007700\"].[/span][span style=\"color:#0000BB\"]trim[/span][span style=\"color:#007700\"]([/span][span style=\"color:#0000BB\"]$info[/span][span style=\"color:#007700\"][[/span][span style=\"color:#0000BB\"]$i[/span][span style=\"color:#007700\"]]).[/span][span style=\"color:#DD0000\"]\"` VARCHAR( 255 ) NOT NULL\"[/span][span style=\"color:#007700\"];
[/span][span style=\"color:#0000BB\"]$i[/span][span style=\"color:#007700\"]++;
}
[/span][span style=\"color:#0000BB\"]$o[/span][span style=\"color:#007700\"]++;
}
[/span][span style=\"color:#0000BB\"]$sql [/span][span style=\"color:#007700\"]= [/span][span style=\"color:#0000BB\"]$sql[/span][span style=\"color:#007700\"].[/span][span style=\"color:#DD0000\"]\" , `Image` VARCHAR ( 255 ) NOT NULL , `CatA` VARCHAR ( 255 ) NOT NULL , `CatB` VARCHAR ( 255 ) NOT NULL , PRIMARY KEY ( `ID` ));\"[/span][span style=\"color:#007700\"];
[/span][span style=\"color:#0000BB\"]mysql_query[/span][span style=\"color:#007700\"]([/span][span style=\"color:#0000BB\"]$sql[/span][span style=\"color:#007700\"]);
[/span][span style=\"color:#FF8000\"]//----------------------------------------------------------------------------------------------------------
// Insert Data into Table
//----------------------------------------------------------------------------------------------------------
[/span][span style=\"color:#0000BB\"]$i [/span][span style=\"color:#007700\"]= [/span][span style=\"color:#0000BB\"]0[/span][span style=\"color:#007700\"];
[/span][span style=\"color:#0000BB\"]$o [/span][span style=\"color:#007700\"]= [/span][span style=\"color:#0000BB\"]1[/span][span style=\"color:#007700\"];
while ([/span][span style=\"color:#0000BB\"]$o [/span][span style=\"color:#007700\"]<= [/span][span style=\"color:#0000BB\"]$count[/span][span style=\"color:#007700\"])
{
[/span][span style=\"color:#0000BB\"]$info [/span][span style=\"color:#007700\"]= [/span][span style=\"color:#0000BB\"]explode[/span][span style=\"color:#007700\"]([/span][span style=\"color:#DD0000\"]\',\'[/span][span style=\"color:#007700\"], [/span][span style=\"color:#0000BB\"]$csv[/span][span style=\"color:#007700\"][[/span][span style=\"color:#0000BB\"]$o[/span][span style=\"color:#007700\"]]);
while ([/span][span style=\"color:#0000BB\"]$i [/span][span style=\"color:#007700\"]<= [/span][span style=\"color:#0000BB\"]33[/span][span style=\"color:#007700\"])
{
[/span][span style=\"color:#0000BB\"]$sql[/span][span style=\"color:#007700\"]=[/span][span style=\"color:#DD0000\"]\"INSERT INTO `Imoderni_Gallery` (
`ID` ,
`Information_ProductCode` ,
`Information_ProductName` ,
`Manufacturer` ,
`Cat_Ref` ,
`Information_ProductDescription` ,
`Finish_Material` ,
`Information_Size` ,
`Information_Color` ,
`Information_Pattern` ,
`Information_Border` ,
`Features` ,
`Information_Wear` ,
`Note` ,
`Designer` ,
`Category` ,
`Information_SubCat1` ,
`Information_SubCat2` ,
`Information_SimilarProducts` ,
`Information_Weblinks` ,
`Information_Weblinks2` ,
`Dealer_note` ,
`MSRP_EUPrice` ,
`MSRP_DealerDiscount` ,
`MSRP_DealerPrice` ,
`MSRP_RetailMarkup` ,
`MSRP_SubTotal` ,
`MSRP_Currency` ,
`MSRP_CurrencyMultiplier` ,
`Sold_as` ,
`Number_In_Set` ,
`MSRP_SoldIndividually` ,
`MSRP_Total` ,
`MSRP_exchange` )
VALUES ( \"[/span][span style=\"color:#007700\"];
[/span][span style=\"color:#0000BB\"]$r [/span][span style=\"color:#007700\"]= [/span][span style=\"color:#0000BB\"]0[/span][span style=\"color:#007700\"];
while ([/span][span style=\"color:#0000BB\"]$r [/span][span style=\"color:#007700\"]<= [/span][span style=\"color:#0000BB\"]33[/span][span style=\"color:#007700\"])
{
if ([/span][span style=\"color:#0000BB\"]$r [/span][span style=\"color:#007700\"]== [/span][span style=\"color:#0000BB\"]0[/span][span style=\"color:#007700\"])
{
[/span][span style=\"color:#0000BB\"]$sql [/span][span style=\"color:#007700\"]= [/span][span style=\"color:#0000BB\"]$sql[/span][span style=\"color:#007700\"].[/span][span style=\"color:#DD0000\"]\"\'\"[/span][span style=\"color:#007700\"].[/span][span style=\"color:#0000BB\"]$info[/span][span style=\"color:#007700\"][[/span][span style=\"color:#0000BB\"]$r[/span][span style=\"color:#007700\"]].[/span][span style=\"color:#DD0000\"]\"\'\"[/span][span style=\"color:#007700\"];
} else {
[/span][span style=\"color:#0000BB\"]$sql [/span][span style=\"color:#007700\"]= [/span][span style=\"color:#0000BB\"]$sql[/span][span style=\"color:#007700\"].[/span][span style=\"color:#DD0000\"]\", \'\"[/span][span style=\"color:#007700\"].[/span][span style=\"color:#0000BB\"]$info[/span][span style=\"color:#007700\"][[/span][span style=\"color:#0000BB\"]$r[/span][span style=\"color:#007700\"]].[/span][span style=\"color:#DD0000\"]\"\'\"[/span][span style=\"color:#007700\"];
}
[/span][span style=\"color:#0000BB\"]$r[/span][span style=\"color:#007700\"]++;
}
[/span][span style=\"color:#0000BB\"]$i[/span][span style=\"color:#007700\"]++;
}
[/span][span style=\"color:#0000BB\"]$i [/span][span style=\"color:#007700\"]= [/span][span style=\"color:#0000BB\"]0[/span][span style=\"color:#007700\"];
[/span][span style=\"color:#0000BB\"]$sql [/span][span style=\"color:#007700\"]= [/span][span style=\"color:#0000BB\"]$sql[/span][span style=\"color:#007700\"].[/span][span style=\"color:#DD0000\"]\" );\"[/span][span style=\"color:#007700\"];
[/span][span style=\"color:#FF8000\"]// echo(\"<strong>\".$sql.\"</strong><br><br><br>\");
[/span][span style=\"color:#0000BB\"]mysql_query[/span][span style=\"color:#007700\"]([/span][span style=\"color:#0000BB\"]$sql[/span][span style=\"color:#007700\"]);
[/span][span style=\"color:#0000BB\"]$o[/span][span style=\"color:#007700\"]++;
}
[/span][span style=\"color:#0000BB\"]?>
[/span]</body>
</html>[/span][!--PHP-Foot--][/div][!--PHP-EFoot--]
Anyone able to help me out here with fixing this please?
Cheers.
[EDIT]
I was looking at the wrong code, so there was no problem...
[/EDIT]