Kellyeld85

Using Dreamweaver

Hi I've been trying to put recaptcha on my blog now for 4 days because of spammers. It works when I put it on the contact form but not the blog can anyone tell me where to put the serverside code which is this: <?php require_once('recaptchalib.php'); $privatekey = "your_private_key"; $resp = recaptcha_check_answer ($privatekey, $_SERVER["REMOTE_ADDR"], $_POST["recaptcha_challenge_field"], $_POST["recaptcha_response_field"]); if (!$resp->is_valid) { // What happens when the CAPTCHA was entered incorrectly die ("The reCAPTCHA wasn't entered correctly. Go back and try it again." . "(reCAPTCHA said: " . $resp->error . ")"); } else { // Your code here to handle a successful verification } ?> In this code which is at the top of my blog page: (I've marked where I put it with 'I PUT IT HERE' and 'AND I TRIED IT HERE) // I PUT IT HERE <?php require_once('../Connections/blog.php'); ?> <?php if (!function_exists("GetSQLValueString")) { function GetSQLValueString($theValue, $theType, $theDefinedValue = "", $theNotDefinedValue = "") { $theValue = get_magic_quotes_gpc() ? stripslashes($theValue) : $theValue; $theValue = function_exists("mysql_real_escape_string") ? mysql_real_escape_string($theValue) : mysql_escape_string($theValue); switch ($theType) { case "text": $theValue = ($theValue != "") ? "'" . $theValue . "'" : "NULL"; break; case "long": case "int": $theValue = ($theValue != "") ? intval($theValue) : "NULL"; break; case "double": $theValue = ($theValue != "") ? "'" . doubleval($theValue) . "'" : "NULL"; break; case "date": $theValue = ($theValue != "") ? "'" . $theValue . "'" : "NULL"; break; case "defined": $theValue = ($theValue != "") ? $theDefinedValue : $theNotDefinedValue; break; } return $theValue; } } // AND I TRIED IT HERE $editFormAction = $_SERVER['PHP_SELF']; if (isset($_SERVER['QUERY_STRING'])) { $editFormAction .= "?" . htmlentities($_SERVER['QUERY_STRING']); } if ((isset($_POST["MM_insert"])) && ($_POST["MM_insert"] == "comment")) { $insertSQL = sprintf("INSERT INTO blogmain (name, email, `comment`) VALUES (%s, %s, %s)", GetSQLValueString($_POST['name'], "text"), GetSQLValueString($_POST['email'], "text"), GetSQLValueString($_POST['comment'], "text")); mysql_select_db($database_blog, $blog); $Result1 = mysql_query($insertSQL, $blog) or die(mysql_error()); $insertGoTo = "index.php"; if (isset($_SERVER['QUERY_STRING'])) { $insertGoTo .= (strpos($insertGoTo, '?')) ? "&" : "?"; $insertGoTo .= $_SERVER['QUERY_STRING']; } header(sprintf("Location: %s", $insertGoTo)); } mysql_select_db($database_blog, $blog); $query_blogmain = "SELECT * FROM blogmain"; $blogmain = mysql_query($query_blogmain, $blog) or die(mysql_error()); $row_blogmain = mysql_fetch_assoc($blogmain); $totalRows_blogmain = mysql_num_rows($blogmain); ?> I would be greatful for any help Kelly

Yes that would be right if I could make a recordset but I can't even do that because it wont display any of the tables in the database it says no tables. When I click on the tables in the recordset box to display the tables to make the SQL code the error message appears and I haven't even selected anything. Do or have you used Dreamweaver? Thanks for trying to help I don't know if it's a dreamweaver problem or a hosting problem because the tables show up fine when i connect to phpmyadmin on my computer but my hosting company is saying everything is fine and it must be dreamweaver

Yeah I changed the variables, but the localhost is what the hosting service said to put also if this wasn't correct would it still connect successfully to the database? also there is no error message when i open the tree just don't display any table in the database. I get the error message when I try to make a recordset in the advance bit which is this: "Error calling GetTables: MySQL Error#: 1064 You have an error in your SQL syntax; check the manual that correponds to you MySQL server version for the right syntax to use near '-maillist' at line1"

woops sorry thats just me copying it wrong it wouldn't let me copy and paste it for some reason here it is again copied and pasted: <?php # FileName="Connection_php_mysql.htm" # Type="MYSQL" # HTTP="true" $hostname_blog = "localhost"; $database_blog = "servername"; $username_blog = "servername"; $password_blog = "password"; $blog = mysql_pconnect($hostname_blog, $username_blog, $password_blog) or trigger_error(mysql_error(),E_USER_ERROR); ?>

Hi I tried the code it's still the same thou

Hi this is the same code

Hello I have connected to the database on my remote server in dreamweaver 8 and it says its connected successfully, but when I open the tree or try to make a recordset no tables are show and when I try it in advanced this error appears: "Error calling GetTables: MySQL Error#: 1064 You have an error in your SQL syntax; check the manual that correponds to you MySQL server version for the right syntax to use near '-maillist' at line1" maillist being my database name I'm not very good at dynamics yet so don't really understand the SQL syntax This is what dreamweaver connection made me: <?php # FileName="Connection_php_mysql.htm" # Type="MYSQL" # HTTP="true" $hostname_blog = "localhost"; $database_blog = "servername" $username_blog ="servername" $password_blog ="password" $blog = mysql_pconnect ($hostname_blog, $username_blog, $password_blog or trigger_error (mysql_error (), E_USER_ERROR); ?> Don't know if any of this makes sence to you. Please Help

