PHP - Advice Needed

I'm having a mini application developed to create A4 PDF's using PHP

A key part of the project needs to be able to insert high quality graphics into the document that when printed out look really sharp

Some of the graphics are variable and don't always have to be printed

I just wanted to know if there was a general guide on what graphics and quality to use?

The graphics I need printed print really well when put into a Word document at 300 resolution - so I can't see why there should be any problems inserting into a PDF - these graphics are PNG ones

Unfortunately, if I insert the same PNG format into the PDF via the PHP code, the graphic turns out to be REALLY big

Just looking for advice

Thanks


OM

for those of you who don't know i am creating a piece of forum software called ASF. Ive done it by myself so far but as it grows i find it harder to write the code and keep organised. my code is a mess and things arent done the way they should be. So if anyone can give me advice or wants to help i could post some of the files for download. Even if you just want to have a look and let me know waht you think.

Thanks
Carl

http://www.thevault.cz.cc

Hi, basically i have data in my database i want to represent as cash, i currently put the dollar sign infront of each echo which is fine, but how would i go about adding , to the php code itself as you cannot do this from the sql database..

Hi all,

I am looking as a pet project to develop a review site, with the info stored in a database by id and the information grabbed bet get id and then displayed on a dynamic page, eg review.php?id=1

My question is this, if i throw keywords into the mix for each review, will search engines cache a review like this? Or would I need static pages for google etc to find the info?

Thanks

So here's my problem I'm not sure how to approach this:

I have a table with user_items which are stored together separated by commas.
Code: [Select]
13,12,11,9,27,15,16,22,21,23,24,26,29,30,31,32,33
Now, I have a script where the user is in a trade and I want to verify the item they are trying to trade, but is there an alternative other than grabbing all of that users' items and checking that one item with all of the records?

I've tried using
Code: [Select]
SELECT * FROM MYTABLE WHERE user_item_id IN(33)
As an example to see if it will pull the rows with that ID.  It didn't seem to work, am I doing it wrong? if so, forgive me. Any suggestions/help? The main problem is I don't want to have to explode that data and use a foreach to check that one item against all of that users items, as they could have well over 500.

In short i want to use the following code below, when someone selects there option and submits it, it would bring up details from the database on this user from the selected table, can you explain what it would be called doing this so i can look it up, Sorry to be a pain, Cheers.

Code: [Select]
<select name="target2" id="target2">

    <option value=""></option>

  <?php

  $sql = "SELECT player_id, friend_id, name, is_active FROM contacts as c JOIN players as p ON c.friend_id = p.id WHERE c.player_id = $playerID AND is_active = 1 ORDER BY name ASC";

  $que = mysql_query($sql) or die(mysql_error());

  while($list = mysql_fetch_array($que)) {

  ?>

  <option value="<?php echo $list['friend_id'] ?>"><?php echo $list['name'] ?></option>

  <?php } ?>

  </select>

Hello, can someone please advice me on what scripts I will need to accomplish the following.

I want users to be able to login to their personal page, on there will be items such as pdf files, jpeg files etc, that they will be able to download.

Are there any free scripts out there that can do this, that anyone knows of? I don't mind paying if its a cheapish script for one of you to make for me, but money is a bit tight at the moment so a free script would be my 1st choice...

Thanks for all your help

Right now I have a SESSION so when users flip though pages they carry their info with them, what I'm trying to do now is that userhome.php can't be accesses unless the user just was succesful in cracking there system.. game I'm creating for those of you helping and following me while I do this! it's a virutal hacking simulation and where I'm now is that the user's passwordcracker was compared to the target systems 'systemkey' and either granted him access or didn't, if it did it displayed a progress bar then fowarded to userhome.php where the target users info will lay, right now though if I just type in userhome.php i get there without haveing the crack it.... any ideas?

Was wondering if anyone had any thoughts on how im running settings on my text base game.

I currently have like 60 settings stored in the data base. These are only admin control settings. They set what things cost in the game and such.

I was thinking today that would it be better instead of running a query on every page to grab the settings that page uses. I just simply  do one huge select ALL query for the settings when a user logs in and turn all the setting into super global $_SESSION.

Also this way any function i made i can simply use the SESSION instead of grabing settings out side the function or creating a query for it with in the function.

So i was thinking doing this would extremly speed up my game wouldnt it?
wondering if anyone has any thoughts on this

Hi All,

I currently have a ticketqueue that show's all tickets assigned to a group of people, but split into personal queues, but the way that I wrote it, means that it needs manually updating if a specific person leaves/joins the department. For example, to get the queue details, I use the following query:

