Jump to content

Need help with basic PHP+MYSQL

particle

By particle
in PHP Coding Help

 Share

Recommended Posts

particle Newbie

particle

Posted
Posted

Hi all. First post here :)

 

I recently started web-programming again and now I want to make an admin system for text and images to support my sites.

But I have run into some trouble... alot :P

I hope some of you can help :)

 

 

I keep getting errors like Warning: "mysql_fetch_array(): supplied argument is not a valid MySQL result resource"

and "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 '[[0]]) VALUES ( '' )' at line 1 - ID - "

 

I have tried so many things now, and I just can't see where the fault is.

 

In my MySQL DB I have:

 

DB = web***_2

table = txt

and only 2 fields: "ipid" & "fronttxt1"

 

fronttxt1 - text - No - primary - unique - index

ipid - smallint(1) -No - Auto_increment

 

 

 

This is the page code:

 

 

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">

<html xmlns="http://www.w3.org/1999/xhtml">

 

<head>

<meta content="text/html; charset=utf-8" http-equiv="Content-Type" />

<title>Admin Tools</title>

<base target="_self" />

<style type="text/css">

.style1 {

text-align: center;

font-family: "Eras Bold ITC";

color: #FFFFFF;

}

.style2 {

font-family: "Eras Bold ITC";

font-size: medium;

text-decoration: underline;

}

</style>

</head>

 

<body style="background-color: #000000">

<?php

// variables

$sqlhost = 'db.******ructures.dk';

$sqluser = 'web****';

$sqlpass = '1******';

$sqldb = 'web****_2';

$sqltxt = 'txt';

$sqlimg = 'img';

$sqlnews = 'news';

$sqladmin = 'admin';

$ftxt1 = 'fronttxt1';

$ftxt2 = 'fronttxt2';

$ftxt3 = 'fronttxt3';

$sub11 = 'sub1txt1';

$sub12 = 'sub1txt2';

$sub21 = 'sub2txt1';

$sub22 = 'sub2txt2';

$sub31 = 'sub3txt1';

$sub32 = 'sub3txt2';

$sqltxt = 'txt';

$cdb = mysql_connect("$sqlhost", "$sqluser", "$sqlpass");

// connection

mysql_connect("$sqlhost", "$sqluser", "$sqlpass");

mysql_select_db("$sqldb");

// Ask for txt data

echo "mysql_error()";

 

?>

 

<font color="FFFFFF">

 

<table align="center" style="width: 700px">

<tr>

<td>

<table align="center" style="width: 100%">

<tr>

<td class="style1" valign="top">Frontpage text 1</td>

</tr>

<tr>

<td class="style1" valign="top">

<form action="front1txt.php" method="post"><td/></form>

<?php

// ----- ID FETCH ----- //

$iddel = "DELETE ipid FROM txt";

mysql_query( $iddel );

$randid = Rand(1, 9);

$newid = "INSERT INTO txt ('ipid')  VALUES ('$randid')";

echo "mysql_error()";

echo "SQLDB - $sqldb";

?>

<?php

$gettxt = "SELECT fronttxt1 FROM txt";

// mysql_select_db('$sqldb');

 

$rettxt = mysql_query( $gettxt );

if (! $rettxt )

{

echo "mysql_error()";

}

while($rettxt = mysql_fetch_array($rettxt))

{

echo "mysql_error()";

}

?>

<form name="txtare"><textarea name="input" style="width: 700px; height: 300px"><?php echo STRIPSLASHES(TRIM(nl2br($rettxt[0]))); ?></textarea>

<tr/>

<tr>

<td class="style1" valign="top">

 

<input type="submit" style2 name="submit" style="width: 500px" type="submit" value="Save Changes" /><form/>

</td>

</tr>

</table>

</td>

</tr>

</table>

<?php

// --- Submit ----

if (isset($_POST['submit'])) {

    $sq1 = "SELECT * FROM fronttxt1";

    $txtresult = mysql_query($sq1);

echo "mysql_error()";

}

 

$txtsql = array();

$txtsql['input'] = mysql_real_escape_string($_POST['input']);

$txtsq = "INSERT INTO txt (fronttxt1[[0]]) VALUES ( '{$txtsql['input']}' )";

