Jump to content


phpmyadmin help


2 replies to this topic

#1 Hacker-X

    Young Padawan

  • Members
  • Pip
  • 174 posts

Posted 16 July 2005 - 01:12 PM

i'm using phpmyadmin 2.2.0 and i tried to upload a php file that checks the user's IP address and it doesn't work, so can PHPmyadmin upload php files, i'm using www.freesql.org with phpmyadmin

i also need someone to help me setup the mysql table for the IP checker

ps. i'm using this syntax (which returns an error)
<?
echo "Your IP address is [$REMOTE_ADDR]";
?>

the error is:
Error
SQL-query : [Edit]

<?
echo "Your IP address is [$REMOTE_ADDR]"

MySQL said:


You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near '<?
echo "Your IP address is [$REMOTE_ADDR]"' at line 1

Back

EDIT: never mind, i guess PHPmyadmin does upload PHP files, lol

but i still need to know what these all do:

Posted Image and i need to know what "Type" i should put the IP checker

Edited by Hacker-X, 16 July 2005 - 01:27 PM.


#2 Jaymz

    Retired P2L Staff

  • Members
  • PipPipPipPip
  • 4,104 posts

Posted 16 July 2005 - 01:14 PM

Can you post the entire code of the page please? I see nothing to do with mysql in your post ^_^

#3 rc69

    PHP Master PD

  • P2L Staff
  • PipPipPipPip
  • 3,827 posts
  • Gender:Male
  • Location:Here
  • Interests:Web Development

Posted 16 July 2005 - 11:14 PM

First off, jaymz, he thought phpmyadmin was some kind of CMS where you can upload files, and use actual php code to create a mySQL database.

Next, http://www.pixel2lif...?showtopic=8335
should answer a couple of questions.

Edit:
Lol just realized i posted a link to a topic you started ;)
Use VARCHAR for the type. Also, phpmyadmin "uploads" files. It doesn't save them anywhere, it reads the contents and executes mySQL queries from the content. But the content has to be in the proper syntax (the sticky at the top of the page as a link for that).

Also, your php is wrong.
$REMOTE_ADDR
should be:
$_SERVER['REMOTE_ADDR']





1 user(s) are reading this topic

0 members, 1 guests, 0 anonymous users