ok .. this may sound really stupid .. but my question was .. all those keywords and statements stays in the hard disk right? i mean .. i like to think of the hard disk as a flat file system of files ... which is the only way i know how to see them binary files like stapler pins the php interpretor is on the hard disk .. right ?
It's on the web server's hard disk. (Or on yours if you're running a local web server.) The intepreter recognizes the keywords, it's not a list of them.
i was reading a tutorial on retreiving files.. with the help of php and mysql that means mostly retreving rows or records... in the table for example after trying to insert data from a form INSERT INTO "tablename" VALUES ( $variable_name , $variable_name , $variable_name) from the form i will try to retrieve these from the table that is inserted into ... right ? can anyone explain what that data,filetype means in the below mysql select query? $query = "SELECT data,filetype FROM "tablename" where id=$id"; i have also learned from somewhere that you can create a link to a particular row or record in the table <a href = <? echo $id; ?>
i dont see an edit button .. this pic was missing from the above thread .. i dont know where did it dissapear into ..lol
and if you keep this here .. i guess it give you a better understanding of how html php mysql .. works.. how code works in a line by line manner you know the variable name , variable value that comes from an html form .. then the php script starts working .. inserts the value to the variable name in the database table of mysql .....
Right - if the fields (columns) in the database are numeric. If they're text, it's INSERT INTO "tablename" VALUES ( '$variable_name' , '$variable_name' , '$variable_name') Text and date field data gets quoted, numeric doesn't. They're field (column) names. You're only getting those two fields, even if there are more fields in the table. You also insert and update specific fields that way. Only if $id (which is a PHP variable) already has the value of the field in the database. (A record [or row] is an array of fields, and you usually use a variable for a single field.) $id gets the value from the code that SELECTs it and puts it into $id.
Better, you won't need patience in selling and making ice cream, than in learning a new computer language.
Because you're trying to learn computer technology, programming, PHP and SQL all at once, instead of taking them in a logical order. Forget how data sits on a hard drive or how keywords are saved - those have nothing to do with programming. If you want to design hardware, forget about programming and get a degree in digital electronics. If you want to learn programming, start by learning programming. Algorithms + Data Structures.pdf may help. And don't expect to get it in an hour - it will probably take a couple of months to read it all and understand it.