Learn VBA & Macros in 1 Week!

PHP - 'from' Header Not Displaying Properly

Full Excel VBA Course - Beginner to Expert

'from' Header Not Displaying Properly	View Content

- key (Int, Not Null, Primary Key, Auto Increment)
- type (Enum('USER', 'GROUP'), Not Null)
- id (Int, Not Null)
- permission (Varchar(255), Not Null)
- description (Text)

Now here is how it works,
a record is inserted into the uniperms_nodes table containing the necessary information. Here is an example:

INSERT INTO `uniperms_nodes` (`type`, `id`, `permission`, `description`) 
VALUES ('GROUP', '1', 'my.test.node', 'A simple permission');

With this information inserted, I can simply use the following query in order to get all of the permissions related to the GROUP with the ID of 1.

SELECT `permission` FROM `uniperms_nodes`
WHERE type='GROUP' AND id=1;

With this array of permission nodes I can simply just check if the array has 'my.test.node', if the array contains 'my.test.node' then that means that the group I queried has access to that permission. Now the reason I have the types USER and GROUP is because maybe you would like to give permissions to individual users, but maybe you wouldn't necessarily want to create a new group. I'm currently looking for someone to help me create a lovely interface for this system, so that it's easier for the user to modify a group/user's permissions. If you're interested feel free to message me here on the forums or via email. kieron.wiltshire@outlook.com
Edited by KieronWiltshire, 19 November 2014 - 11:15 AM.

.php?id=1,2,3 Not Working Properly

Similar Tutorials

View Content

Okay, so I am trying to make a play.php file connected to my database, this database got a table named "webclientcreate".

When I go to play.php?id=1, it is showing the proper one (the 1st row wich got id 1 in it), however if I after that go to something random like play.php?fsfasd the ID 1s page still pops up..
I can also go to play.php?id=2 and still get the id 1's data.

I want to make it that every row got its own information (well it does, but the php file doesnt seem to recieve it correctly).

PHP version: 5.2.17
MySQL version: 5.1

Heres a picture of my table rows:

I've censored the MySQL connection information, I know it is working properly.

Code: [Select]
<?php

$connect = mysql_connect("mysql12.000webhost.com","****","******") or die(mysql_error());
mysql_select_db("***") or die(mysql_error());

$extract = mysql_query("SELECT * FROM webclientcreate");
$numrows = mysql_num_rows($extract);

while ($row = mysql_fetch_assoc($extract))
{
$id = $row['id'];
$server = $row['name'];
$ip = $row['ip'];
$port = $row['port'];
$background = $row['background'];
}
if (isset($ip)&&isset($port)&&!empty($ip)&&!empty($port)) {

if (! $sock = @fsockopen($ip, $port, $num, $error, 1))
echo "";
else{
echo "<img src='fs/newyear/online.png'/>$ip on port $port is currently<B><FONT COLOR=lime> Online</b></FONT>";
fclose($sock);
}

}

?>
<title>Playing <?php echo $server; ?> - ID <?php echo $id; ?> </title>

<center>
<body bgcolor="#000000">

<applet name=client width=765 height=503 archive='<?php echo $jars; ?>' code='client.class'>

<PARAM name='java_arguments' value='-Xmx700m'>

<PARAM name='server_name' value='<?php echo $server; ?>'>

<PARAM name='detail' value='low'>

<PARAM name='ip' value='<?php echo $ip; ?>'>

<PARAM name='port' value='<?php echo $port; ?>'>

<PARAM name='background_image' value='<?php echo $background; ?>'>

<PARAM name='headicons' value=''>

</applet>
</center>

Cant Get This Cookie To Work Properly

Similar Tutorials

View Content

why aint this working??