Code: [Select]
$username1 = mssql_query("select id,subject,body,priority from queue where assignedto = username1";)
$username2 = mssql_query("select id,subject,body,priority from queue where assignedto = username2";)

I have repeated this code for all of the users in our team. Which seams a waste, as I have all the information on our team stored in a DB called "sysadminusers". Is there an array I could use that would look at all the usernames in the table, and then repeat the query for me?

I would also need this array to display the results on the page, currently I use the following:

Code: [Select]
while($username1_tickets = mssql_fetch_assoc($username1)){
echo $username1_tickets['id'],$username1_tickets['subject']$username1_tickets['body'],$username1_tickets['priority'];}
while($username2_tickets = mssql_fetch_assoc($username2)){
echo $username2_tickets['id'],$username2_tickets['subject']$username2_tickets['body'],$username2_tickets['priority'];}

I am just looking for some design advice and code examples that would help me tidy up my code for this page, it seams a lot of code for quite a simple page.

Thanks
Matt

I have a restricted page for members of a website. This restricted area is within a directory called 'download.'

There is a login form on two pages (home and support pages, found in the main menu). These pages are on the site root directory. When the user successfully logs in they are taken inside the download directory to index.php.

This index.php has a different look to the site root design. I have since redesigned this page to have the same structure as the site root pages.

I would love for the user to able to navigate around the main site if they wanted, and when they clicked support in the menu they would have all the download files there on the page, instead of a login form.

My question is how would I implement this login so that when the user logs in the support page changes from the login page to the page with the files.

I don't want to to duplicate the site within the download directory, I was hoping for an efficient method, but I am unsure how to go about it. 

I've been trying to find a good, up-to-date source on how to secure the authentication credentials for my db connection. I've done some PHP coding and would like to learn more. There's plenty information available, but I often find books inevitably have typos in the code. Also most of the online tutorials are either at least several years old or deal more with user login security.

User authentication is one thing, but what are the best ways to secure the connection to the database itself? Obviously your basic newbie method of unencrypted host, username, password, and database stored in a connectvar file is just open invitation--or maybe not since it doesn't present a challenge to a hacker. Some say to encrypt the credentials with something like MD5 and store them in .htaccess. Other sources say not to use MD5. Any advice on where to find some good resources on this?

Cheers!

I have made a small class to learn how to do them. This basically adds the new user to the database upon registration. I would like to know if i am doing things right or if there is a better way. Also can anyone tell me why i would use this class? Previously I just included the insert query and if statements in my main register.php page and everything worked fine. what are the advantages to using it in a class?

Here is the class:

<?php

define ("NO_USERNAME", "Please Enter A Username");
define ("NO_PASSWORD", "Please Enter A Password");
define ("NO_EMAIL", "Please Enter An Email Address");
define ("SUCCESFULL_REGISTRATION", "Done");
define ("NO_MATCH", "Your Passwords Did Not Match");
define ("UNKNOWN_ERROR", "An Unknown Error Occured");

class User
{
public $user_name;
public $password;
public $email_address;
public $password_confirm;
public $processed;
public $error;

function user_create($user_name, $password, $email_address, $password_confirm)
{
if (empty($user_name))
{
$this->error = NO_USERNAME;
}
elseif (empty($password))
{
$this->error = NO_PASSWORD;
}
elseif (empty($email_address))
{
$this->error = NO_EMAIL;
}
elseif ($password != $password_confirm)
{
$this->error = NO_MATCH;
}
else
{
$this->error = NULL;
}

if ($this->error == NULL)
{
echo "Username: " . $user_name . "<br />";
mysql_query("INSERT INTO test_members
(user_name,
password,
email_address)
VALUES
('$user_name',
'".md5($password)."',
'$email_address')")
or trigger_error("SQL", E_USER_ERROR);

$this->processed = TRUE;

}

}

public function encryptPassword($password)
{
$password = sha1(md5(md5(sha1(sha1($this->password)))));
}

}

?>

hello 


i need someone to take a look on this , General comments on the code process and how should i continue !!!



[attachment deleted by admin]

Hi,

Is anyone here familiar with the Facebook API?

My boss wants people to be able to share their store with their friends on Facebook from within the stores admin panel. He wants the following.

1) Display all friends with a checkbox next to each name.
2) Check the friends you want to inform about your store.
3) Post a message on checked friends wall.

It sounds simple.

The problem is the friends selection screen. Some of my friends on Facebook have 1000 friends. Obviously listing all of them is inpractical. Ideally I need a search box to limit the friends that display and make it easy to find who you are looking for. Does something like this already exist? Does it have a name?