PHP - Hard To Explain Here, But It's Simple

I get the following error:
Quote

Parse error: syntax error, unexpected ';' in /hermes/web06/b1946/moo.rghollenbeck/index.php on line 35


But here is the only php code on the whole page:


. . .more html code above
<?php 

// PHP version: 5.2.12
// MySQL Version: 5.0.77

$link = mysql_connect('path', 'username', 'pword'); 
if (!$link) { 
die('Could not connect: ' . mysql_error()); 
} 
mysql_select_db(guestlist); 

$Users_IP_address = $_SERVER["REMOTE_ADDR"] ;
echo "<input type='hidden' name='ip' value=";
echo $Users_IP_address;
echo ">";

$first_name=mysql_query("SELECT 'fname' FROM tblMain; WHERE 'ip'=" . $Users_IP_address);

// pseudocode section:
// If $first_name !null{
// echo "Hello " . $first_name;
// }
// end pseudocode section:
// something like that
?>
more html code below. . .

Thank you.

Hi guys,

Here's my problem.  My company wants to use SSRS to generate reports.  The backend, what stores the data for the report is MS SQL 2005 (and no, I can't upgrade it to 2008, we don't have the licenses for it).

When I used one of their examples to login, I got an error stating that the URL, username or password might not be correct.  But when I do this, I connect just fine:
Code: [Select]
$client = new SoapClient("http://sampleURL/reportserver/reportexecution2005.asmx?wsdl", array('login' => "lmaster\SVCWEBDOCS", 'password' => "pdfconverter"));
Now, honestly, I don't know much about this and I'm still doing some research, has anyone tried to make this SDK spit out a report?  I'd appreciate some guidance/direction as to what to do next.  Also, if you could tell me about some of your experiences in getting to work, I'd really appreciate it.

This topic has been moved to MySQL Help.

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

In ubuntu 18.10 ,  i created a folder name db in the external usb hard dirve changed the ownership to the www-data the apache2 server and set the permissions to 777 , i run this php code and get the permission error:

<php
 chdir('/media/user/e46cafba-2656-4e42-b1c9-6417f28839df/db/');
 system('./rs');
?>    

but the php code cannot change to the dir and get the error:

[21-Feb-2019 10:43:26 UTC] PHP Warning:  chdir(): Permission denied (errno 13) in /home/user/www/html/rse4db.php on line 5

 

hey guys

so I have this code:
$result = mysql_query("SELECT * FROM pec_mssgs  ORDER BY (y / m) DESC, d ASC");

while($row = mysql_fetch_array($result))
  {
  
  
echo "&bull;<a style='text-decoration: underline; font-weight: bold;' href='../index?id=".$row['id']."'>". $row['m']."/".$row['d']."/".$row['y'] . "  -  ".$row['title']."</a>";
echo "<br /><br />";


  }

in my database instead of doing date I have 3 rows d, m, y, which correlate to day, month, year.

now currently its echo out a list and sorting by year then month then day this way the events which are happening soonest will be at top.

the problem is it shows events that has already passed.

what do I do?

It will be way to much work to to back and recode the application to just use date.

is there a way I can create a var. using my d/m/y then compare that var. to the current date or something?

thanks for the help.

I'd like to detect emails that hard bounce after i send out my newsletter, and then delete them from the table that stores them in my database.

Any ideas? Thank you.

in the following code I am unable to understand the purpose of @
Code: [Select]
function get_categories(){
//query database for a list of categories
$conn = db_connect();
$query ="select catid, catname from categories";
$result = @$conn->query($query);
if (!$result){
return false;
}
$num_cats = @$result->num_rows;
if($num_cats==0)
{
return false;
}
$result = db_result_to_array($result);
return false;
}
function db_result_to_array($result)
{
$res_array = array();
for ($count=0; $row = $result->fetch_assoc(); $count++){
$res_array[$count] = $row;
}

return $res_array;
}

If a user is using internet explorer, display error "You are not using a browser that is supported. Please reload in Google Chrome or Mozilla Firefox to access content", otherwise display page.

Not sure if this is possible with an if else statement, or even php for that matter. Does anyone know what I'm talking about, and if so, any suggestions?

the more source code i see this in, =.  , the more intrigued i am by it, i cant find tuts on it anywhere it cant be searched. please explain what it is and how to use it please.

 hello, i seem to be stuck again and this bug is difficult for me to solve.

if(isset($_POST['boards']))
	$boards[] = $_POST['boards'];
$allboards = implode("",$boards[0]);
echo $allboards;

outputs (browser source)...
hello
world

I have a combobox with the "multiple" property.  when two items are selected, the combobox "name" property has an array that passes to the $_POST variable. what i would like is those two words to be displayed on the same line.
I have tried rtrim($var, "\r\n") but that does nothing.

