Is there a way to...

[Baevus]

This is what I want. I want to list all the usernames but it isn't working; Parse error: syntax error, unexpected T_STRING in /home/u523656928/public_html/Content/Scripts/membersmain.php on line 4. Is there a way to add a <?php tag in a <?php tag?

<?php echo $_SESSION['id']?'Click on a members name to see their profile!<br/>
<?php include 'connect.php'
// Create connection
$conn = new sql($id, $username);
// Check connection
if ($conn->connect_error) {
die("Connection failed: " . $conn->connect_error);
}
$sql = "SELECT id, username FROM Users";
$result = $conn->query($sql);
if ($result->num_rows > 0) {
// output data of each row
while($row = $result->fetch_assoc()) {
echo "<br> id: ". $row["id"]. " - Username: ". $row["username"]. "<br>;
}
} else {
echo "There are no users registered!";
}
$conn->close(); ?>':'<i>If you are seeing this you are NOT logged in! Please do so by clicking Log In | Register!</i>';?>

 

[TesoMayn]

What the hell is that code?

 

[Baevus]

What the hell is that code?

Its really messy but it's supposed to be like:
[1] - itsEthan
So you can click on their name to view their profile.

 

[TesoMayn]

First you have a PHP open tag inside another, which you don't do

Second, you never added a semicolon to the end of the include.

Clean the code up, and add proper indentation.

 

[Baevus]

I removed the PHP tags and error's are still coming up.
I tried doing this;

<div id="Container">
<div class="Header">News</div>
<?php echo $_SESSION['id']?'include 'memberscode.php'':'<i>If you are seeing this you are NOT logged in! Please do so by clicking Log In | Register!</i>';?>
</div>

But it won't allow me to do include 'memberscode.php'':' because the ' ends the line.

 

[brsy]

I didn't look at the actual functionality of the code, but I think I fixed all the syntax errors. I did this on my phone so idk.

<?php echo $_SESSION['id']; ?> Click on a members name to see their profile!<br/>
<?php include 'connect.php';
// Create connection
$conn = new sql($id, $username);
// Check connection
if ($conn->connect_error) {
die("Connection failed: " . $conn->connect_error);
}
$sql = "SELECT id, username FROM Users";
$result = $conn->query($sql);
if ($result->num_rows > 0) {
// output data of each row
while($row = $result->fetch_assoc()) {
echo "<br> id: ". $row['id']. " - Username: ". $row['username']. "<br>";
}
} else {
echo "There are no users registered!";
}
$conn->close(); ?>

<i>If you are seeing this you are NOT logged in! Please do so by clicking Log In | Register!</i>

 

[TesoMayn]

This code is just fucked, are you trying to make it so if the user is logged in it says they are, and then it shows a list of users, and if they aren't it shows the login/register

 

[Sean]

Why don't you learn PHP before you start use shorthand PHP.

 

[Baevus]

This code is just fucked, are you trying to make it so if the user is logged in it says they are, and then it shows a list of users, and if they aren't it shows the login/register

Yes, but ducklings code fixed the SYNTAX errors.
 

Yes, but ducklings code fixed the SYNTAX errors.

If you are seeing this you are NOT logged in! Please do so by clicking Log In | Register! Even if you are logged in, I'll fix it up now guys! Thanks for the help :]

 

[brsy]

Yes, but ducklings code fixed the SYNTAX errors.
 

If you are seeing this you are NOT logged in! Please do so by clicking Log In | Register! Even if you are logged in, I'll fix it up now guys! Thanks for the help :]

A "best answer" would be appreciated. Also, you need a if else statement to check if the user is logged in or not.

 

[Baevus]

Sorry to be annoying guys I'm going to be completley honest, I don't know how to hyperlink in PHP.

$sql = "SELECT id, username FROM users";
$result = $conn->query($sql);

if ($result->num_rows > 0) {
    // output data of each row
    while($row = $result->fetch_assoc()) {
        echo "User ID: <b>" . $row["id"]. "</b> - Username: <b><a href="/'. $row["username"].".php"></a></b><br>";
    }

I tried that, also tried;

<?php print ( '<a href="/'. $row["username"].".php"></a>'  );?>

 

[TesoMayn]

<?php
echo '<a href="' . $row['username'] . '.php"></a>"';
?>

 

[Baevus]

<?php
echo '<a href="' . $row['username'] . '.php"></a>";
?>

But there are already tags...

 

[TesoMayn]

Then omit the PHP tags

echo '<a href="' . $row['username'] . '.php"></a>"';

 

[Baevus]

Yeah, It came up with a SYNTAX error. :l

 

[TesoMayn]

When you are requesting help, post any errors you get, don't just say you are getting an error.

 

[Baevus]

When you are requesting help, post any errors you get, don't just say you are getting an error.

Parse error: syntax error, unexpected T_CONSTANT_ENCAPSED_STRING, expecting ',' or ';' in /home/u523656928/public_html/Content/Scripts/membersmain.php on line 20

 

[TesoMayn]

Copy and paste line 20, it appears you are missing a ; at the end.

 

[Baevus]

Copy and paste line 20, it appears you are missing a ; at the end.

Original; echo "User ID: <b>" . $row["id"]. "</b> - Username: <b>" . $row["username"]. "</b><br>";
With your edit; echo "User ID: <b>" . $row["id"]. "</b> - Username: <b>echo '<a href="' . $row['username'] . '.php"></a>"';</b><br>";

 

[TesoMayn]

What is this?

Your whole code is so fucked.

echo 'User ID: <b>' . $row["id"] . '</b> - Username: <b><a href="' . $row["username"] . '.php"></a></b><br />';

You do not put echo inside another echo or a print.