mysql_query($txtsq);

echo mysql_error();

echo "<h1>Your information has been entered into the database</h1>";

 

echo mysql_error();

echo " - ID - $id";

echo "<br>";

echo " - txtsq - $txtsq";

echo "<br>";

echo " -  - $";

echo "<br>";

echo "txtoutput - $txtoutput";

 

?>

 

</font>

</body>

 

</html>

Link to comment
https://forums.phpfreaks.com/topic/170431-need-help-with-basic-phpmysql/
Share on other sites
ignace Advanced Member

ignace

Posted
Posted 

$cdb = mysql_connect("$sqlhost", "$sqluser", "$sqlpass");
// connection
mysql_connect("$sqlhost", "$sqluser", "$sqlpass");

 

should be:

 

$cdb = mysql_connect($sqlhost, $sqluser, $sqlpass);

 

If you want to create an additional connection:

 

$cdb2 = mysql_connect($sqlhost, $sqluser, $sqlpass, true/*$new_link*/);

 

$iddel = "DELETE ipid FROM txt";

 

is wrong and should be:

 

$iddel = "DELETE FROM txt";

 

This will delete all rows from txt

 

echo "mysql_error()";

 

does work (because of the complex string) but should be:

 

echo mysql_error();

 

while($rettxt = mysql_fetch_array($rettxt))

holds to much (both numerical and associative) use mysql_fetch_assoc() instead

 

while($rettxt = mysql_fetch_array($rettxt))
{
echo "mysql_error()";
}

does nothing if you want to store the result, use:
$data = array();
while($rettxt = mysql_fetch_assoc($rettxt)) {
    $data[] = $rettxt;
}

 

STRIPSLASHES(TRIM(nl2br($rettxt[0])))

 

altough this works it's best to write it lowercase

 

$txtsql['input'] = mysql_real_escape_string($_POST['input']);

should be within the if (isset($_POST['submit'])) part or will throw errors otherwise

 

$txtsq = "INSERT INTO txt (fronttxt1[[0]]) VALUES ( '{$txtsql['input']}' )";

is invalid and should be:

 

$fonttxt1 = mysql_fetch_assoc($txtresult);
$txtsq = "INSERT INTO txt (fronttxt1[[0]]) VALUES ( '{$txtsql['input']}' )";

particle Newbie

particle

Posted
  • Author
Posted

WOW!!! That was freaking awsome... :D

You jusst saved my day :)

 

But not all is good...

I still can't get rid of this:

Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /usr/home/web/web****/***/front1txt.php on line 54

:facewall:

 

And

<textarea name="input" style="width: 700px; height: 300px"><?php echo striplashes(trim(nl2br($rettxt[0]))); ?></textarea>
Won't parse any info to the textarea :(
ignace Advanced Member

ignace

Posted
Posted

But not all is good...

I still can't get rid of this:

Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /usr/home/web/web****/***/front1txt.php on line 54

 

before you pass it to fetch_assoc() (not array if you only need the associative part) check the result first:

 

if ($result && mysql_num_rows($result))

 

And

<textarea name="input" style="width: 700px; height: 300px"><?php echo striplashes(trim(nl2br($rettxt[0]))); ?></textarea>
Won't parse any info to the textarea :(

 

If you are using my code then yes this fails: $rettxt[0] change 0 to the column name.

particle Newbie

particle

Posted
  • Author
Posted

hehe... I must have pasted right after I quit last night, cause it was first after several hours that I began to put other stuff in the code.

 

Yeah, I have no idea why it does like that. It's ever fetch_row and fetch_array etc...

I am starting to think that it could have something to do with my MySQL server... It's only version 3.1.2...

And also I was setting up a forum on one of my domains last night and it just kept doing strange things... So I really think there is something with my SQL server... But it's sunday and the guys at the hosting firm never work weekends :(

 

But I think I'll find some debugging tools and some way to check the connection to the server... :)

Then tomorrow I can continue the project :D

This thread is more than a year old. Please don't revive it unless you have something important to add.

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Reply to this topic...

×   Pasted as rich text.   Restore formatting

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

×
 Share
Go to topic listing
×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.