[Hello from London]

I hope to be of support or assistance to your girlfriends soon.

 

With a teflon skillet?

[Unknown column 'student_id' in 'field list']

Unknown column 'student_id' in 'field list'

 

$student_id = $_POST['st_id'];

$student_pass = $_POST['st_pass'];

$first_name = $_POST['first_name'];

$last_name = $_POST['last_name'];

$gender = $_POST['gender'];

$contact_no = $_POST['contact_no'];

$qualification= $_POST['qualification'];

$city = $_POST['city'];

$state = $_POST['state'];

$country = $_POST['country'];

$pin_code = $_POST['pin_code'];

$email1 = $_POST['email1'];

$address = $_POST['address'];

$resumename = "";

$imagename = "";

$dobdate = date("Y-m-d",strtotime($_POST['dob']));

$select_query="select student_id from student_registration where student_id = '$student_id'";

 

Error : Unknown column 'student_id' in 'field list'

 

It's thing like this that make me feel good about myself.

[PHP captcha without graphics ?]

There is no de facto fool-proof way to stop the baddies - all you can do is through enough shit in their way.

 

 

change enough to some 

[PHP captcha without graphics ?]

You're not going to get captcha without GD, sorry.

 

As a note I saw a web site one time that had a question like "What is the second word in the sentence at the top of the page?" or something like that.

 

I also had a pic of a manual captchua I did (just one) and it worked, the numbers were 4321 on a jpg with some lines through it and if you're a small site that may be all you'll need. But the question above worked very good.

[Can't get css style sheet to change when I edit on site HELP!]

Also are you sure your path to the style sheet is correct?

[How to format an echo statement to include a condition]

That works

 

Thanks

[How to format an echo statement to include a condition]

Thanks for the replys

 

This is in a loop and it works

 

$image = FALSE;
if ($board['id'] == 9) {$image = '9999999';}

echo '
</a>
</td>
<td class="info">'.$image.' '.'
<a class="subject" href="', $board['href'], '" name="b', $board['id'], '">', $board['name'], '</a>';

 

However when I take out the $image = FALSE; $image prints in all the loop's results. Why does it do that? Shouldn't $image be empty?

 

Anyway this works and I'll make a switch statement later

if ($board['id'] == 9) {$image = '9999999';} else {$image = FALSE;} and it works fine

[How to format an echo statement to include a condition]

I've been trying to format an echo statement to include a condition but I always have to split it into two or three echo  statements.

 

echo '</a>
</td>
<td class="info">
<a class="subject" href="', $board['href'], '" name="b', $board['id'], '">', $board['name'], '</a>';

 

Say I start with the above I'll then make it this

 

echo '</a>

</td>

<td class="info">';

if (this) {echo 'That';}

echo '<a class="subject" href="', $board['href'], '" name="b', $board['id'], '">', $board['name'], '</a>';

 

How can I include a condition with out extra echo's? I've tried this with and with out brackets and parenthesis and of course it doesn't work.

 

echo '</a>

</td>

<td class="info">'.{if (this) {echo 'That';} }.'

<a class="subject" href="', $board['href'], '" name="b', $board['id'], '">', $board['name'], '</a>';

 

Thanks

[Migrating to IPB]

I like smf but if it has to be it has to be. I belong to Larry Ullman's forum, link it's IPB and I haven't been there in almost a year and at the time I thought the user info and set up sucked. But I just went back and it looks clean and he's changed some things.

I don't think the pictures were there with the post topics and my profile stuff seems easy to navigate this time.

[user's password retrieval]

Reset the users password to something you know and send them that.

 

thorpe that was  really a great and simple solution though I wonder where will I get that password?

 

Sorry, didn't read your 2nd post well

 

To make a new pw I use ...  $pw = substr( md5(uniqid(rand(), true)), 3, 10);

[user's password retrieval]

Once the pw is hashed you can say it's impossible for joe average, AKA people like you and me, to get the pawword out. I know sites that can email you your password when you foregt it, not email you a new password.

 

I would guess they have another table with the password in it, I would also guess they don't put it in the members table.

[How to check whether a row is inserted into the DB?]

Because I want the system to automatically send an email to all the subsdcribers to the blog.

 

Is this something you built or is it something like wordpress?

[How to check whether a row is inserted into the DB?]

I think myqli_affected_rows($data_base_connection) for INSERT, UPDATE or DELETE

 

if (myqli_affected_rows($data_base_connection) == 1) { }

[Problems Converting WAMP Site From Localhost To Domain]

... I keep getting a lot of undefined function errors that require some code tweaks to eliminate.

 

 

This does seem odd, what kind of code tweaks? Can you give an example?

 

[Problems Converting WAMP Site From Localhost To Domain]

I am already having to change many things in my code for the working site to get it to run as localhost.

 

What are some examples of the kind of stuff you're having to change?

[Problems Converting WAMP Site From Localhost To Domain]

This may help and it's how I do it

 

// find out if url has the word local in it and if the ip matches my local ip
if (stristr($_SERVER['HTTP_HOST'], 'local') || (substr($_SERVER['HTTP_HOST'], 0,7) == '127.0.0')) {
$local = TRUE;
$home = 'http://localhost/mywebsite';
}  else {
$local = FALSE;
$home = 'http://www.mywebsite.com';
}

 

Then links are echo '<a href="$home">Home</a>'; or what ever.

 

Like ChristianF said there should be almost no difference.

 

With the above I can move files back and forth with no problem.

 

 

[How to check duplicate entry in registration form?]

What line number is the error on? Look at the line number and see what's wrong. Compare that to the input query

[login query]

... only used a 5 letter word to test

 

That doesn't matter, md5 will make the hashed pw string 32 charters long.

 

If your db table is only allowing 30 or less charactors it's cutting 2 off.

[How to check duplicate entry in registration form?]

 

$q = "SELECT id FROM users WHERE email='$e'";

$r = mysqli_query ($dbc, $q);

if (mysqli_num_rows($r) == 0) { // Available.

run insert

} else{ echo this email is taken}

 

Also and this is a big also you need to clean/secure your data before you put it in the db table.

[How to check duplicate entry in registration form?]

Before the INSERT do a SELECT that looks for one or more of something, ie an username, email, location or all or more.

[login query]

...... but still not being able to find it from the table?

 

What does this mean? How big is your table? If it is big can you use phpmyadmin to look up the username to view the hashed password to see if they match.

 

This is good but do this later, first thing first.

Not to mention, I strongly recommend reading the following article, and reading it until you understand it fully:

http://www.openwall.com/articles/PHP-Users-Passwords

[login query]

I think session_register is deprecated. Use $_SESSION['thing'] = 'thing';

 

Also why put the password in a session?

 

And what Drongo_III said.

 

Are you quite sure your password is actually stored as an MD5?

[Country specific landing page and redirecting to it based on ips]

What I'm looking for is let say if my visitor is from US the it will go to the default

 

I'd kind like to know how to do that too.

[How do you make an empty div render without nbsp or setting dimensions?]

agrd

 

Argh, I think it's argh

 

anyway back to business ...

 

... or have font tags that are the same type font as you'll be using with a line height.

 

I guess that's all BuildMyWeb and I can add to the buffet.

[How do you make an empty div render without nbsp or setting dimensions?]

Off hand I say add height or min height to the div or have font tags that are the same type font as you'll be using with a line height.