NamePros
Welcome, Guest! Ready to make a name for yourself in the domain business? We welcome both the hobbyist and professional domainer to join the discussion as part of the NamePros community.

Click here to create your profile to start earning reputation for posting, and trader ratings for buying & selling in our free e-marketplace. Build your trader rating with each successful sale. Our system has tracked over 100,000 sales and counting!
FAQ & TOS Register Search Today's Posts Mark Forums Read

Go Back   NamePros.com > Website Development Discussion Forums > Programming
Reload this Page Need quick fix ''SQL''

Programming PHP, Perl, Ruby on Rails, AJAX, HTML, XHTML, CSS, JavaScript, MySQL and any other coding topics.

Advanced Search
6 members in live chat ~  


Reply
 
LinkBack Thread Tools
Old 05-24-2011, 01:27 PM THREAD STARTER               #1 (permalink)
Account Suspended
Join Date: Oct 2010
Posts: 105
wordtubepress is on a distinguished road
 

Need quick fix ''SQL''

ok so i made a pornstars add on for my adult site but when i fill all informations and click ''submit'' got a mesage saying Pornstar Successfuly added! Problem is there's nothing showing up

Here's the sql code

PHP Code:
CREATE TABLE IF NOT EXISTS `pornstar` (
  `PSID` bigint(20) NOT NULL auto_increment,
  `name` varchar(120) NOT NULL default '',
  `website` text NOT NULL,
  `views` int(11) NOT NULL,
  `height` text NOT NULL,
  `hair` text NOT NULL,
  `born` text NOT NULL,
  `measurements` text NOT NULL,
  `performer` text NOT NULL,
  `astrology` text NOT NULL,
  `birthplace` text NOT NULL,
  `years` text NOT NULL,
  `weight` text NOT NULL,
  `brazzers` text NOT NULL,
  `ethnic` text NOT NULL,
  `related` text NOT NULL,
  `total_videos` bigint(20) NOT NULL default '0',
  `about` text NOT NULL,
  `images` text NOT NULL,
  `rate` float NOT NULL default '0',
  `ratedby` int(11) NOT NULL default '0',
  PRIMARY KEY  (`PSID`),
  UNIQUE KEY `name` (`name`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=0 ;

ALTER TABLE  `video` ADD  `pornstar` INT( 11 ) NOT NULL AFTER  `hd` 
And here's the add.php file

PHP Code:
  <div id="rightcontent">
        {include file="errmsg.tpl"}
        <div id="right">
        <div align="center">
        <div id="simpleForm">
        <form name="add_pornstar" method="POST" enctype="multipart/form-data" action="pornstars.php?m=add">
        <fieldset>
        <legend>Add a New Pornstar</legend>
            <label for="name">Pornstar Name: </label>
            <input type="text" name="name" value="{$pornstar.name}" class="large"></span>>
            <label for="name">Performer AKA: </label>
            <input type="text" name="performer" value="{$pornstar[0].performer}" class="large"></span>>
            <label for="name">Pornstar Born: </label>
            <input type="text" name="born" value="{$pornstar[0].born}" class="large"></span>>
            <label for="name">Pornstar Astrology: </label>
????: NamePros.com http://www.namepros.com/programming/716087-need-quick-fix-sql.html
            <input type="text" name="astrology" value="{$pornstar[0].astrology}" class="large"></span>>
            <label for="name">Birthplace: </label>
            <input type="text" name="birthplace" value="{$pornstar[0].birthplace}" class="large"></span>>
            <label for="name">Years Active: </label>
            <input type="text" name="years" value="{$pornstar[0].years}" class="large"></span>>
            <label for="name">Pornstar Height: </label>
            <input type="text" name="height" value="{$pornstar[0].height}" class="large"></span>>
            <label for="name">Pornstar Weight: </label>
            <input type="text" name="weight" value="{$pornstar[0].weight}" class="large"></span>>
            <label for="name">Pornstar Hair: </label>
            <input type="text" name="hair" value="{$pornstar[0].hair}" class="large"></span>>
????: NamePros.com http://www.namepros.com/showthread.php?t=716087
            <label for="name">Pornstar Measurements: </label>
            <input type="text" name="measurements" value="{$pornstar[0].measurements}" class="large"></span>>
            <label for="name">Pornstar Ethnicity: </label>
            <input type="text" name="ethnic" value="{$pornstar[0].ethnic}" class="large"></span>>
            <label for="name">Pornstar Website: </label>
            <input type="text" name="website" value="{$pornstar[0].website}" class="large"></span>>
            <label for="name">About: </label>
            <textarea name="about" style="width:420px; height:260px;">{$pornstar[0].about}</textarea></span>>
            <input name="picture" type="file"></span>>
        </fieldset>
        <div style="text-align: center;">
            <input type="submit" name="add_pornstar" value="Add Category" class="button">
        </div>
        </form>
        </div>
        </div>
        </div>
     </div> 
Any idea what's wrong ? i don't mind spending on this if someone can fix it.
wordtubepress is offline   Reply With Quote
Old 05-24-2011, 02:25 PM   #2 (permalink)
Senior Member
 
defaultuser's Avatar
Join Date: May 2009
Location: internet@ctivist.com
Posts: 4,790
defaultuser Has achieved greatnessdefaultuser Has achieved greatnessdefaultuser Has achieved greatnessdefaultuser Has achieved greatnessdefaultuser Has achieved greatnessdefaultuser Has achieved greatnessdefaultuser Has achieved greatnessdefaultuser Has achieved greatnessdefaultuser Has achieved greatnessdefaultuser Has achieved greatnessdefaultuser Has achieved greatness
 
The SQL creates a table if it doesn't exist and alters another.

Where do you actually insert the data? Where's "pornstars.php?m=add" ?
Or am I crazy?
__________________
A Member of: IdeationTeam.com
HowToBeADomainer.com - a Domaining How To
AuthorEditor.com
defaultuser is online now   Reply With Quote
Old 05-24-2011, 08:40 PM THREAD STARTER               #3 (permalink)
Account Suspended
Join Date: Oct 2010
Posts: 105
wordtubepress is on a distinguished road
 
ok i found the file that cause the problem but i don't know why

Working file but missing some option

PHP Code:
<?php
defined('_VALID') or die('Restricted Access!');

Auth::checkAdmin();

$psimg = $config['BASE_DIR']. '/media/pornstars';
if ( !file_exists($psimg) or !is_dir($psimg) or !is_writable($psimg) ) {
    $errors[] = 'Pornstar image directory \'' .$psimg. '\' is not writable!';
}

$pornstar = array('name' => '', 'desc' => '');
if ( isset($_POST['add_pornstar']) ) {
    $name   = trim($_POST['name']);
    $about   = trim($_POST['about']);
    $website   = trim($_POST['website']);
    $height   = trim($_POST['height']);
    $hair   = trim($_POST['hair']);
    $born   = trim($_POST['born']);
    $measurements   = trim($_POST['measurements']);
    $brazzers   = trim($_POST['brazzers']);
    if ( $name == '' ) {
        $errors[] = 'Pornstar name field cannot be blank!';
    } else {
        $sql        = "SELECT PSID FROM pornstar WHERE name = '" .mysql_real_escape_string($name). "' LIMIT 1";
        $conn->execute($sql);
        if ( $conn->Affected_Rows() > 0 ) {
            $errors[]   = 'Pornstar name \'' .htmlspecialchars($name, ENT_QUOTES, 'UTF-8'). ' is already used. Please choose another name!';
        } else {
            $pornstar['name'] = $name;
            $pornstar['about'] = $about;
        }
    }
    
    if ( $_FILES['picture']['tmp_name'] == '' )
        $errors[] = 'Please provide a Pornstar image!';
    
    if ( !$errors ) {
        $sql = "INSERT INTO pornstar (name, about, website, height, hair, born, measurements, brazzers) VALUES ('" .mysql_real_escape_string($name). "','" .mysql_real_escape_string($about). "','" .mysql_real_escape_string($website). "','" .mysql_real_escape_string($height). "','" .mysql_real_escape_string($hair). "','" .mysql_real_escape_string($born). "','" .mysql_real_escape_string($measurements). "','" .mysql_real_escape_string($brazzers). "')";
        $conn->execute($sql);
        $psid = $conn->Insert_ID();
        require $config['BASE_DIR']. '/classes/image.class.php';
        $image = new VImageConv();
        $image->process($_FILES['picture']['tmp_name'], $psimg. '/' .$psid. '.jpg', 'EXACT', 200, 270);
        $image->canvas(200, 270, '000000', true);

        if ( $errors ) {
            $sql = "DELETE FROM pornstar WHERE PSID = '" .mysql_real_escape_string($psid). "' LIMIT 1";
            $conn->execute($sql);
        }
    }
    
    if ( !$errors ) {
        $msg = 'Pornstar Successfuly added!';
    VRedirect::go('pornstars.php?msg=' .$msg);
    }
}

$smarty->assign('pornstar', $pornstar);
?>
Not working modified file

PHP Code:
<?php
defined('_VALID') or die('Restricted Access!');

Auth::checkAdmin();

$psimg = $config['BASE_DIR']. '/media/pornstars';
if ( !file_exists($psimg) or !is_dir($psimg) or !is_writable($psimg) ) {
    $errors[] = 'Pornstar image directory \'' .$psimg. '\' is not writable!';
}

$pornstar = array('name' => '', 'desc' => '');
if ( isset($_POST['add_pornstar']) ) {
    $name         = trim($_POST['name']);
    $about        = trim($_POST['about']);
    $website      = trim($_POST['website']);
    $height       = trim($_POST['height']);
    $hair         = trim($_POST['hair']);
    $born         = trim($_POST['born']);
    $measurements = trim($_POST['measurements']);
    $brazzers     = trim($_POST['brazzers']);
    $performer   = trim($_POST['performer']);
    $born        = trim($_POST['born']);
    $astrology   = trim($_POST['astrology']);
    $birthplace  = trim($_POST['birthplace']);
    $years       = trim($_POST['years']);
    $weight      = trim($_POST['weight']);
    $ethnic      = trim($_POST['ethnic']);    
   if ( $name == '' ) {
        $errors[] = 'Pornstar name field cannot be blank!';
    } else {
        $sql        = "SELECT PSID FROM pornstar WHERE name = '" .mysql_real_escape_string($name). "' LIMIT 1";
        $conn->execute($sql);
        if ( $conn->Affected_Rows() > 0 ) {
            $errors[]   = 'Pornstar name \'' .htmlspecialchars($name, ENT_QUOTES, 'UTF-8'). ' is already used. Please choose another name!';
        } else {
            $pornstar['name'] = $name;
????: NamePros.com http://www.namepros.com/showthread.php?t=716087
            $pornstar['about'] = $about;
        }
    }
    
    if ( $_FILES['picture']['tmp_name'] == '' )
        $errors[] = 'Please provide a Pornstar image!';
????: NamePros.com http://www.namepros.com/showthread.php?t=716087
    
    if ( !$errors ) {
        $sql = "INSERT INTO pornstar (name, about, website, height, hair, born, measurements, brazzers, performer, born, astrology, birthplace, years, weight, ethnic) VALUES ('" .mysql_real_escape_string($name). 

"','" .mysql_real_escape_string($about). 

"','" .mysql_real_escape_string($website). 

"','" .mysql_real_escape_string($height). 

"','" .mysql_real_escape_string($hair). 

"','" .mysql_real_escape_string($born). 

"','" .mysql_real_escape_string($measurements). 

"','" .mysql_real_escape_string($brazzers).
"','" .mysql_real_escape_string($performer).
"','" .mysql_real_escape_string($born).
"','" .mysql_real_escape_string($astrology).
"','" .mysql_real_escape_string($birthplace).
"','" .mysql_real_escape_string($years).
"','" .mysql_real_escape_string($weight).
"','" .mysql_real_escape_string($etnich).







 "')";
        $conn->execute($sql);
        $psid = $conn->Insert_ID();
        require $config['BASE_DIR']. '/classes/image.class.php';
        $image = new VImageConv();
        $image->process($_FILES['picture']['tmp_name'], $psimg. '/' .$psid. '.jpg', 'EXACT', 200, 270);
        $image->canvas(200, 270, '000000', true);

        if ( $errors ) {
            $sql = "DELETE FROM pornstar WHERE PSID = '" .mysql_real_escape_string($psid). "' LIMIT 1";
            $conn->execute($sql);
        }
    }
    
    if ( !$errors ) {
        $msg = 'Pornstar Successfuly added!';
    VRedirect::go('pornstars.php?msg=' .$msg);
    }
}

$smarty->assign('pornstar', $pornstar);
?>
Last edited by wordtubepress; 05-24-2011 at 09:53 PM.
wordtubepress is offline   Reply With Quote
Old 05-24-2011, 11:54 PM   #4 (permalink)
Senior Member
 
Irieman's Avatar
Join Date: Sep 2006
Posts: 1,053
Irieman has much to be proud ofIrieman has much to be proud ofIrieman has much to be proud ofIrieman has much to be proud ofIrieman has much to be proud ofIrieman has much to be proud ofIrieman has much to be proud ofIrieman has much to be proud ofIrieman has much to be proud of
 
You have a spelling misake in your modified file, this line:

"','" .mysql_real_escape_string($etnich).

should be :

"','" .mysql_real_escape_string($ethnic).
Irieman is offline   Reply With Quote
Old 05-31-2011, 06:29 AM   #5 (permalink)
New Member
 
Thom's Avatar
Join Date: May 2011
Location: Portsmouth / London, UK
Posts: 22
Thom is on a distinguished road
 
Still need help? PHP developer with 8+ years experience. I'll fix it for free if you can give me a few hard links to some of my adult sites from yours.

Cheers,
__________________
Daddy, Husband-to-be, Web Developer.
AmateurForum.com - domain for sale
Last edited by Thom; 06-01-2011 at 07:59 PM.
Thom is offline   Reply With Quote
Old 06-27-2011, 01:19 PM   #6 (permalink)
New Member
Join Date: Sep 2010
Posts: 9
littlephoenix is an unknown quantity at this point
 
was it the spelling mistake?
__________________
my free spyware removal blog
littlephoenix is offline   Reply With Quote
Reply

« Simple jquery help! | moving x-cart db to zen-cart.. how much trouble is it? »

Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
 
Thread Tools


Similar Threads
Thread Thread Starter Forum Replies Last Post
DiscountASP.NET Launches ASP.NET 2.0 and SQL 2005 Hosting dasp Web Hosting Offers 0 11-07-2005 02:58 AM
SQL Injection Prevention axilant CODE 14 10-03-2005 12:34 PM
$ 6.95 Windows Hosting :: MS SQL, ASP.NET, Cold Fusion, Oracle, Multiple domains JodoHost Web Hosting Offers 0 03-27-2005 04:36 AM
Connecting to your SQL Database using Enterprise Manager priyanka[imported] Web Hosting Discussion 1 12-07-2004 03:21 PM
Connecting to your SQL Database using Enterprise Manager priyanka[imported] Webmaster Tutorials 0 12-06-2004 08:58 PM

 
All times are GMT -7. The time now is 02:48 PM.

Contact Us - NamePros.com - Privacy Statement - Top
Domain name forum recommended by Domaining.com Powered by: vBulletin® Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.
Search Engine Friendly URLs by vBSEO 3.6.0 Ad Management plugin by RedTyger