PHP - Linking Problem

I have been trying to figure out how this is done?  One php file and all that changes is the name of the brand and the logo.  This has to be clickable from a menu and also if a user changes the brand name it changes to the appropriate name and logo.  Any ideas as to how this is done?  If you can guide me in the right direction or give me an example of how this is done would be greatly appreciated.  Thanks.


http://www.drivermanager.com/en/download-confirmation.php?brand=compaq&logo=

Hi I got three tables (employers , company ,  and  Jobs) Employer table holds info about employer. Company hold info about the company and jobs table holds info about jobs. I was just wandering what would be a good way to link these tables in the database ?  Here is the coding for each table.


Employer Table

Code: [Select]


CREATE TABLE IF NOT EXISTS `employers` (
  `id` int(11) NOT NULL,
  `username` varchar(50) NOT NULL,
  `password` varchar(50) NOT NULL,
  `email` varchar(50) NOT NULL,
  PRIMARY KEY  (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;



Jobs Table

Code: [Select]

CREATE TABLE IF NOT EXISTS `Jobs` (
  `id` int(11) NOT NULL,
  `JobTitle` varchar(200) default NULL,
  `Company` varchar(200) default NULL,
  `Salary` varchar(30) default NULL,
  `Description` varchar(2000) default NULL,
  `CompanyURL` varchar(200) default NULL,
  `PhoneNumber` varchar(30) default NULL,
  `Requirements` varchar(2000) default NULL,
  `JobCategory` varchar(100) default NULL,
  `JobType` varchar(100) default NULL,
  `Apply_To` varchar(1000) NOT NULL,
  `Email` varchar(200) NOT NULL,
  `modified_at` datetime NOT NULL,
  `PostedOnDate` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,
  `Address` varchar(250) NOT NULL,
  `State` varchar(200) NOT NULL,
  `City` varchar(200) NOT NULL,
  `Country` varchar(100) NOT NULL,
  `Zipcode` varchar(100) NOT NULL,
  `JobID` varchar(100) NOT NULL,
  `WorkExperience` varchar(2000) NOT NULL,
  `EducationRequirement` varchar(2000) NOT NULL,
  `WebsitePostedFrom` varchar(200) NOT NULL,
  PRIMARY KEY  (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;



Company Table

Code: [Select]


CREATE TABLE IF NOT EXISTS `Company` (
  `id` int(11) unsigned NOT NULL auto_increment,
  `CompanyName` varchar(100) NOT NULL,
  `Address` varchar(100) NOT NULL,
  `Logo` varchar(100) NOT NULL,
  `PhoneNumber` varchar(25) NOT NULL,
  `ContactPerson` varchar(25) NOT NULL,
  PRIMARY KEY  (`id`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=2 ;

Hi All,

I googled this and there is endless results.  I went through a lot of them but couldn't get this working properly.

How do I link from within my web site root to files outside the root?  It works for me using relative links  i.e.  ../../phpfiles/includes but that is going to get messy and I can't get a way of doing absolute links to work.  If someone could lay that out so a newbie can get it clearly I would really appreciate it!


Also - I understand why I should put all of my php files outside the web root but is this a guaranteed way to secure these files other than someone hacking my ftp access?


I've looked at a few site hierarchy examples - Am I right that the only pages within the web site root should be template pages with calls to required files (outside the root), session checks, and content includes and all other includes that have php executable code should be outside the root?

I really appreciate the advice and insight.  Thank you!

<?php 

$con = database_connect();
$sql = "SELECT *
FROM anime1, episode1
WHERE animeid='$animeid'";
$result = mysql_query($sql);
while ($row = mysql_fetch_assoc($result)) {
$title = $row['title'];
$ep = $row['ep'];
}


 ?>

keep giving me back error

Warning: mysql_fetch_assoc() expects parameter 1 to be resource, boolean given in C:\wamp\www\studying\take 2\addin12.php on line 45

This topic has been moved to MySQL Help.

http://www.phpfreaks.com/forums/index.php?topic=321572.0

In a relational database, you "link" tables together.  For example, Customer (parent) ---> Product (child)

How do you do that with Objects?

I have a "User" class and an "AddressBook" class.  A User can have zero or more Addresses (in their AddressBook).

If I create a User object and an AddressBook object, I need a way to link them up similar to how they are linked up in the database.

Make sense?!


TomTees

I have this code :
<img class= "image_frame1" src="images/groupproductimages/<?php echo $offer['cimage'];?>"  />
It pulls pics
I need the pics to link to urls
using this code
<a href="index.php?option=com_grouppurchase&view=todaysdeal&id=<?php echo $offer['cid'];?>">
I know I am missing something stupid

So I have 3 tables: student, course_student and course. The student table is a student's registration info and course is the different courses the student can register for. The course_student table should contain the id fields of the other 2 which I should then use to link the tables and for example display all student's registered for current courses.  Student table has an id field: sno and course table has : cid. Course_student contains both. How do I go about linking the tables so the sno id field of the student table and the cid from course updates with those in the course_table?

Hi:

I have a login file where a user goes to a db based on the dbtype selected.
Now
$dbtype1 links to a db on Server 1 ( that is the server on which this script is running and
$dbtype2 links to a db on Server 2

I created a connection-link file connectlink.php as under but  while $dbtype1 works without a problem  , $dbtype2 gives me an error 'no access to db' and user dbun1@localhost not found on db1.db .

What am I missing in the connectlink.php file please ? Thanks

login.php
===========

<?
......
if($_POST['submit']){
$dbtype = $_POST['dbtype'];

if ($dbtype == 'type1') 
   { $section = 'type1';    
     require("../x/type1/type1.php");
     } 

if ($dbtype == 'type2') 
   { $section = 'type2';    
     require("../x/type2/connectlink.php"); //the dir 'x' is a common name on both the servers''
     } 
    
//then it processes $userfile and give this 


Click <a href="'.$section.'/'.$userFile.'?Userid='.$userid.'"> here 

?>

connectlink.php
==============

<?
//this file contains db info, log and checks if user is authorised to access the db - ist check.

error_reporting(E_ERROR | E_PARSE | E_CORE_ERROR);

 $dbusername2='a';
 $dbpassword2='b';
 $dbname2='c';
 $servername = 'ip address of server or localhost ?';
 $link2=mysql_connect ("$servername","$dbusername2","$dbpassword2", true);
 if(!$link2){  die("Could not connect to MySQL");}
 mysql_select_db("$dbname2",$link2) or die ("could not open db".mysql_error());
 

 $dbusername1='d';
 $dbpassword1='e';
 $dbname1='f';
 $servername = 'localhost';
 $link1=mysql_connect ("$servername","$dbusername1","$dbpassword1", true);
 if(!$link1){  die("Could not connect to MySQL");}
 mysql_select_db("$dbname1",$link1) or die ("could not open db".mysql_error());

 
$sql = "SELECT * FROM Users WHERE Userid='$userid'",$link2;

$result = mysql_query($sql);
if  ($myrow = mysql_fetch_array($result)){
$login_success = 'Yes'; 
$status = "On";
....
        
               $sql2= "insert into Log (....) values(.....)",$link2;;
$result2 = mysql_query($sql2) or die  ('no access to database: ' . mysql_error());
//        echo mysql_error();      }
}

else 
{
  $failureMessage = '<p class="data"><center><font face="Verdana" size="2" color="red">Login Failure.  You are not authorised to access this database .<br /></font></center></p>';
    print $failureMessage;
$logoutMessage = 'Click <a href="../NEWDBS/mainlogout.php"> here </a>to logout </p>';

print $logoutMessage;


     exit;
  
}


?>

This topic has been moved to Miscellaneous.

http://www.phpfreaks.com/forums/index.php?topic=326928.0

This topic has been moved to HTML Help.

http://www.phpfreaks.com/forums/index.php?topic=351259.0

This topic has been moved to MySQL Help.

http://www.phpfreaks.com/forums/index.php?topic=330834.0

I have a table that holds a set of matches in a football (soccer) league. On a teams individual page I want to show just their matches and am very close to getting it right but just cannot get there!

I am using 2 tables for this....
teams
team_id team_name 1 TEAM1 2 TEAM2 3 TEAM3 4 TEAM4
and

all_games game_id home_team home_score away_team away_score 1 1 2 2 0 2 3 0 4 1 3 4 2 1 1 4 2 0 3 0 Both 'home_team' and 'away_team' are foreign keys to teams.team_id.

The query that I have used to almost get it working is
SELECT * FROM  all_games, teams WHERE '%s' IN (home_team, away_team )  AND all_games.home_team=teams.team_id

And the html is
        Code: [Select]
   
<tr>
        <td>all_games_id</td>
        <td>home_team</td>
        <td>home_goals</td>
        <td>away_team</td>
        <td>away_goals</td>
</tr>
<tr>
        <td><?php echo $row_all_games['all_games_id']; ?></td>
        <td><?php echo $row_all_games['team_name']; ?></td>
        <td><?php echo $row_all_games['home_goals']; ?></td>
        <td><?php echo $row_all_games['team_name']; ?></td>
        <td><?php echo $row_all_games['away_goals']; ?></td>
        </tr>     
     
This pulls the correct games into the page but will show the 'home_team.team_name' as both 'home_team' and 'away_team'. For example the page for TEAM1 shows up as
match_id home_team home_score away_team away_score 1 TEAM1 2 TEAM1 0 3 TEAM4 2 TEAM4 1
What it should show is
match_id home_team home_score away_team away_score 1 TEAM1 2 TEAM2 0 3 TEAM4 2 TEAM1 1
Obviously in the current query there is nothing to show that the 'away_team' is also equal to 'teams.team_id'. I have tried this query
SELECT * FROM  all_games, teams WHERE '%s' IN (home_team, away_team )  AND (all_games.home_team=teams.team_id OR all_games.away_team=teams.team_id)
But this gives the exact opposite result with just the 'away_team.team_name' showing up as 'home_team' and 'away_team'
match_id home_team home_score away_team away_score 1 TEAM2 2 TEAM2 0 3 TEAM1 2 TEAM1 1
while

SELECT * FROM  all_games, teams WHERE '%s' IN (home_team, away_team )  AND (all_games.home_team=teams.team_id AND all_games.away_team=teams.team_id)
throws up an empty query.

Does anyone have any suggestions on how this can be done? I have exhausted my patience with Google simply as I do not know what the correct search term is.


As an aside, when I do get it working, I want the format on the page to be slightly different in that instead of showing both home_team and away_team names I would want it to show "H" if the team in question is the 'home_team' and "A" if it is the 'away_ team' plus the name of the team that they played and whether the 'home_score' or 'away_score' belonged to them, as well as whether they won, drew or lost the game. So, staying with the page for TEAM1 it would show as
MATCH ID HOME or AWAY OPPONENT W/D/L SCORE FOR SCORE AGAINST 1 H TEAM2 Won 2 0 3 A TEAM4 Lost 1 2
I am currently planning on doing this with IF statements in the html, something along these lines if home_team = %s echo "Home" else echo "Away"
and
if home_team = %s AND home_score>away_score echo "Won"
else if away_team = %s and away_score>home_score echo "Won"
else if home_score= away_score echo "Drew"
else echo "Lost

If anyone can think of a better way to do this ( I am naturally assuming that it would not work in the way I intend!)I would be extremely greatful too!

Thanks in advance for any advice, pointers or offers to write the whole code!!!
Steve

im trying to link a profile if it is prefixed with an @ symbol. I have tried this but it doesnt work as i thought it wouldnt.

Code: [Select]
$content = preg_replace('|@(.*?)|', profile_link('$1'), $content);

Hi guys,

I need your help with my php script. On my script, I'm currently working with image where I can hot-link them from another website while it is on protected. when you click right-mouse button on firefox, you could see something like "view page source" which is disabled. when you click on "save page as", you can save the image as "image.php". when you open them, you would not be able to read due to the image but you can find the real image link in image.php where i want to protect them.

here's the currently code:

Code: [Select]
<?php
session_start();
    define('DB_HOST', 'localhost');
    define('DB_USER', 'myusername');
    define('DB_PASSWORD', 'mypassword');
    define('DB_DATABASE', 'mydbname');

$id = (int)$_GET['id'];

$errmsg_arr = array();
$errflag = false;

$link = mysql_connect(DB_HOST, DB_USER, DB_PASSWORD);
if(!$link) {
    die('Failed to connect to server: ' . mysql_error());
}

$db = mysql_select_db(DB_DATABASE);
if(!$db) {
    die("Unable to select database");
}   

function clean($var)
{
    return mysql_real_escape_string(strip_tags($var));
}
  $qrytable1="SELECT images FROM image_list WHERE id=$id";
  $result1=mysql_query($qrytable1) or die('Error:<br />' . $qry . '<br />' . mysql_error());

while ($row = mysql_fetch_array($result1)) {
   $image = $row['images'];
   $details = getimagesize($image); 
   header ('Content-Type: ' . image_type_to_mime_type($details[2]));
   echo readfile($image), "<p id='images'>",  $row['images'] . "</p>";
 } 
?>

I guess that there must be a way to protected the url in the php script where i can hide them. It should be easy to modify but I am not sure what line I need to adjust to make it protected.

Can you please help me in what line I need to modify in order to protected the hot-linking in my php?