I'm learning php in class right now, but I'm still not that good at it, what I'm
wondering is when I write the php so that it can connect with a database, can I at the same time
have it that it is able to display back images that I choose. Like, I want a search feature, where
you can search for a keyword, and it will bring back a list of all the possible entries with that
keyword, but each of these entries will have a photo associated with it. Now, do I put these image
files directly into the database, or do I write the code to link them from my files to th...

Hi all, Its Aldo. anyways, I wont be using the method of pagination, i will just tell you how to
make a basic online now script. When someone logs in, now take into consideration that the name of
the username input is username ( First ,create a table in your database saying online now and add 2
fields to it. id and username CODE id type=integer(INT) , auto increment, length =255 and
username = VARCHAR length=the limit a username should be in your site now from there we take off
: CODE //logged.php //authentication script //connection script //if connectio...

Does anyone know of a script that will tell people if an IP is online or offline? Like it will ping
it like every fifteen minutes or so and will display an online or offline image accordingly. Or at
least it supports images, text is fine I guess, but I'd rather it use images. Any help on this
will be appreciated! Thanks!...

Is there anyway to make subqueries work in MySQL? I'm pretty certain someone out there knows
how. /smile.gif' border='0' style='vertical-align:middle' alt='smile.gif' /> Can anyone help?
CODE Select * from ITEMS where ID="Select Max(ID) from ORDERS"; This works for MSAccess and
SQL Server but why not in MySQL? I'll be writing some reports and I've shifted database
from MSAccess to MySQL. Help! Thanks....

Hi, I have a column in a MySQL table which contains a counter of the views of the object described
by this table. I would like to increment this value by one everytime the object is viewed. Obviously
came into my mind the possibility of retrieving the value of this field, store it in a variable
increment this value by one and perform an UPDATE query again with this new value. My question is if
there is a MySQL option to update the field with its actual value plus an unit increment. I hope you
understand the issue....

make an index.php copy and paste this code CODE $db_host = "localhost"; $db_user = "root";
$db_pass = ""; $db_name = "test"; $dbc = mysql_connect($db_host, $db_user, $db_pass); $dbs =
mysql_select_db($db_name); $tm = time(); $timeout = $tm - (30*60); if($_SERVER ){$ip=$_SERVER ;}
else{$ip=$_SERVER ;} $brws = explode("(",$_SERVER ); $browser = $brws ; mysql_query("DELETE FROM
guest WHERE actvtime mysql_query("INSERT INTO guest SET  time='".$tm."',
ip='".$ip."', browser='".$browser."'"); $count =
mysql_fetch_array(mysql_query("SELECT COUNT(*)...

Hey, I need your help again! I need some good working tutorial how I can update my SQL through HTML
form. I did use some tutorials online found with the help of google; but they do not work properly;
I mean there are still small mistakes. I need to have a good tutorial to follow. It should be
based on security and more things. It has to be done in proper way......

Yes, yes. I have another script that I have written and I am distributing. I am not entirely sure if
this works. I have not tested it yet, but I will later and post back with a demo and fix it up.
Current script: CODE //Save this as something like htmltest.php function CheckForm() {
$html_unsafe=$_POST ; //Gives us our user input $html_safe=str_replace(" //Starts security measures
$html_safe=str_replace("?>"," ",$html_safe); //User input now secure server side //Still security
issues client side echo $html_safe; //echos our statement } //End function //Main script...

I need your feedback about setting the database issues. Please, review them and correct some entries
in the code if they got some mistakes. This is the code itself: SQL CREATE TABLE `news` (
`id` int(250) NOT NULL auto_increment, `title` varchar(255) NOT NULL default '',
`text` text NOT NULL, `author` varchar(255) NOT NULL default '', `valid` varchar(255)
NOT NULL default '', `date` varchar(255) NOT NULL default '', PRIMARY KEY
(`id`) ) ENGINE = MyISAM ; ...

Hello, everyone! I need some tools for those two things to test PHP scripts coming together with
database on my laptop, instead checking them on a web-server which takes time....

ok i need some more help from the wonderful coders here at Trap. I'm almost done with my CMS
script, but i'm having a problem with the installer.php file, when it trys to inseret the user
data into the database i keep getting the following error: CODE mySQL Error: You have an error
in your SQL syntax; check the manual that corresponds to your MySQL server version for the right
syntax to use near ';INSERT INTO `members` (`id`, `name`, `username`, `password`, `email`,
`title`) ' at line 1 the code that is being excuted by the php file is this: C...

I need many tutorials based on PHP programming language and AJAX technology. Those tutorials might
be of any kind. Please post only the links to the trusted and working tutorials!...

hi there guys, from my previous posting, i am a noob in php and mysql programming. I want to know
if there are any php and mysql editors which are best for me as a noob. i appreciate your kindness
...

hi everyone! I am making a program using php and mysql...I am a noob on this so i need your help
guys...I want to make a simple program that will some values and then store them on a database and
then retrieve them...uhmm let me give an example out put of what i need. This is the example say..:
Enter First Name: Enter Last Name:
Enter Age: Enter Address: ..those are the
data needed for input values...my question now is how can I make a database whi...

i've started to learn php..im familiar to basics of php and mysql now.Now for example i want
that some user can register to my website , and after that he can Login and log out , and he can see
his profile.is there any tutorial about this ? or any helping url .. or any helping answer please
/smile.gif" style="vertical-align:middle" emoid=":)" border="0" alt="smile.gif" />...

Hi I am trying to make a script so that i can insert songs into a playlist, but i need a script in
which it opens the playlist file and removes the closing tag at the end, so before i can add more
entrys. e.g CODE Location 5 Location 4 Location 3 Location 2 Location 1 But to
add more entrys i would have to get rid of the atx, then use the fputs to place the new entry into
the file. code tags added Topic title modified. ...

I need to look at a nice tutorial how do you create an admin access page with many functions as many
as possible....

Hello, everyone. I need your help again! Who might create the PHP code, the picture is above
this text. Basically, I want when the user fill in all the information in this form, it
automatically was sent to my email. And, then, the dialog box appears or on the same window, it was
said that your request has been sent. Moreover, if the user did not fill the entire information,
the dialog box appears stating that you did not fill some field. Thanks, for help. You always do
that....

Hi I was reminded of this earlier by a post in a topic, meant to post it but forgot and the topic on
php books reminded me. Well anyway there is tyhschools for learning php (unless someone else knows
a better 1) but I wan't to know what is the best site for using php with mysql (using
phpmyadmin) also whats the difference between postgresql and mysql? though I must admit the
postgresql version of phpmyadmin whatever it's called looks better (visually)!...

Hello, everyone. I need your help again. This forum is quite good for it. Well, I need create a
registration form for my web-site using PHP and SQL. The information it should contain: 1) User
Name 2) First Name 3) Last Name 4) Password 5) e-mail Address 6) Security Image: that images helps
to protect a random registration, for instance, 56+2=where user have to type an answer in order to
finish registration. That's all for today. Anymore things, I will post another post over here.
...

