TranceAddict Forums (www.tranceaddict.com/forums)
- Chill Out Room
-- Any PHP and MySQL buffs here?

Any PHP and MySQL buffs here?

Hey, I got a question for you all. Well I have a database project due soon, and well, to tell ya the truth, I am TOTALLY lost :P. I need some help on how to get PHP and MySql to work properly together. I've tried looking online, but keep getting errors. Any help is appreciated!



Thanks,

Vaedyn

do you have to use php ??
php is cool .. which one are you using ?? i use ActivePerl, and it provides me with automatic tutorial to get a database connection and proper working ...

did you download the proper mysql drivers to connect perl with mysql ??

i say if you want to go real easy, then go with java and tomcat to do some jsp pages .. imo i feel more comfortable with that .. then again, i feel more comfortable with database felxibility with java than perl .. i need to work on my perl skillz ..

quote:

Originally posted by Nou Oh and dont listen to him jsp... evilness never had a clearer name.

what is your problem with jsp ? jsp is a very good, especially being that it roots from free source material .. although i do know that php is more reliable with connections and easy object handling, i have some strange connection with java and tomcat .. maybe if i force myself into more perl and c stuff, i will love php more ..

but what gives you jsp problems ... the scriplets ?? the servlets ?? the web.xml file ?? your connections between your server and client ??

i don't understand the intraweb need help right away.

quote:

Originally posted by Nou I just never really liked the syntax of Java all that much, Im just picky, but you probably started out coding Java stuff, while I started out with Perl and then C,C++ and then later PHP...

go figure .. i also started with c/c++ .. then it was vb .. then java .. databases is my thing .. structures, connections, the whole mumbo jumbo ...

quote:

Originally posted by Nou I <3 databases too... as long as I dont have to write long ass queries into my code...

oooh .. correlated sub queries with aggregate functions and cartesian joins ... my fav .. i eat that for breakfast, lunch, and dinner ..

quote:

Originally posted by Nou ok i need to study up on sql shit... and learn some higher end databases too, but that means going to school... i know like basic basic stuff, i can barely get indexes to work right (not that i have ever needed them, i havnt written anything that would get that large *thinks about TA's dbs and how long it must take to index them*) sometimes i feel so inadequate.

nah .. you're cool ..
i learned from a friend of mine who is a db administrator that the 3 main things to know for the job for databases are ::
1- functional dependencies, and if you know how to set up a nice table with columns (some may call them attributes)
2- know how to create the relationships (primary, secondary, foreign, super)
3- know how to make join queries ...


and you're set for a good job.

quote:

Originally posted by Nou what do you recomend as a good site/book to learn this stuff... i know of those things, but i dont know how or when to implement them really... specially stuff like join queries, i dont know what that is even... lol i know insert, select, update, drop... lol thats all i ever find myself needing to use.

the mysql manual is awesome (from www.mysql.com.. i think ) .. also a whole bunch of database examples from microsoft (ms-sql) and oracle sites provide some good stuff to read ..

i can't really recommend much, because i have the expensive books explaining about the mathematical algorithms of sql queries .. .. but i think those o'reilly nutshell series has a book on 'sql', and i trust them to print good material .. their java for j2se is the bible for me .. i practically ripped out most of the binding ..

Yo dawgs,

Where'd learn them scripts? I wanna be scripting in PHP wit SQL but I can't do them tings I want. How did you begin?

Peace.

yo dawg ...
sql is NOT a web-based scripting language ..
sql = structured query language

it is a special language that you send to your database .. sorry to break the news ..

quote:

Originally posted by LeopoldStotch yo dawg ... sql is NOT a web-based scripting language .. sql = structured query language it is a special language that you send to your database .. sorry to break the news ..

I was just trying to get into today's mood and got the terms mixed up

But the question remains. How did you guys learn PHP and SQL? I've tried the manuals, but it seems like a bunch of disorganised information

quote:

Originally posted by Lira I was just trying to get into today's mood and got the terms mixed up But the question remains. How did you guys learn PHP and SQL? I've tried the manuals, but it seems like a bunch of disorganised information

you can start off by getting ActivePerl (that's the one i have, and it contains a whole bunch of catalog information about perl keywords and implementing c with perl) and the mysql manual .. good examples in each of them ..

but i think the best is get some cheap books on amazon and e-bay .. if you want to learn the basics and get yourself going in SQL, follow my instructions above .. you want to get real hardcore with query Views and database administration junk like grants and user stuff, then you need to get those thick books, and find a place where they have oracle for free .. hahahhahaah .. like if it is ..

quote:

Originally posted by Lira I was just trying to get into today's mood and got the terms mixed up But the question remains. How did you guys learn PHP and SQL? I've tried the manuals, but it seems like a bunch of disorganised information

the most important thing when learning php and mysql is to have a project to use it on. If your just memorizing it for maybe some future use your screwed. So think of a site and learn how to do it in php/mysql.




thats how I half assed learned php n mysql. w0rd.

quote:

Originally posted by Nou +1111 write up a simple little app thingy, like i made a photo viewer for shits and giggles (err i didnt do this to learn mysql, i just was bored). anyways, it uses mysql to hold the news and comments on images... http://mobile.cyberia.fm/ Im still building alot of parts tho for it, and im gunna write it to switch between mysql and using xml files, so people who dont have mysql db's on their site can just use xml files. but yea, just make a simple little like blog thing or something, blogs are probably the easiest web programs to write.

Wimp. I created a site called "The Central Controller" in which it controls every aspect of your life.


kinda neat.

Thanks Leopold and Nou

I've got a project already, Boomer, that's why I'm lost. I'm trying to get exactly what I want and it seems it's not as easy as I had expected.

I'm gonna try to find a good book and I'm readin the sites you recommended Nou (w3schools does rule, by the way, learned CSS there )

quote:

Originally posted by Nou Hrmmm, yea if I remember you were doing something with a Kanji database.... or something along those lines... Im trying to figure out the kanji for the name なのか　but i hate using multi radical dictionaries... anyways yea thats a really complex first project if thats what it is.

���� = �Ȃ̂�?@

What I want is to design that simple sort of webpages, in which there's some content that might be used in different places (i.e. for the head I choose these paragraphs, for the body I want to use these others...). Typing in Japanese is no longer a problem so, yeah, it's quite simple now.

Truth be said, I want to get into e-learning :/

edit: are you talking about the nanoko from your avatar? If so, names hardly have a strict kanji writing. For example: You can write Akira these ways... ��?A?�?A��?A��?A?�?A�j?A����?A�U... see what I mean?

Powered by: vBulletin
Copyright © 2000-2021, Jelsoft Enterprises Ltd.