| |
| |
| |
|
Page: 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19
Comments:
<0> but i do see you got a html page up to
<1> http://cocse.skiddieleet.org/tdd.html
<1> http://cocse.skiddieleet.org/tdd.phps
<0> k
<1> go to the html one and view source
<0> i see what you did
<0> kk hold on
<0> nice
<0> skiddieleet: your awesome man
<0> lol thanks hold on let me try it
<0> now i see example i code em
<2> Mysql isn't starting and I am getting InnoDB: Your database may be corrupt. in the logs ... any ideas on how to fix?
<0> so i set the max char. on the html page correct
<1> yeah, maxlength in the <input> tag
<1> but don't depend on that
<3> guys, while on console I want to retrive some records and write them on TXT file, any idea how to do that?
<1> luckily varchar will just cut off extra chars I think
<2> How can I spit out tables that use InnoDB?
<3> I tried query -> result.txt but didn't work
<0> skiddieleet: okay here http://dewitts.biz/mysql.html, but every time i hit submit it just shows citystate put into the database
<1> can I see your mysql.php code?
<1> the form looks ok
<0> yea hold on
<0> http://pastebin.com/727782
<0> there you go skiddieleet
<1> ok, I'm opening it
<1> it's taking a while :P
<1> ok
<0> yea pastebin been having connection problems from what i read on there site lastnight
<1> the variables aren't getting set for some reason
<1> and CityState is getting inserted because you forgot your $
<1> what version of PHP?
<0> how can i find out what version of php
<0> yea i know tahts probaly a stupid ?
<0> what line did i forget my $
<1> in the query, you have CityState instead of $CityState, line 21
<1> that's why it inserted
<1> cause it was the literal string "CityState"
<0> i see
<0> hold on
<1> I remember having an issue with PHP 5 and POST stuff and it was something my php.ini
<1> register_long_arrays = on
<1> or something like that
<1> <?php
<1> phpinfo();
<1> ?>
<1> for php version
<1> and other info
<1> put a page up with that
<1> it will tell a lot of stuff
<0> k
<0> yea i know what your talking about now hold on
<0> http://dewitts.biz/phpinfo.php
<0> yea its not entering the variables cause i tried it again, but with no citystate after i entered the mone sign
<1> weird
<0> $ sign i mean
<0> yea thats what i thought to
<0> it should enter something
<4> $ is usually pronounced "string" by programmers
<4> i have no idea why
<4> at least it is here :P
<1> try this at the top, echo $_POST['Title'];
<1> to see if it's even going over
<1> maybe one of those functions is screwing it up
<4> probably some early programming languaged used it to denote a string variable :P
<0> wait skiddieleet ill try that, but go to the page http://dewitts.biz/mysql.html, and you'll notice it don't post it on the second page, but on your page it does
<0> k
<0> so put that one line 1
<0> on the php page
<0> skiddieleet: you there
<0> or do that down there where the Title = <?php echo $Title; ?><br />
<1> right under the first <?php
<1> so line 2 :P
<0> k
<0> http://dewitts.biz/mysql.html
<0> lol we got something, but not what we should of
<0> this is what the php file looks like http://pastebin.com/727794
<1> ok, I think the problem lies in mysql_real_escape_string, or htmlspecialchars
<1> try putting addslashes instead of mysql_real_escape_string
<0> do what now
<1> where you call mysql_real_escape_string
<1> change that to addslashes
<0> k
<0> lol u are da man
<0> hehe
<0> lol
<0> its showing up in the database now
<0> u da man
<0> skiddieleet: how'd you get so good at coding man
<0> u go to college?
<1> I'm not that good, and php/mysql is pretty much the only thing I did on my own
<0> lol well you are better at certain things then I am
<1> I'm taking computer science at college, and they didn't teach us any web stuff
<0> how old areyou?
<1> 21
<0> really
<0> so you in college now
<1> that's really strange, it should have at least said undefined function for mysql_real_escape_string, that's completely stripping everything from the string
<1> why the heck would it do that?
<0> now im gonna try to get the tables to view on a website
<0> yea
<0> its workin thow
<0> lol maybe its my webserver you think?
<1> not sure
<5> lawlz
<5> lawlz eric
<1> maybe try something like: echo mysql_escape_string('test');
<0> k hold on
<0> yea
<0> echo
<1> if that works I don't know what the heck it was doing
<5> if you're running mysql pre 4.3.0 that's pretty damned old
<1> that works?
<0> no but it should let me check
<0> sounds like it should
<1> hmm
<1> I meant mysql_real_escape_string
<1> why is that function name so long? :P
<5> because it replaced mysql_escape_string
<5> just like there's mysql_query and mysql_real_query
<0> yea
<0> i know what you meant
<1> what's mysql_real_query do?
<0> yea
<5> same as mysql_query but it works with binary data
<5> (this is the c api, i dunno about php)
<1> oh
<1> so if I wanted to store executables in a db, I'd use that?
<0> unexpected T_ECHO in /mysql.php on line 2
<5> or anything in a varbinary/binary/blob
<0> skiddieleet it didn't work
<1> that sounds like you did something wrong tdd1984
<1> let's see the code :P
<0> k
<1> you shouldn't get a php error with that
<5> remember tdd has no idea how to write php
<5> you have to remember taht.
<5> he is lost without you spoonfeeding.
<0> gleam: i know how to write php, but not as good as skiddieleet
<5> i bet you're missing a semicolon or you're putting echo where it doesn't belong
<5> either way, i don't believe you
<0> skiddieleet: http://pastebin.com/727798
<0> gleam: don't really care if you do or not
<2> Hmm, I have my mysql data dir with the frm files and all that stuff... and I had to rerun mysql_install_db ... and it cleared all my databases, but I still have the .frm files ... any idea how to add all the data back that is in the mysql data dir?
<0> :)
<5> if you only have the frm files and not the myd/myi files you're screwed
<5> and gleam wins
<2> gleam-: I have them all
<5> using echo where it doesn't belong
<2> How do I have mysql rescan or something ...
<5> foo, stop the server, put the old files in, start the server
Return to
#mysql
or
Go to some related
logs:
unrar-free usage
#perl
#gentoo
Tier_1
+collie +openzaurus +deactivate
azureus file associations gtk
ubuntu lexmark z615
#linux
etch install kernel-sources howto
nvidia drivers no swedish keyboard ubuntu
|
|