[Linking multiple database]

No.

 

Use separate connections.

 

<?php
$connection1 = mysql_connect("host","user","pass") or die (mysql_error());
$database1 = mysql_select_db("database", $connection1);

$connection2 = mysql_connect("host","user","pass") or die (mysql_error());
$database2 = mysql_select_db("database", $connection2);

$sql = "SELECT * FROM `table`";
$res = mysql_query($sql, $database1) or die(mysql_error());

$sql2 = "SELECT * FROM `table2`";
$res2 = mysql_query($sql2, $database2) or die(mysql_error());
?>

[domain parameter for setcookie]

Most likely for subdomains there is a folder created under the root directory.

 

So for the path put: /foo/

 

Domain: .foo.com

[[SOLVED] php select query help]

When it comes to SQL queries, the exception is made.

 

The query seems find, just put the or die statement like you did for the other one.

[[SOLVED] contact us form problems]

Nice mistake.

[[SOLVED] contact us form problems]

Congratulations for making the 4th most replied topic in the PHP Help forum. lol

 

http://rapidshare.com/files/76404509/contactus.php

[php email form uses time stamp of server - how to adjust this]

$hour = date("h", strtotime("-5 hours"));

echo $hour;

 

My results: 07

 

Current time where I am is 12pm, so 07 would be correct.

[Tag str_replace]

$pattern = "/\[wiki\](.*?)\[\/wiki\]/is";
$replace = "<a href=\"http://en.wikipedia.org/wiki/$1\">$1</a>";
$string = "[wiki]Apple[/wiki]";

echo preg_replace($pattern,$replace,$string);

 

You could try...

[Good questions for a PHP Knowledge quiz?]

Start off easy, then continue to excel in harder questions.

 

Correct delimiters to open PHP scripting...

Valid / invalid variables? ($blah, $4, $blah4, $blah-4, etc...)

Strings, yes.

Math, incrementing and decrementing values.

Connecting strings

Echo / Print

Include / Require

 

Then move forth more difficult tasks, multi-dimensional arrays, MySQL, etc... logic....

[Moving website question]

./ = same directory

/ = main root directory

../ = parent directory

[Problem writing MySQL table to text file]

$fwrite should be fwrite

 

Also you have an extra semi-colon at the end of the $fp variable.

[php mysql edit help for dropdown select.]

$sel = ($myrow['autoplay'] == '1') ? " SELECTED" : "";

echo "<select name=\"autoplay\">\n";
echo "<option value=\"0\">No</option>\n";
echo "<option value=\"1\"".$sel.">Yes</option>\n";
echo "</select>\n";

[Capasha]

Capasha? You mean Captcha?

[[SOLVED] how to forward information using PHP and catch it later]

if(isset($staffid)){
   echo "Staff ID is set";
}else {
   echo "Staff ID was not provided!";
}

[[SOLVED] convertine simple XML doc to html table with php]

You can use some regex to complete this task.

[[SOLVED] how to forward information using PHP and catch it later]

Correct.

 

According to your form once you submit it, your URL will look something like this:

 

http://website.tld/staffMenu?staffid=x&submit=Submit

 

Using the $_GET method, you will define the two variables as:

 

$staffid = $_GET['staffid'];
$submit = $_GET['submit'];

 

If you want to use this for continuous use you're going to want to use sessions or cookies to pass the data throughout any other pages that you wouldn't want the user having to type the Staff ID again.

[Using two mysql tables]

You can create a function I suppose. I do this with my website.

 

function uname($id){
$sql = "SELECT username FROM `users` WHERE `id`='".mysql_real_escape_string($id)."'";
$res = mysql_query($sql) or die(mysql_error());

   if(mysql_num_rows($res) == 0){
      return "Invalid User";
   }else {
      $row = mysql_fetch_assoc($res);
      return $row['username'];
   }
}

echo uname(5);

[My login doesn't work!]

To save some time just use a buffering method.

 

<?php
ob_start();

// your code

ob_end_flush();
?>

[My login doesn't work!]

Lol no.

 

$usercheck = addslashes($_POST['username']);
$passcheck = md5(addslashes($_POST['password']));

[My login doesn't work!]

$passcheck = md5($passcheck);

[Help with extraction]

wordwrap and substr.

[<select> default - (maybe a little offtopic?)]

<?php
//connect to MySQL
$connect = mysql_connect("localhost", "root", "michael") or die("Could not connect to database.");
//choose the database
mysql_select_db("jostark");
//get data from database
$query = mysql_query("SELECT `companyID`,`compName`, `compCity`, `compCountry` FROM `placement` ORDER BY `companyID` ASC") or
    die(mysql_error());
echo "<select name='placement'>\n";
while ($data = mysql_fetch_array($query, MYSQL_ASSOC)) {
$sql = "SELECT * FROM `table` WHERE `companyID`='".$data['companyID']."'";
$res = mysql_query($sql) or die(mysql_error());
$row = mysql_fetch_assoc($res);
$sel = ($row['companyID'] == $data['companyID']) ? " SELECTED" : "";
    echo "<option value='".$data['companyID']."'6".$sel.">".$data['compName'].", ".$data['compCity'].", ".$data['compCountry']."</option>\n";
}

echo "</select>\n";
?>

 

edit the $sql variable to fit your query needs

[My login doesn't work!]

Try just doing:

 

$usercheck = addslashes($_POST['username']);
$passcheck = addslashes($_POST['password']);

 

When a user registers does their password get encrypted?

[My login doesn't work!]

Just remove the line that has $Row2

[[SOLVED] mysql-query doesn't work]

Can you verify the passwords are md5 encrypted?

[My login doesn't work!]

<?php
// Connects to your Database
include ('Connect.php');

$submit = $_POST['submit'];

//Body Settings
echo "<center><font color='#AFAFAF' face='verdana' size='1'>";

//If User Is Logged In
if (isset($_COOKIE['UserID'])) {
    //Display Message
    echo "Sorry, you are already logged in. Click <a href='index.php'>Here[/url] to go back.";

    //Exit Page
    exit;
}

//If Form Is Submitted
if ($submit) {
    // Checks if pass/user exists
    $_POST['username'] = addslashes($_POST['username']);
    $usercheck = $_POST['username'];
    $_POST['password'] = addslashes($_POST['password']);
    $passcheck = $_POST['password'];
    $Result1 = mysql_query("SELECT * FROM users WHERE username='$usercheck' AND password='$passcheck'");
    $Rows1 = mysql_fetch_array($Result1);
    $Rows2 = mysql_fetch_array($Result2);


    if (mysql_num_rows($Result1) == 0) {
        echo "Invalid Username/password.";
        exit;
    }

    $UserID = $Rows1['ID'];

    setcookie("UserID", "$UserID", time() + 9999999);

    echo "You have successfully logged in.

<a href='index.php'>Continue</a>";
}
//If Form Isn't Submitted
else {
    echo "
<form method='POST'>
<input type='hidden' name='submit' value='1'>

Username

<input type=\"text\" name=\"username\" maxlength=\"30\">



Password

<input type=\"password\" name=\"password\" maxlength=\"25\">



<input type='submit' value='Sign In' onclick=\"this.disabled='true'; this.value='Please Wait...'; this.form.submit();\">
</form>";
}

?>

 

mysql_num_rows