Well, I am a novice in PHP programming, so there is a script which I wanna get: 1. You go the
web-site 2. On the main screen, there is a some kind of field windows, the one you get used to type
in, when you go to google, for instance. 3. He or she types her email address and it's going to
be saved in my SQL database. 4. That's it. Help me if you can....

How I use Windows command prompt client and do modifications to my SQL database. If yes, please
write the commads I should know for that. If no, please get me the software with which I can do it.
Topic title modified. Proper English is always required when posting in our forum. ...

Hello, everyone! I need some tutorial for Slaed Engine for any version you might find. I wanna learn
how you can make modules or blocks for this CMS. Especially, library functions and other things that
will make the web-site works like virtual library....

Basically, I want to know if the Data I'm inserting through a Form is already there or not. Sort
of a Username registration page. I have this, but it doesn't appear to work... CODE
$result = mysql_query("SELECT * FROM users WHERE username='$username'"); if($result == 1)
    {     echo ' ERROR! The username you have chosen already exists!';     } ...

session_start(); include "database.php"; if (!$_SESSION || $_SESSION { // User not logged in,
redirect to login page Header("Location: main.php"); } $result = mysql_query("select * from users
order by id asc"); while($r=mysql_fetch_array($result)) { $username=$r ; $info=$r ; $msn=$r ;
$email=$r ; $id=$r ; $password=$r ; $userlevel=$r ; echo " user ID
User Level Username
Password Email: ...

QUOTE session_start(); include "database.php"; include "edit.inc.php"; if (!$_SESSION ) { //
User not logged in, redirect to login page Header("Location: main.php"); } if(isset($_POST )){
$email = $_POST ; $msn = $_POST ; $info = $_POST ; $updateemail = "UPDATE users SET email =
'$email', msn = '$msn', info = '$info' WHERE username =
'$username'"; mysql_query($updateemail) or die("culd not edit your info");
echo "info updated"; } // Display logout link echo " Click here to go back to info page! "; echo
"$email"; e...

A search engine is provided to facilitate the user with undemanding and clear-cut search options.
The search facility includes simple search, search by title, search by word/phrase, ect… Thus, the
user is at a safe distance from the risk of selecting files/folders ambiguously. In addition, a
history of recent searches can be preserved for future perusal. Now
day’s visitors have a large option for his needs on internet and so visitors are not vesting their
time by following the dead links on your site. So a search engine is essential for your...

how to get the id number of the loged in user? my db is id. username. password. i have tryed a
few things.. but i never seem to get it right /ohmy.gif" style="vertical-align:middle" emoid=":o"
border="0" alt="ohmy.gif" />...