justlukeyou

Hi, I have built my site in PHP but now I want to update it into PDO. However I have tried searching Amazon for PDO but nothing it coming based on PDO. Can anyone recommend a clear and easy to use book based on PDO please?

I understand where your coming from but I have heard so many different things I am confused. Some of which appear to completely contradict one another. Is there a simple, plain English guide on what code to use?

Hi, We peoples help on here I have built a website and I have businesses registering which I am delighted with. However a number of companies are not completing their profiles. I dont know if this is because they dont receive the confirmation email or the process is to long. I have emailed some of the companies but they dont respond. The site is B2B and requires quite a lot of information as I need the information to make the site work. Some businesses fully register and enter all the details required. Can anyone suggest how to improve the registration sytem or best practice for a registration system?

Hi, I have a code which displays the Tweets from my Twitter profiles however they have stopped working. <script src="http://twitter.com/javascripts/blogger.js" type="text/javascript"> </script> <script src="http://api.twitter.com/1/statuses/user_timeline.json?screen_name=bbc&include_rts=1&callback=twitterCallback2&count=7" type="text/javascript"> </script> </div>

Thanks but I dont understand it. Could add anymore detail please? I want someone to click on Web Design and siplay User 17.

Another great one is locations. So a New York company could start #NewYorkBizHour So companies based in New York talk for one hour a week. The company that hosts the Twitter.com/NewYorkBizHour will get alot of exposure!

You also use the relevant hash tag. So if you are looking for an SEO company you post #SEOHour and SEO companies taking part in the weekly SEO Hour will see it. If an SEO company hosts SEO Hour they will be the focal point!

Hi, There is one Twitter point which acts as the host. It motivates people in a specific industry to talk and communicate at the same time for one hour. So its like a weekly online get together. So someone could register Twitter.com/SEOHour And for one hour a week all the leading players talk about SEO. Or Twitter.com/WebMarketingHour

Hi, Has anyone joined any Twitter Hours? Basically they are weely online timed events for specific industies. For example https://twitter.com/eventhour #eventhour is held every Wednesdays 9-10 GMT so everyone in the events industrys networks for one hour. In its first week it reached 22,000 Twitter accounts. People could do all sorts. For example: #webdesignhour #KickStarterHour #CateringHour Has anyone joined one of these?

Could I do something like this... http://myDomain.com/links.php?id=17&sk1=Web+Design&sk2=Graphic+Design&sk3=SEO+Marketing >Web Design</a> http://myDomain.com/links.php?id=17&sk1=Web+Design&sk2=Graphic+Design&sk3=SEO+Marketing >Graphic Design</a>

Hi, I have been trying to complete a multi-dimensional array. The idea is that someone can click on 1 of 3 skills. I have tried to insert the skills and User ID into its own table. However I still cant create a link which reads all 3 skills. Does anyone have any suggestions as to how I can create a link which reads 3 different rows? Skill1: Web Design User ID: 17 Skill2: Graphic Design User ID: 17 Skill3: SEO Marketing User ID: 17 eventskillsquery.php?skill= Reads skill1 / skill2 or skill3

Hi, Im quite confused though. I though their would be a standard method to aichieve this? Is itpossible that Im doing something wrong like saving the file in the wrong format?

Hi, Raised a case with my host and they advised that their is nothing stopping a mod_rewrite from working Im looking pretty URLs so they are appear better.

Hi, I have a director called "siteinfo" so I tried the following but it had no affect. Can I just check two things: 1. Does the file need to save in a certain format. I am just using Notepad and saving it in a test file 2. Is the file called "htaccess" or ".htaccess" I have tried both and tried to save the file in different formats but still no impact. RewriteEngine on RewriteCond %{REQUEST_URI} ^/siteinfo/([a-z]+)\.php$ RewriteRule ^(.*)$ /siteinfo/%1 [R=301,L] RewriteCond %{SCRIPT_FILENAME} !-f RewriteRule ^(.*)$ /siteinfo/$1.php [L,QSA]

Hi, I tried this but it doesn't work. Jazzman1, Lets say I have a link like www.website.com/index1.php I am very confused by what you by "Aplly fake urls and redirect them to a different (real) directory on the same project." I thought their would be a standard way to do this?

Hi, Its Apache 2.2

Hi, Does anyone have any suggestions please on how I can fix this. It appears simple but what ever I try doesn't seem to work.

Thanks, This is what Im currently using. How can I get the apache version? RewriteEngine On RewriteCond %{REQUEST_FILENAME} !-d RewriteCond %{REQUEST_FILENAME}.php -f RewriteRule ^(.*)/$ $1.php RewriteCond %{REQUEST_FILENAME}.php -f RewriteRule ^(.*)$ $1.php RewriteCond %{REQUEST_FILENAME}.html -f RewriteRule ^(.*)/$ $1.html RewriteCond %{REQUEST_FILENAME}.py -f RewriteRule ^(.*)/$ $1.py

