PDA

View Full Version : help !


GregT
November 3rd, 2002, 20:50
why do I get keep getting parse errors on line 5 ?



<?php
function connectsql() {
$link = @mysql_connect("mysqlserver", "yupadog", "80808");
$status = "Online !";
else {
$status = "Offline";
}
}

Plz help !
spec
November 3rd, 2002, 21:08
if thats your entire code do you have
?>
GregT
November 3rd, 2002, 21:26
Originally posted by spec
if thats your entire code do you have
?>

no thats just the first part, i have about 50 more lines and at the end a ?>
notnamed
November 3rd, 2002, 21:47
Shouldn't it be:

<?php
function connectsql() {
$link = @mysql_connect("mysqlserver", "yupadog", "80808");
$status = "Online !";
}
else {
$status = "Offline";
}

closing the connectsql function before the else?
Dusty
November 3rd, 2002, 22:10
It's hard to tell what exactly you're doing with only a snippet of the script, but my guess is you're missing a curly bracket before the else as well as the if, its condition, and its curly bracket.
function connectsql(){
$link=@mysql_connect('mysqlserver','yupadog','80808');
if( ){ # "if($link){", maybe?
$status='Online!';
}else{
$status='Offline';
}
}

I'm not certain with PHP, but you could probably shorten that if block to just:

$status=($link)?('Online!):('Offline');
GregT
November 3rd, 2002, 22:14
here's all my code. its a sql query box or the starts of one.




<?php
function connectsql() {
$link = @mysql_connect("mysqlserver", "yupadog", "80808");
$status = "Online !";
else {
$status = "Offline";
}

echo "<br>";
function sqlquery(){
echo "<p align='center'><font face='Verdana, Arial, Helvetica, sans-serif' size='5'><b><i><cite>SQL
Query</cite></i></b></font></p>
<div align='center'>
<table bgcolor='000000' width='59%' border='0' cellspacing='1' cellpadding='4'>
<tr>
<td bgcolor='eeeeee'>
<form method='$PHP_SELF' action='POST'>
<p><font face='Verdana, Arial, Helvetica, sans-serif' size='1'> &nbsp;&nbsp;&nbsp;&nbsp;Sql
Query:<br><br>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </font>
<textarea bgcolor='eeeeee' name='textfield' cols='67' rows='4'></textarea>

<p align='center'><font face='Verdana, Arial, Helvetica, sans-serif' size='1' color='#FF0000'>
<div align='left'>&nbsp;* Note: One query at a time only !</div>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</font>
<font face='Verdana, Arial, Helvetica, sans-serif' size='1' color='#FF0000'>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <br>
<div align='center'><input type='submit' name='Submit' value='Submit'></div>
</font>
</form>
</td>
</tr>
</table>
</div>
<p>&nbsp;</p>


<table bgcolor='000000' width='25%' border='0' cellspacing='1' cellpadding='4'>
<tr>
<td bgcolor='eeeeee'><font face='Verdana, Arial, Helvetica, sans-serif' size='1'>SQL Server
Status: $status</font></td>
</tr>
</table>";

}

function run(){
sqlquery();
}
run()
?>
GregT
November 3rd, 2002, 22:18
this code works :)



<?php

function connectsql(){
$link = @mysql_connect('mysqlserver.host.us','yupadog','7xxxxx');
if($link){
$status='Online!';
}else{
$status='Offline!';
}

echo "<br>";
echo "<p align='center'><font face='Verdana, Arial, Helvetica, sans-serif' size='5'><b><i><cite>SQL
Query</cite></i></b></font></p>
<div align='center'>
<table bgcolor='000000' width='59%' border='0' cellspacing='1' cellpadding='4'>
<tr>
<td bgcolor='eeeeee'>
<form method='$PHP_SELF' action='POST'>
<p><font face='Verdana, Arial, Helvetica, sans-serif' size='1'> &nbsp;&nbsp;&nbsp;&nbsp;Sql
Query:<br><br>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </font>
<textarea bgcolor='eeeeee' name='textfield' cols='67' rows='4'></textarea>

<p align='center'><font face='Verdana, Arial, Helvetica, sans-serif' size='1' color='#FF0000'>
<div align='left'>&nbsp;* Note: One query at a time only !</div>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</font>
<font face='Verdana, Arial, Helvetica, sans-serif' size='1' color='#FF0000'>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <br>
<div align='center'><input type='submit' name='Submit' value='Submit'></div>
</font>
</form>
</td>
</tr>
</table>
</div>
<p>&nbsp;</p>


<table bgcolor='000000' width='25%' border='0' cellspacing='1' cellpadding='4'>
<tr>
<td bgcolor='eeeeee'><font face='Verdana, Arial, Helvetica, sans-serif' size='1'>SQL Server
Status: $status</font></td>
</tr>
</table>";

}

function run(){
connectsql();
}
run()
?>