the reason i need them on the same line is because i would change then to "hello, world" and then add them as a mysql query, for example... $query = "SELECT hello, world FROM table...

Hi all,

I have created a successful registration and login page for what will eventually be a squash league website.

I am struggling with the following issue.

When a player logs in using their email address and password I want to populate some drop down boxes which are relevant to the person who has just logged in.

These drop downs should show all the leagues the logged in user belongs to and the other drop down should show all the players the currently logged in player has ever played against so that they could view a head to head.

So my code works but currently I have the id of the player who has logged in hard coded in my sql statements.

I'm wondering if anyone can help me so that I can pass in the id of the player who is logged in as obviously the whole site is not going to work with hard coded values.

The code is as follows:

Code: [Select]
<?php

include_once $_SERVER['DOCUMENT_ROOT'] . '/includes/magicquotes.inc.php';

require_once $_SERVER['DOCUMENT_ROOT'] . '/includes/access.inc.php';

if (!userIsLoggedIn())
{
 include 'login.html.php';
 exit();
}

if (!userHasRole('Squash Administrator'))
{
 $error = 'This page is only for Squash Administrators.';
 include 'accessdenied.html.php';
 exit();
}

if(isset($_REQUEST['email']))
{
 include $_SERVER['DOCUMENT_ROOT'] . '/includes/db.inc.php';
 
 $email = mysqli_real_escape_string($link, $_REQUEST['email']);
 $sql = "SELECT id, firstname, lastname, email FROM player WHERE email = '$email'";
 $result = mysqli_query($link, $sql);
 if(!$result)
 {
  $error = 'Unable to select players firstname from the database.' . mysqli_error($link);
  include 'error.html.php';
  exit();
 }
 
 while($row = mysqli_fetch_array($result))
 {
  $players[] = array('id' => $row['id'], 'firstname' => $row['firstname'], 'lastname' => $row['lastname'], 'email' => $row['email']);
 }

 //
 //POPULATE THE OPPONENTS DROP DOWN BOX TO SHOW ALL PREVIOUS OPPONENTS
 //

 $sqlid = "SELECT id FROM player WHERE email = '$email'";
 $playerid = mysqli_query($link, $sqlid);
 $sql = "SELECT DISTINCT player.firstname, game.player2_id AS opponent_id
 
FROM player INNER JOIN game
                
                ON player.id = game.player2_id

WHERE player1_id = '$row['id']'

UNION

SELECT DISTINCT player.firstname, game.player1_id AS opponent_id

FROM player INNER JOIN game
                
                ON player.id = game.player1_id

WHERE player2_id = '$row['id']'";

 $result = mysqli_query($link, $sql);
 if(!$result)
 {
  $error = 'Unable to populate the players dropdown from the database.' . mysqli_error($link);
  include 'error.html.php';
  exit();
 }
 
 while($row = mysqli_fetch_array($result))
 {
  $opponents[] = array('id' => $row['opponent_id'], 'firstname' => $row['firstname']);
 }

include 'squash.html.php';

}

?>
Thanks for your help and time in advance.

Hi guys. First of, English is not my spoken language so have patience

I've google it and done some reading regarding "hard refresh" but i cant find the information i'm looking for.
Lets say that i visit a website that i've visit 6 month earlier, and what if they done some changes that require a so called hard refresh. How should people know that the site require a ctrl+5?
I mean, i could be visit sites that looks different without my knowledge, that could been changed several month ago?

How does it work? Is it manage automatically or is it up to the webmaster to implate some codes like
Code: [Select]
<?php
header("Cache-Control: no-cache, must-revalidate"); // HTTP/1.1
header("Expires: Sat, 26 Jul 1997 05:00:00 GMT"); // Date in the past
?>
I dont know much about site development and i try to learn as much as i can. Is there no better way to handle this.

And my second question.
Where should i paste codes like this to solve the cache problem? In the header.php?

hello,

if i have

$big=3410

how can i take the last 2 digits of that to make it so that i only get the 10?

hope this makes sence.

hello dear php-experts


how to testrun a drive with command-line?

note: i had several blank screens during the last week

does this somewhat have to  do with the hard-drive?

which tests can be done?

I am working with wordpress. I am coding some custom meta boxes following some code someone else had written. My code is working but I am not sure if I need to do it the way I am doing it. The person who wrote the code added the option like so

Code: [Select]
$custom = get_post_meta($post->ID);
$item_link = $custom["item_link"][0];

According to the wordpress codex, get_post_meta($post->ID) Returns a multidimensional array with all custom fields of a particular post or page.
so when I added a second option, I followed with this

Code: [Select]
$item_text = $custom["item_text"][0];
I guess my question would be..Do i need to add the index 0 to every option or should I increase it by 1 for every new option I add?