Code: [Select]
<?php
                                if ($_COOKIE['watch_id']){
                                    $cookie = $_COOKIE['watch_id'];
                                    $cookie_query = mysql_query("SELECT * FROM user WHERE cookie='$cookie'");
                                    if (mysql_num_rows($cookie_query) >= 1){
                                    ?>
<li><a href="/index.php">Home</a></li>
<li><a href="/cpanel.php">C-Panel</a></li>
<li><a href="/logout.php">Logout</a></li>
pass
<?php
                                    }
                                    if (mysql_num_rows($cookie_query) <= 1){
                                    ?>
<li><a href="register.php">Register</a></li>
<li><a href="#" onclick="OPEN_login();">Login</a></li>
<li><a href="index.php">Home</a></li>
fail1
<?php
                                    }
                                }

                                if(!$_COOKIE['watch_id']){
                                ?>
<li><a href="register.php">Register</a></li>
<li><a href="#" onclick="OPEN_login();">Login</a></li>
<li><a href="/index.php">Home</a></li>
fail2
<?php
                                }
                                ?>

i have checked in the browser and the cookies match but it always echos fail2 which means that this line is returning false:

Code: [Select]
if ($_COOKIE['watch_id']){

i have tried using isset but that didnt help either!

any help?

Strip_tags Not Working Properly

Similar Tutorials

View Content

Hi, I'm having problems with a PHP mail handler and everything seems to be working fine except I get slashes in the message body from the form. If my input is "Please don't delete this" I get "Please don/'t delete this" in the message body, however it is striping the other tags. I'm not sure what is wrong and was hoping for a bit of help to figure this out.

Here is the code:
Code: [Select]
<?php
$owner_email = $_POST["owner_email"];
$headers = 'From:' . $_POST["email"];
$subject = 'Website contact inquiry from ' . $_POST["name"];
$messageBody = "";

$messageBody .= '<p>------------------ Contact Details ------------------' . '</p>' . "\n";
$messageBody .= '<p>Name: ' . $_POST["name"] . '</p>' . "\n";
$messageBody .= '<p>Email Address: ' . $_POST['email'] . '</p>' . "\n";
$messageBody .= '<p>Phone Number: ' . $_POST['phone'] . '</p>' . "\n";
$messageBody .= '<p>----------------------------------------------------------' . '</p>' . "\n";
$messageBody .= '<br>' . "\n";
$messageBody .= '<p>' . $_POST['message'] . '</p>' . "\n";

if($_POST["stripHTML"] == 'true'){
$messageBody = strip_tags($messageBody);
}

try{
if(!mail($owner_email, $subject, $messageBody, $headers)){
throw new Exception('mail failed');
}else{
echo 'mail sent';
}
}catch(Exception $e){
echo $e->getMessage() ."\n";
}
?>

This Page Isn't Redirecting Properly

Similar Tutorials

View Content

I am trying to integrate facebook login into my application. If the user isn't logged in, I want to make sure that they get sent to the index page, but this doesn't work.

Code: [Select]
<?php

if ($user) {
  try {
    // Proceed knowing you have a logged in user who's authenticated.
    $user_profile = $facebook->api('/me');
  } catch (FacebookApiException $e) {
$user = null;
    //echo '<pre>'.htmlspecialchars(print_r($e, true)).'</pre>';
  }
} else {
header('Location: /');
}

?>

Any thoughts on how to fix?

Update.php Not Functioning Properly

Similar Tutorials

View Content

Similar Tutorials

View Content

I have an ongoing mission to tighten up my code for a directory listing for a non-profit organization. Brief background is - there are multiple "company" members in each County, and usually multiple "contact people" at each company. Also, some companies have "branch" offices, but not all, and most of the branches also have "contact people." I have successfully segregated my code, so that the "listing" work is handled by separate functions. I am trying to work with JOIN queries, and in my first step I am treating the "company" and "branch" listings with separate test code for now, and the branch output is missing the first row of the array that I am creating. To demonstrate what is happening, I am going to attache a screen shot of the correct results from my query, which starts with a branch called "Louisiana Branch". To see the results of my code, click on this link: http://www.nmlta.org...ew_br_test2.php And finally, I am including the working portions of my code below... leaving out the connection details, which are not an issue. Just to be clear, I have the exact code structure for a query of the company table, with a similar JOIN, and the listing results of my code do not skip the first row of that array. I must be missing something that should be obvious, but I can't see the problem. I would appreciate any and all help... thanks - Rob My Code:

<?php

function listCompany($row) {
    echo $row['comp_name'],"<br />";
	if (!empty($row['comp_uw'])) {
	echo $row['comp_uw'],"<br />";}
	echo "</b>",$row['comp_street'],"<br />";
	if (!empty($row['comp_pobox'])) {
	echo $row['comp_pobox'],"<br />";}
	echo $row['comp_csz'],"<br />";
	echo $row['comp_ph'],"&nbsp&nbsp&nbsp;Fax: ",$row['comp_fx'],"<br />";
	if (!empty($row['comp_tfree'])) {
	echo "Toll Free: ",$row['comp_tfree'],"<br />";}
	if (!empty($row['comp_email'])) {
	echo "Email: <a href='mailto:",$row['comp_email'],"'>",$row['comp_email'],"</a><br />";}
	if (!empty($row['comp_web'])) {
	echo "<a href='http://",$row['comp_web'],"' target='_blank'>",$row['comp_web'],"</a><br />";}
	echo "</p>";
}

function listBranch($row2) {
	if (!empty($row2['br_name'])) {
	echo "<p>&nbsp&nbsp&nbsp&nbsp&nbsp;<b>",$row2['branch_name'],"</b><br />";}
	echo "&nbsp&nbsp&nbsp&nbsp&nbsp;",$row2['br_street'],"<br />";
	echo "&nbsp&nbsp&nbsp&nbsp&nbsp;",$row2['br_csz'],"<br />";
	echo "&nbsp&nbsp&nbsp&nbsp&nbsp;",$row2['br_ph'],"&nbsp&nbsp&nbsp;",$row2['br_fx'],"<br /></p>";
}

function listContact($row) {
    if (!empty($row['cont_name'])) {
	echo "<p>&nbsp&nbsp&nbsp&nbsp&nbsp;<b>",$row['cont_name'],"</b>, ",$row['cont_title'],"<br />";}
	if (!empty($row['cont_email'])) {
	echo "&nbsp&nbsp&nbsp&nbsp&nbsp;Email: <a href='mailto:",$row['cont_email'],"'>",$row['cont_email'],"</a><br />";}
	echo "</p>";
}

function listBranchContact($row2) {
    if (!empty($row2['cont_name'])) {
	echo "<p>&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp;<b>",$row2['cont_name'],"</b>, ",$row2['cont_title'],"<br />";}
	if (!empty($row2['cont_email'])) {
	echo "&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp;Email: <a href='mailto:",$row2['cont_email'],"'>",$row2['cont_email'],"</a><br />";}
	echo "</p>";
}
// Connection to DB


// Retrieve all the data from the "company" table
$query2 = "SELECT * FROM branch LEFT JOIN br_contact ON branch.branch_id = br_contact.branch_id WHERE br_county = 'BERNALILLO' ORDER BY branch.comp_name, branch.br_street, br_contact.cont_rank"; 

$result2 = $mysqli->query($query2) or die($mysqli->error.__LINE__);
// Build the $company_array
$branch_array = array();
while($row2 = $result2->fetch_assoc()) {
    $branch_array[] = $row2;
}

$lastBranch = ''; //Initialize $lastBranch variable 

// Start building the table to show results
echo "<table border='1' cellpadding='10' cellspacing='0' bgcolor='#f0f0f0' style='margin-left:100px; margin-bottom:20px'>";
 
// Begin the "foreach" loop for rows in the $branch_array
foreach($branch_array as $row2) { // Branch Loop
   // Check if this is a different branch than the last one
    if ($lastBranch != $row2['branch_id']) { // Loop to check if New Branch
    // If this is a different branch - change the $lastBranch variable   
    $lastBranch = $row2['branch_id'];
    
    echo "<tr><td>";
    // List the branch info only if it is not the $lastBranch
    listBranch($row2);
	
    } // End check if New Company loop
    
	// List all Contacts in the Branch
	
	listBranchContact($row2);
		
	} // End Branch Loop
	
	echo "</td></tr>";

// Free result set
mysqli_free_result($result2);

echo "</table>";

mysqli_close($mysqli);

?>

Attached Files adminer_bern_br_join_cont.png 450.37KB 0 downloads