• Help
  • Search
  • Login
  • Register
  • Home

Forum: web design and graphics community

Celestial Star Forum > Web Development > Coding > help!!!! php mysql download/installation and questions
Pages: [1]
« previous next »
  Print  
Author Topic: help!!!! php mysql download/installation and questions  (Read 1058 times)
impressiondesigns
Skogul
**
Posts: 43


View Profile WWW
help!!!! php mysql download/installation and questions
« on: September 14, 2006, 08:46:31 PM »
OMG ok so ive been trying to understand the basics of php, mysql for 2 weeks now and i dont get A THING! im so confused! do i need to download both php and mysql to start up a website that uses that? i have an account on 1500mb.com but i have NO idea how to start it up! im desperate. i really really really need help. someone PLEASE help me :[ what does php do? what does mysql do? are they the same thing? do i need BOTH to make a website?  i know i need the ftp thing, but i dont even know what that is either! well...ive installed it. but idk where to start. whether its reading a tutorial for php or reading a tutorial for mysql. all i know is im confused as hell and its really frustrating me. PLEASE could someone help me?!?  :oops:
Logged
assie-chan
Retribution
***
Posts: 156



View Profile WWW
help!!!! php mysql download/installation and questions
« Reply #1 on: September 15, 2006, 08:19:16 AM »
I have a tutorial on FTP here: http://vitae.infinite9.net/index.php?Key=Tutorials&SubKey=FTP

Now, PHP and MySQL are already set up on your website, you don't need to download them for anything (unless you want to debug PHP on your computer, but let's not get into that, chance are, you don't want to do that anyways)

PHP is a scripting language, and MySQL is a database. It functions like a table you would write on paper, to organise and store information, except it's digital =) Using PHP you can hook up to your MySQL database and display information from your database on your website. PHP also has lots of other nifty tricks, but mostly it's used for connecting to a database. Or including files for easy layout changing. I suggest Googling PHP.
Logged
"If Xerxes was two men, and he was the only two men alive, I wouldnt allow him/them to have intercourse."
impressiondesigns
Skogul
**
Posts: 43


View Profile WWW
help!!!! php mysql download/installation and questions
« Reply #2 on: September 15, 2006, 09:04:15 PM »
THANK YOU SOOO MUCH :] that helped. heres my other question though...when i try to type in queries it says "SQL queries" ..do i type mysql coding in there or do i put php in there? i tried php and it says that an error occurred so i should check the mysql syntax. so i check it out, but then it doesnt really explain whats wrong. and if it does...then i dont understand it :/ and like..i dont really know how to START. :/
Logged
Blackstone
Administrator
Valkyrie Randgris
*****
Posts: 821

Oh look! People!


View Profile
help!!!! php mysql download/installation and questions
« Reply #3 on: September 15, 2006, 11:07:32 PM »
Could you post the queries you used, and what you want the query to do? For example, do you want to insert a row, or what?
Logged
impressiondesigns
Skogul
**
Posts: 43


View Profile WWW
help!!!! php mysql download/installation and questions
« Reply #4 on: September 16, 2006, 12:06:51 AM »
i forgot what i used. i just kinda copied a code i found in a tutorial since i was just trying out what certain codes would do since i dont know any yet. well what i want to do is be able to make tables and stuff and understand php. but what i dont know is if im suppose to type php or mysql into the sql query window. so i gues yeah..i want to make rows and tables and all that. would you guys happen to know any tutorials that are easily understandable? or would you guys have the time to help me out? and thanks for replying btw :] i really appreciate it.
Logged
impressiondesigns
Skogul
**
Posts: 43


View Profile WWW
help!!!! php mysql download/installation and questions
« Reply #5 on: September 16, 2006, 02:24:56 AM »
wait i found it. this is what i put...


<html>
<body>

<?php
$d=date("D");
if ($d=="Fri")
  echo "Have a nice weekend!";
else
  echo "Have a nice day!";
?>

</body>
</html>


and this is the result



Error

There seems to be an error in your SQL query. The MySQL server error output below, if there is any, may also help you in diagnosing the problem

ERROR: Unknown Punctuation String @ 16
STR: <?
SQL: <html>
<body>

<?php
$d=date("D");


SQL query:

MySQL said: Documentation
#1064 - 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 '<html>
<body>

<?php
$d=date("D")' at line 1
Logged
Blackstone
Administrator
Valkyrie Randgris
*****
Posts: 821

Oh look! People!


View Profile
help!!!! php mysql download/installation and questions
« Reply #6 on: September 16, 2006, 09:42:59 AM »
Yeah, you need to put in MySQL queries, you can't use PHP or anything. What are you using to work with MySQL? PHPMyAdmin?
Logged
impressiondesigns
Skogul
**
Posts: 43


View Profile WWW
help!!!! php mysql download/installation and questions
« Reply #7 on: September 16, 2006, 10:49:02 AM »
oo ok. yeah im using phpmyadmin.
Logged
impressiondesigns
Skogul
**
Posts: 43


View Profile WWW
help!!!! php mysql download/installation and questions
« Reply #8 on: September 16, 2006, 11:28:52 AM »
wait..so im using MySQL and phpMyAdmin. which one is the client? and what do i do in phpMyAdmin or what do i use it for?
Logged
Blackstone
Administrator
Valkyrie Randgris
*****
Posts: 821

Oh look! People!


View Profile
help!!!! php mysql download/installation and questions
« Reply #9 on: September 16, 2006, 03:44:12 PM »
Neither of them is a client. MySQL is a database language, and PHPMyAdmin is a program that you can use to make working with MySQL easier. If you have already created a database, then you can go into PHPMyAdmin, and on the left-hand side you will see a column with your database name in it. Click on that name. It will take you to a page where you can create tables and do just about anything to that database. Explore the interface and you'll find a lot of handy tools. ^^
Logged
impressiondesigns
Skogul
**
Posts: 43


View Profile WWW
help!!!! php mysql download/installation and questions
« Reply #10 on: September 16, 2006, 04:56:53 PM »
okay thank you! :]
Logged
Blackstone
Administrator
Valkyrie Randgris
*****
Posts: 821

Oh look! People!


View Profile
help!!!! php mysql download/installation and questions
« Reply #11 on: September 16, 2006, 05:13:04 PM »
You are quite welcome! ^^ If you need any more help, just let me know. =)
Logged
Pages: [1]
  Print  
« previous next »
 
Jump to:  

  • Welcome, Guest
  • Members login
  • Register for free

General

  • General
  • New members
  • Announcements
  • Support / Suggestions

Art boards

  • Creative mediums
  • Requests and offers
  • Tutorials
  • Celestial Star tutorials

Web development

  • Coding
  • Web design
  • Advertisements / affiliation

Off-topic

  • The non-sense
  • Ententainment
Go up
eXTReMe Tracker
  • Valid XHTML
  • Valid CSS
Powered by SMF 1.1.2 | SMF © 2006-2007, Simple Machines LLC | Seo4Smf v0.2 © Webmaster's Talks
Loading...