JTGrime
Members
-
Joined
-
Last visited
-
-
Yeah now your talking didn't even think of that one m8.
-
Hi would Gibson sue if I used their EDIT: type face to spell a name in a logo for a company that sells guitars (yes they sell Gibson too but not official stockists) and the name is very similar as the owner's name is Gibson but he's calling his business something else but still similar.. GIB is in their. my guess is yes but the client really wants this style.
-
yes it works directly in the command line :/ so it has to be and issue with passing the command over to mysql right? but then none of my error messages appear so it must be getting there, because there is no die error.
-
good point yes I have admin access and I didn't actually check the query directly I just followed the book but I will use it now in MySQL monitor CMD LNE and see if it works, if not then I'll try DROP?
-
Hi Guys, Sorry to keep mitering like this can any one see a reason why this: <?php require_once 'login.php'; $db_server = mysql_connect($db_hostname, $db_username, $db_password); if (!$db_server) { die ("Unabl to connect to MySQL" . mysql_error()); } mysql_select_db($db_database, $db_server) or die("Unable to connect to database: " . mysql_error()); if (isset($_POST['author'])&& isset($_POST['title'])&& isset($_POST['category'])&& isset($_POST['year'])&& isset($_POST['isbn'])) { $author = get_post('author'); $title = get_post('title'); $category = get_post('category'); $year = get_post('year'); $isbn = get_post('isbn'); if (isset($_POST['delete']) && $isbn != "") { $query = "DELETE FROM tblCLassics WHERE isbn='$isbn'"; if (!mysql_query($query, $db_server)) { echo "DELETE failed: $query<br />" . mysql_error() . "<br /><br />"; } } else { $query = "INSERT INTO tblClassics VALUES" . "('$author','$title','$category','$year','$isbn')"; if (!mysql_query($query, $db_server)) { echo "INSERT Failed: $query<br />" . mysql_error() . "<br /><br />"; } } } echo <<<_END <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"> <html xmlns="http://www.w3.org/1999/xhtml"> <head> <meta http-equiv="Content-Type" content="text/html; charset=utf-8" /> <title>Welcome to the Book Club</title> </head> <body> <form action="connectionTest.php" method="post"><pre> Author: <input type="text" name="author" /> Title: <input type="text" name="title" /> Category: <input type="text" name="category" /> Year: <input type="text" name="year" /> ISBN: <input type="text" name="isbn" /> <input type="submit" value="ADD RECORD" /></pre> </form> _END; $query = "SELECT * FROM tblClassics"; $results = mysql_query($query); if (!$results) { die("Database access failed: " . mysql_error()); } $rows = mysql_num_rows($results); for ($j = 0; $j < $rows ; ++$j) { $row = mysql_fetch_row($results); echo <<<_END <pre> Author: $row[0] Title: $row[1] Category: $row[2] Year: $row[3] ISBN: $row[4] </pre> <form action="connectionTest.php" method="post"> <input type="hidden" name="delete" value="yes" /> <input type="hidden" name="isbn" value="$row[4]" /> <input type="submit" value="DELETE RECORD" /> </form> _END; } echo "</body>"; echo "</html>"; mysql_close($db_server); function get_post($var) { return mysql_real_escape_string($_POST[$var]); } ?> Won't actually delete from the database? cheers.
-
This was out of a book! And I did check out the manual first but I was reading up frantically on the fopen function not the heredoc >>> oowjar'. Thanks Rob works perfectly . I frickin' love this forum.
-
Title says it all really, just learning to use the fopen close and write function and I'm getting a parsing error on line 25 which is the closing html bracket :/ <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"> <html xmlns="http://www.w3.org/1999/xhtml"> <head> <meta http-equiv="Content-Type" content="text/html; charset=utf-8" /> <title>Untitled Document</title> </head> <body> <?php //testfile.php $fh = fopen("testfile.txt", "W") or die("failed to create file"); $text = <<<_END Line1 Line2 Line3 _END; fwrite($fh, $text) or die("could not write to file"); fclose($fh); echo "file 'testfile.txt' written successfuly"; ?> </body> </html> any suggestions?
-
Hi all I'm having a problem getting rid of these text-decoration on my link text in opera and google chrome, I've gone text-decoration: none; but doesn't seem to bother chrome or opera and I did the same with an image link and that goes except for in Firefox. any advice? actually its firefox and IE8 that still displays the link border round the image, and safari not opera where the decorations occur. also chrome they only appear to display until it's been visited or hovered over then its goes away. EDIT.. Ok so fixed everything else I just can't figure out why the image wont work. Maybe I'm better off creating a hotspot instead of wrapping a <a> around an image lol. EDIT sorted it sorry.
-
yes I thought the same thing already moved it now I need to come up with something else that gives the site that woot factor.
-
Just wondered what some of you guys thought about the layout of my site. I'm no designer as some of you may know, my thing is with the development particularly PHP, but I've given it a good bash and I think it kinda looks retro electro cool. Screen of layout P.s. The wording isn't gonna stay I'm gonna reword the copy, just a place holder and I'm gonna rearrange the colour on the tabs orange, turquoise, pink then mint.
-
Just wanted to say I am only half way through this book Ignore Everybody and 39 other keys to creativity by Hugh Macleod. I must say it's a really good book, very insightful and has brought to my attention something I had never considered before, Creativity! Well obviously we all know what it means but have any of use really quantified it? I really like this book so far and I would definitely suggest you give it a read. One of his points is that creativity brings responsibility and often people will be resistant to your ideas or concepts because they fear change feel threatened by you or cannot see an idea the way to do, no matter how hard you try to explain it. All in all a very good book and well worth the read.
-
Hi could someone point me in the right direction on the subject perhaps something to read or how I go about researching contract... I'm referring to supply chain management and if any of the big couriers offer an API or some sort of plug-in or service to auto order a deliver for a product ordered through an eCommerce site. cheers.
-
Lol just read my post and the spelling is terrible. I had a headache when I was writing that. I'll edit it later :s
-
Hi, So I'm assuming your going the academic route. Perhaps an OU course in web technologies or go back to college. From what I can gather the W3C stuff doesn't matter for spit and if you haven't got the time to study for a qualification just learn it your self there is some really good books out there, dependent on what rout you go down. Client Side: HTML 4 & XHTML (Sams teach your self is really good and don't make me think.)Sams are really good if your not a solid reader its more digestible in an hourly format. JavaScript (O'Rilley) <-- these are really good at explaining the broader concepts and the abstract functionality of a language in a clean concise format with real world examples which we ca all relate too). XML (Sams teach yourself again) Server side: PHP & MySQL <- really good open source scripting language with a huge community. Tis has the largest market share.(O'Rielly PHP,java script and XML, essential PHP security, PHP,MySql and apace) ASP.Net <-- Microsoft can use C# or VB.net both relatively simple to learn has a massive level of support but most people want developers with experience for this tech as its often big eCommerce project done in it, that's not to say its only eCommerce. Microsoft have a massive library o this stuff with videos all for free and the IDE is free also in the express edition. Ruby on Rails <-- Like PHP but its object orientated right out the box based on the ruby language which I find can be buggy on windows but meh I aint getting into the in's 'n' out's of that. you'll have to look up books on that. AJAX <-- not sure is this constitutes Server side as to my understanding its Asymmetrical JavaScript and XML so I' guessing the XML is stored on the server and the JavaScript accesses it like a DB, I dunno I plan to start on this in the next few months myself. So my point Unless its through the OU or some other academic institution your certificate aint gonna be worth much so your best approach is towards taking a class, but if you don't have time just start reading. Because not mater which route your go its all theory with little or no experience behind it to produce anything. You may find someone who just reads a bit and practices nightly with little project may be far superior to someone with a degree in web technologies or new media ect. So Read books and practice here is no golden ticket to being a god developer even if you have that certificate. P.s. look at systems analysis too data analysis and design, database design concepts (Ritchie. C Relational Database principals) and project management and software engineering (particularly, Pressman. S Software engineering: A practitioners approach 7th, edition as he focuses on web applications). P.p.s Dunno if any of this helps but even if you become a student you'll still have to read this stuff!
-
Thanks for the advice