Yes I wasn't suggesting people shouldn't learn html and css I just saying it's quite an easy langauge compared to php/javascript etc ... and I think its a lost easier and quicker to use dreameaver to do the code and view it so you get the hang of it quicker. I can handcode without DW but why waste time. Most of the time I just dip in and out of the code to change one thing or another to get rid of bugs or to clean it up etc ...

Hi everyone I've looked this question up but can't seem to find the answer. whenever I try to make a dynamic site using PHP with MySQL or coldfusion the picture never show in the browser. does anyone know what I'm doing wrong. Im putting in the path to the folder where the images are and I've tried it using the url path and still onthing. I'm using the server on my computer so am gathering its a configuration problem.

Yes I Just let dreamweaver do my coding for me and just learnt the basic rules. I picked a lot up having it in split view, and css is quite straight forward don't you think? The bigest thing i find with web design is most things you what to do are dynamic so if you what to be a web designer I suggest spending your time learning PHP, ASP or javascript and pick up the html as you go.

Yes the ($row_getPictures ['image'], is the connection to the database, getPictures is the name of the recordset and 'orginal/gallery_php/main_pics/') is the path to the photos. I'm using dreamweaver 8 I inserted the picture and selected data source and selected the recordset and ['image'] which is the name of the column the photos are in, in the database. <img <?php echo getDims($row_getPictures['image'],'orginal/gallery_php/main_pics/');?> src="<?php echo $row_getPictures['../../gallary/image']; ?>" alt="<?php echo $row_getPictures['caption']; ?>" /></div> <p id="picCaption"><?php echo $row_getPictures['caption']; ?></p>

I tried using BLOB and loading the images on to see if was because I was using VARCHAR but I still get no Pictures just the captions.

I stored the images on the database using VARCHAR. This is the HTML code : <h1><br /> Tanzania Photo Gallery </h1> <p> </p> <div id="pictureWrapper"> <div id="mainpic"><img <?php echo getDims($row_getPictures['image'],'orginal/gallery_php/main_pics/');?> src="<?php echo $row_getPictures['../../gallary/image']; ?>" alt="<?php echo $row_getPictures['caption']; ?>" /></div> <p id="picCaption"><?php echo $row_getPictures['caption']; ?></p> </div> <div id="thumbnails"> <table> <tr> <?php do { // horizontal looper version 3 ?> <td><a href="orginal/gallery_php/main_pics/<?php echo $row_getPictures['image']; ?>"onclick="showImage(this);return false;"><img src="orginal/gallery_php/thumbnails/<?php echo $row_getPictures['image']; ?>" border="0" <?php echo getDims($row_getPictures['image'],'orginal/gallery_php/thumbnails/'); ?> /></a></td> <?php $row_getPictures = mysql_fetch_assoc($getPictures); if (!isset($nested_getPictures)) { $nested_getPictures= 1; } if (isset($row_getPictures) && is_array($row_getPictures) && $nested_getPictures++ % 3==0) { echo "</tr><tr>"; } } while ($row_getPictures); //end horizontal looper version 3 ?> </tr> </table> <table id="pageNav"> <tr> <td width="23%" align="center"><?php if ($pageNum_getPictures > 0) { // Show if not first page ?> <a href="<?php printf("%s?pageNum_getPictures=%d%s", $currentPage, 0, $queryString_getPictures); ?>"><img src="First.gif" border=0></a> <?php } // Show if not first page ?> </td> <td width="31%" align="center"><?php if ($pageNum_getPictures > 0) { // Show if not first page ?> <a href="<?php printf("%s?pageNum_getPictures=%d%s", $currentPage, max(0, $pageNum_getPictures - 1), $queryString_getPictures); ?>"><img src="Previous.gif" border=0></a> <?php } // Show if not first page ?> </td> <td width="23%" align="center"><?php if ($pageNum_getPictures < $totalPages_getPictures) { // Show if not last page ?> <a href="<?php printf("%s?pageNum_getPictures=%d%s", $currentPage, min($totalPages_getPictures, $pageNum_getPictures + 1), $queryString_getPictures); ?>"><img src="Next.gif" border=0></a> <?php } // Show if not last page ?> </td> <td width="23%" align="center"><?php if ($pageNum_getPictures < $totalPages_getPictures) { // Show if not last page ?> <a href="<?php printf("%s?pageNum_getPictures=%d%s", $currentPage, $totalPages_getPictures, $queryString_getPictures); ?>"><img src="Last.gif" border=0></a> <?php } // Show if not last page ?> </td> </tr> </table> <p><?php include('message.txt'); ?> </p> </div>

Hi I'm trying to make a gallery in php, the pictures are in MySQL database but when I View it in the browsers the pictures don't display just the alt or the red x. Can anyone help I'm new to php. Do I have to enable something on the server?

Thank you also I will look into that

Thank you that is exactly what I wanted to know. Didn't know if it would affect the site in anyway.

Hi Does anyone know if I can put a PHP page in a html site. I have a html site but want to put a PHP gallery in it and can't be bothered to change all the file names.

Hi Just wondering does dreamweaver 8 support asp.net?

Hi I'm just learning php to make dynamic websites but have found that most site I go on are using ASP which one is better? And what is a Linux server?

Hi I usually just add this to the wrapper or container div: </head> <body> <div align="center" id="wrapper"> //everything inside the wrapper </div> I did try it the css way (auto, 0) but in some browsers it didn't center, so I looked at the source code on other websites and found this worked best for me.

Hi I work with dreamweaver 8 and wanted to learn how to built e-commerce websites but all the books involve writting loads of code, so the best book I found was PHP for Dreamweaver 8 by David Powers. It explains everything and tells you how to do it in dreamweaver so if dreamweaver can write the code for you he tell you how. His doesn't make an e-commerce site in this book but you can make an e-commerce website the same way, and it helped me under stand PHP better.