Hello...I'm designing a website in PHP where ppl can submit their links for "cool sites". Anyway, when somebody submit's a link to a website for example "http://www.google.com" it creates an id such as "index.php?id=1134411593". I dont want the links to be converted into id's. I want it to remain as "http://www.google.com". I have the following coding on ( echo "<a target=\"_new\" href=\"index.php?id=$data[0]\"> ). I'm a novice. Please Help!!!! Thanks... Plus I also want to add the date on when the link was submitted.
Notice from BuffaloHELP:
Please follow our forum rule by making your topic title specific to your post.
Drop the link and related information into a mysql database and use the 'row' number as its unique link number. Have one of the fields contain the actual link information for using as an address.
CODE
Row Number| URL Adress | Description | Date submitted | Submitter Name | Notes \n
Something like that. Use the Row Number as your $data[0].
echo "<a target=\"_new\" href=\"index.Php?id=$data[0]\">
Be careful, as doing things this way could lead to SQL injection attacks, as well as malicious PHP attacks on your user's.
The way that you are trying to do this, would require remote server side includes, and annon. Links.
So anyone could link a malicious file to your site, and if you didn't properly close your DB connection prior to running the include function, you could also get some pretty bad DB injection. Possibly dropping all your tables. (which could be protected with DB permissions too).
That being said. if you want to continue.
After submitting the code to the database, then retrieve it.
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 ; ....
I am quite new to PHP and this concern came to my mind after playing around a bit with it... When
PHP is not correctly configured on the web server the source code of a php file we try to access
through a browser will be shown instead of the result of the code itself. This will normally not
happen when PHP is working properly, but I was just wondering if it could still be possible to see
that code if a user wanted to or if something on the server failed. This would for example expose
sensitive information like mysql passwords and so on... Is anything like that possib....
Hey, guys... How can I build the following things. I already made the simple administrator page
where I may add some news to the web-site, but I need to make one more things described below.
Please, help me if you can. This is the way how it has to work. The process is described by two
things of the illustrations: The first picture (or brief description of the news) will be
somehow placed on the main page, the main page may have several of those things. On the first
picture, you may see that is marked by red named : "Full Descr." that I mean full descriptio....
Hi everyone! This is my first post, so be kind! Basically, I'm trying to get a free host
together so am writing some posts. Here's a little summin' summin' about malicious code
injection with PHP applications. Basically, this security exploit is one of the oldest tricks in
the books and all comes down to the fact that PHP allows execution of both local and remote scripts
with the SAME function... dur. Anyway, this is how it works. Image you've just employed a young
go getter, straight outta uni, who has found becoming a Jack of all trades a sinch. Y....
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....
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.....
Hello, everyone. The help is needed again. How can I make calculator in PHP language? That will act
like that a user just type in the fields known values, then click the button, and it's going to
be solved automatically. In other words, have can I write a formula in PHP, how to plug it inside
that language. For example, the formula to find a peremeter of square is: P=4a. So, a user
just can write the known value which is peremeter itself and it will find the side of a square; and
vice versa. If you can write many things how to do such formulas, such as comp....
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.....
hi i'm not that great at php so i'm not to sure if this will work or not. but what i want to
do is be able to use ?p=staff or what ever page name, with out the php extion, and i would like to
no if this simple script i made would work. the code is: CODE $p = $_GET ; if ( !empty($p) &&
file_exists('./' . $p . '.php') && stristr( $p, '.' ) == False ) { // pages
= directory where you store your pages $file = './' . $p . '.php'; } else { //
1.php = defult page $file = './index.php'; } include $file; ?> ....
Whenever I use 'delete from table where id = 4' from a table with several rows up to 10,
the 4th row is removed and the update simply shows the rest from 1 to 10 without 4. This is not what
I want. I want the table to now read 1 through 4 to 9 so that futher delete actions will be in that
sequence. I want to identify my row with the id (number). Can anybody help out here. Very urgent.
Serialmike.....
Well... everything is fine except the Content Select section (refer to the in-code headings)...
thats where it says the error is... could anyone find out why it wont work when I click one of my
links? http://2kart.trap17.com/progress.php for an example of what happens...
//----------------- //portfolio paths //----------------- $portfolio = "/portfolio"; $lay =
"/images"; //------------------ //navigation //------------------ $link = · Home html; $link
= · Portfolio html; $link = · Programming html; $link = · Graphics html; $link
= ....
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....
Hello! I have just came up with a sweet script to show the source code of any website and it only
requires one file. This is the basis of the script and can be customized with CSS and other things
and can be instituted as a public resource. Well I will provide the code and a step-by-step tutorial
on each of its parts. This code has been tested by me. Enjoy! CODE //This little tag starts
our php script and is easily the most important part of the script. //We will start our base script
here. //You can change some of the styles used here to your desired color. if (....
I want to add a feature in my website so that users can make a professional -looking resume-like web
page. It will be like a form based series of questions that visitor ll need to answer.Based on this
a webpage as prescribed in pre-defined template ll be created .I want to know to do this what
languages are used? I want some suggestion regarding this.My site is currently on Joomla platform.
thanks in advance....
Hi all..(if this is in bad section then sorry) I have one big problem with my site and I don't
know how I can repair it. I have auto refreshed Shout box at site but there is little problem! When
this shout box is accessed for guest there are coming spam bots and just spamming it. I know how to
do it but I don't know about php. I have code for make this shout box Spam protected, but I dont
know how to do it. All time when I add this code to php file, there is all things okey but auto
refresh is not working /sad.gif" style="vertical-align:middle" emoid=":(" border....
CODE require('connection2.php'); $select=mysql_query("SELECT * from `users` WHERE
password='$_GET '"); $co=mysql_num_rows($select); if ($co = 1) { session_start();
$s=session_id(); $_SESSION ="yes"; $username=$_GET ; header("location:../main/index2.php?a=$_GET
&s=$s"); //echo " Proceed to Game "; //echo $s; } Now that is a bit of my script for my
login script to authenticate and stuff. Recently my game went down because there was some error in
this. So i kept on trying and it didnt work. Now i found out, wait first let me tell you th....
Hi i'm dan from new zealand, right next to my home land australia. I have been writing php
scripts for two years now and just recently none of them have been working. Please help me out as
best as you can, i'm sure it is only something simple. CODE ----------------Form
1-------------------------- // ---- Customized form script for the HBRC--------------- //
Receiving variables ----------------------------------- @$fn = addslashes($_POST ); @$ln =
addslashes($_POST ); @$f1 = addslashes($_POST ); @$f2 = addslashes($_POST ); @$f3 =
addslashes($_POST ); //--....
Hey all. Now i have a DB, an SQL DB, and i need to auto prune the data there to delete rows lder
than a certain time, lets say 2 months for now, the question is how do i do this? The obvious thing
is just to add a field which is the numerical representation of the month when the data is entered
and every time the DB is accessed it will check this number against the current month,in a numerical
format, and if the difference is two or greater that row is deleted, so if the month is January, it
would be O1 and if the current month is march then it would be O3 and the diff....
Use this code to display the current date and time. CODE $date = date('l dS \of F Y
h:i:s A'); echo "$date"; ?> "l" would display the current day of the week such as
Sunday. d displays the day of the month... such as 1 and S adds the appropriate suffix(st). /of
simply displays the word "of". F displays the current month with no abbreviations while Y displays
the four digit year(2007). "h" displays the current hour with leading zeros if necessary(Ex. 06 for
6 o'clock). "i" displays the minute of the hour with leading zeros if necessary. ....
This is a source code viewer that will workl on wap/mobile sites but you can easily convert it to
work on web im sure ;-) CODE header("Content-Type: text/vnd.wap.wml"); echo '
'; print " "; if ($url == "") { echo " Enter url: »View source code "; }
if ($url == "$url") { $udata=@file_get_contents("$url"); $udata = str_replace("$","$$",$udata);
$udata = str_replace("&","&",$udata); $udata = str_replace("'","'",$udata); $udata =
str_replace(" $udata = str_replace(">",">",$udata); $udata = str_replace("\"....
In search of dynamically changing quote, saying or all other types of text on an image I came across
a code that I have modified to fit my initial usage. This procedure requires two files and short
knowledge of PHP. If you are familiar with Trap17's sig rotation code you will understand this
procedure very fast. Code 1: dynamic_sig.php (you can rename this to index.php and you'll see
at the end why) Code 2: a simple text file named anything (I will call it name.txt ) Code 1
CODE header("Content-type: image/png"); $image = imagecreatefrompng("../i....
QUOTE how can get this html code to work on my phpnuke site? what tags would i
have to enable in the $Allowable HTML part of my config.php file?? Edited topic title. Moved to
Programming. ....
hi, Can we reset the id auto increment in the mysql database using by phpMyadmin? let's say the
shoutbox . the id #number table.. somehow i deleted some rows.. and i wanted to re-order/reset the
id number acendingly in order rather than skip out.. thks ....
As everyone know, there two ways (that I can think of) to change files' and directories'
permissions. One is to change it in your cPanel's Disk Manager and the other is with an FTP
client that supports chmod. Well, I'm doing something for my site that requires files to have
full permissions (Execute, Write, and Read on all three groups). At first, I thought that if I made
the directory 777, then every file created in that directory will be 777 as well. I'm wrong. An
alternative to doing this is to change each file permission myself, but that would be....
Hey /smile.gif' border='0' style='vertical-align:middle' alt='smile.gif' /> I want to know how
to get the filename of the referring URL. Look at the following example: Page A which has a URL of
http://blah.trap17.com/blah/blah1.php redirects the user to Page B which has a URL of
http://blah.trap17.com/blah/blah2.php . Is there a PHP code that I can put on blah2.php that will
output blah1.php? I tried _SERVER ; (please note the code may not exactly be correct as I do not
remember the code /laugh.gif' border='0' style='vertical-align:middle' alt='laugh.gif' />....
We know that php is a server side scripting language. So we will need a server with the php parser
to parse/test our code. How are you doing that. Do you upload it to a server for testing or did you
instal php and the server (apache) on your computer (localhost)....