Hi, Is there a standard method of making a link work wthout .php at the end? I have tried around 15 different options but none of them work.

Hi, I am trying to remove the .php from the end of pages. The problem I have tried around ten different options and none of them work, but how come there are so many different options? http://stackoverflow.com/questions/9821222/remove-php-extension-explicitly-written-for-friendly-url http://css-tricks.com/snippets/htaccess/remove-file-extention-from-urls/ RewriteEngine On RewriteCond %{SCRIPT_FILENAME} !-d RewriteRule ^([^\.]+)$ $1.php [NC,L]

Hi, I have managed to edit the code so that it displays a different image if someone is or is not logged in. This helps massively. I am still stuck on how make the code block someone from following themselves. <form method="post" enctype="multipart/form-data"> <?php $profileid = (int)$_GET['ID']; $followerid = intval($_SESSION['userID']); $query = mysql_query("SELECT * FROM follow WHERE user_id = '". $profileid ."' AND follow_user_id= '". $followerid ."'"); $duplicatefollow = null; if (mysql_num_rows($query) > 0) { $error['duplicatefollow'] = ''; } else { if(isset($_POST['followbutton'])) { $query = "INSERT INTO `follow` (`user_id`, `follow_user_id`) VALUES ('{$profileid}', '{$followerid}')"; $result = mysql_query($query); } } $loginprofile = intval($_SESSION['userID']); $query_rsSearch = "SELECT * FROM follow WHERE `follow_user_id` = '$loginprofile'"; $rsSearch = mysql_query($query_rsSearch) or die(mysql_error()); $row_rsSearch = mysql_fetch_assoc($rsSearch); $totalRows_rsSearch = mysql_num_rows($rsSearch); ?> <?php if ($_SESSION['userLoggedIn']) { ?> <?php $query = mysql_query("SELECT * FROM follow WHERE user_id = '". $profileid ."' AND follow_user_id= '". $followerid ."'"); $duplicatefollow = null; if (mysql_num_rows($query) > 0) { echo '<div class="followbuttonboxsuccess"><img src="/images/following.png" /></div>'; } else { echo '<div class="followbuttonbox"><input name="followbutton" CLASS="submitbutton" type="submit" /></div>'; } ?> </form> <?php ; } else { ?> <div class="followbuttonbox"><a href="/users/register.php" rel="nofollow" ><img src="/images/follow.png" /></a></div> <?php } ?>

Hi, This sounds complicated. I think I will try and hide the button for their own profile. If someone is not logged in I can also display the follow button but link it to the register page. That may be more intuitive. Thanks everyone.

Thanks, not totally sure what you mean by that. I think its actually better to hide the button, that should work better. Many thanks.

Hi, I have been trying to set up a social networking button and I have almost completed. However I have approached it from a wrong angle and have one last piece to finish. I can click the "Follow" button and it instantly swaps to "Following" button. It refreshes the page and displays that the user is now following the profile. However the code currently allows someone to follow their own profile. The problem is I dont know how to stop this. I need something which says if $profileid = $followerid dont run code. Does anyone have any suggestions please on how I an prevent this from happening. Alternatively I could hide the follow button if the user is logged in on their own profile but I am stuck on how to do this also. <?php $profileid = (int)$_GET['ID']; $followerid = intval($_SESSION['userID']); $query = mysql_query("SELECT * FROM follow WHERE user_id = '". $profileid ."' AND follow_user_id= '". $followerid ."'"); $duplicatefollow = null; if (mysql_num_rows($query) > 0) { $error['duplicatefollow'] = ''; } else { if(isset($_POST['followbutton'])) { $query = "INSERT INTO `follow` (`user_id`, `follow_user_id`) VALUES ('{$profileid}', '{$followerid}')"; $result = mysql_query($query); } } $loginprofile = intval($_SESSION['userID']); $query_rsSearch = "SELECT * FROM follow WHERE `follow_user_id` = '$loginprofile'"; $rsSearch = mysql_query($query_rsSearch) or die(mysql_error()); $row_rsSearch = mysql_fetch_assoc($rsSearch); $totalRows_rsSearch = mysql_num_rows($rsSearch); ?> <?php $query = mysql_query("SELECT * FROM follow WHERE user_id = '". $profileid ."' AND follow_user_id= '". $followerid ."'"); $duplicatefollow = null; if (mysql_num_rows($query) > 0) { echo '<div class="followbuttonboxsuccess"><img src="/images/following.png" /></div>'; } else { echo '<div class="followbuttonbox"><input name="followbutton" CLASS="submitbutton" type="submit" /></div>'; } ?>

Brilliant thanks guys, sorted this within a few minutes thanks to your help. What is the alternative to SELF?