|
PHP - Warning Message Regarding
The following piece of POST header details to output to a file in JSON format returns the following error:
[/code]$params = array("user" => $enjin_id);
$query = http_build_query($params); $contextData = array("method" => "POST", "header" => "Connection: close\r\n" . "Content-Length: " . strlen($query)."\r\n", "content" => $query ); $context = stream_context_create(array ( "http" => $contextData )); $result = file_get_contents($url, FALSE, $context);[/code] error: file_get_contents(): Content-type not specified assuming application/x-www-form-urlencodedCan anyone advise what I need to do to ensure that the process is correctly set, of which I assume I need to declare a MIME type and where it is needed? Similar TutorialsI hope this is enough info, but I have this code (at the bottom) that grabs images from my S3 account (Amazon Web Services)... If there is no bucket for the name given, it gives this warning... Code: [Select] Warning: S3::getBucket(): [NoSuchBucket] The specified bucket does not exist in /home/xxxxxxx/public_html/xxxxxxx.com/S3.php on line 126 Assuming it's not specific syntax to S3 and is general PHP syntax, how could I prevent that warning from showing, by saying in plain English "If a bucket by that name doesn't exist, I'm gonna do something else and NOT spit out this warning?" Basically, I want to echo a message like "There is no bucket yet" instead of having that ugly warning. Code: [Select] // Get the contents of our bucket $contents = $s3->getBucket("mybucket"); foreach ($contents as $file){ $fname = $file['name']; $furl = "http://mybucket.s3.amazonaws.com/".$fname; //output a link to the file echo "<a href=\"$furl\">$fname</a><br />"; echo "<img src='$furl' width='50' /><br />"; echo "$furl<br />"; } i'm using a dropdown menu to add data to URL in order to run a separate query command depending on result.
url comes in as: index.php?role=ceo
i have the following form:
<form action="<?php $_SERVER['PHP_SELF'] ?>" method="GET" > <select name="role"> <option value="all">ALL</option> <option value="ceo">CEO</option> <option value="coceo">Co-Ceo</option> <option value="director">Director</option> <option value="pos">POS Manager</option> <option value="member">Member</option> </select> <input type="submit" value="Filter Results" /> </form>and the following set of if commands;
<?php
//Check if it echo role (IT DOES!!)
echo $role;
// Perform the SQL query
//if role is set then add WHERE clause to filter to specific role
if (isset($_GET['role'])) {
$results = mysql_query('SELECT * FROM `ecmt_memberlist` WHERE role = '. $_GET['role'].' ORDER BY CONCAT(MainToon, Name)');
}
//if no role set in url return ALL results!
else {
$results = mysql_query('SELECT * FROM `ecmt_memberlist` ORDER BY CONCAT(MainToon, Name)');
}
$results_array = array();
while ($row = mysql_fetch_array($results)) {
$results_array[$row['characterID']] = $row;
}
?>
Hi All, I just formatted my HD and had a WAMP setup. I have not installed each component separately (newest versions). When I type in a text box and press the submit button, I get: Warning: Cannot modify header information - headers already sent by (output started at D:\Web\Apache\htdocs\projects\tms_new\functions\functions.js:304) in D:\Web\Apache\htdocs\projects\tms_new\apps\index.php on line 167 Line 304 in the functions.js file is: </script> Line 167 in index.php is: header('Location: index.php?lastname='.stripslashes($lastname)); It says I am sending header information before line 167, but there isn't any. The .JS file only has JS code. Can someone give me any suggestions? Thanks everyone!! Hi Everyone I am having a few issues with my website. I have developed in on my xampp local host and it works ok but when I upload the files and try to renew a membership using stripe I get the following messages. Warning: session_start(): Cannot start session when headers already sent in /customers/a/d/f/mywebsite.co.uk/httpd.www/mywebsite/inc/settings.php on line 2 Warning: Cannot modify header information - headers already sent by (output started at /customers/a/d/f/mywebsite.co.uk/httpd.www/mywebsite/procedures/payments/charge.php:1) in /customers/a/d/f/mywebsite.co.uk/httpd.www/mywebsite/procedures/payments/charge.php on line 141 I have some includes that appear on every page. This is the bootstrap.php file. This file holds the settings.php which connects to my database and other function files. In this settings page I call the session_start() php function and then connect to my database. I call the bootstrap.php file on every page to there for call the session_start() on every page. I am using sessions alot so is this the right thing to do? I have attached the renew_membership payment page which holds the form. The user fills out the payment page and the form data gets sent to a script called charge.php which uses the stripe objects to make the payment. I then want to do a redirect to the paymentSuccess.php page to output to the user that the payment was made successfully. This is where the issues arrise. I have split the charge file into 3 screen shots so it is more readable. Hope someone can help me. Thanks a lot David
Edited April 26 by Irish_Dave I am running to an issue that I have never delt with before and am not sure if there is even a possible solution: I have two files: fileA and fileB fileA contains a loop that loops 30 times each time its called. in the loop there is a 2second delay $i = 1; do { $i++; sleep(2); if(!isset($_SESSION['user']) { break; } } while($i < 31); if fileB i have a simple destroy session $_SESSION = array(); session_destroy(); I call both files via ajax, and that is where i run into my problem. if I call fileA first, then call fileB through ajax, the code in FileB does not execute until fileA has run its course. Is it possible to get around this? Like set the priority of one over the other?
<?php
if(isset($_POST['submit'])){
$name = $_POST['name'];
}
?>
<form method="POST" action="hist1.php">
<br />
<input type="hidden" name="name" value="<?php echo $name ?>" />
<?php
$q = mysql_query("SELECT * FROM histact1 ORDER BY RAND() LIMIT 1");
while ($r1 = mysql_fetch_array($q)){
$id = $r1[0];
$question1 = $r1[1];
$opt1 = $r1[3];
$opt2 = $r1[4];
$opt3 = $r1[5];
?>
<div class="Qset" id="q1"><br /><br />
<label class="items">1st Question :</label> <br />
<center>
<textarea class="textareaQ" name="question1" readonly><?php echo $question1; ?></textarea>
</center>
<br /><br />
<p class="marA">
<input type="radio" name="rad1" value="<?php echo $opt1; ?>" />
<label class="lbl"><?php echo $opt1 ?></label><br />
<input type="radio" name="rad1" value="<?php echo $opt2; ?>" />
<label class="lbl"><?php echo $opt2 ?></label><br />
<input type="radio" name="rad1" value="<?php echo $opt3; ?>" />
<label class="lbl"><?php echo $opt3 ?></label><br />
</p>
</div>
<div class="lr">
<center>
<br /><br /><br /><br />
<a class="nxt" href="#q2"><label title="Proceed to 2nd Question">Next</label></a>
</center>
</div>
<br /><br /><br />
<center><hr width="90%" /></center><br />
<?php } ?>
<br /><br />
<?php
$q = mysql_query("SELECT * FROM histact1 ORDER BY RAND() LIMIT 1");
while ($r1 = mysql_fetch_array($q)){
$id = $r1[0];
$question2 = $r1[1];
$opt1 = $r1[3];
$opt2 = $r1[4];
$opt3 = $r1[5];
?>
<div class="Qset" id="q2"><br /><br />
<label class="items">2nd Question :</label> <br />
<center>
<textarea class="textareaQ" name="q2" readonly><?php echo $question2; ?></textarea>
</center>
<br /><br />
<p class="marA">
<input type="radio" name="rad2" value="<?php echo $opt1; ?>" />
<label class="lbl"><?php echo $opt1 ?></label><br />
<input type="radio" name="rad2" value="<?php echo $opt2; ?>" />
<label class="lbl"><?php echo $opt2 ?></label><br />
<input type="radio" name="rad2" value="<?php echo $opt3; ?>" />
<label class="lbl"><?php echo $opt3 ?></label><br />
</p>
</div>
<div class="lr">
<center>
<br /><br /><br /><br />
<a class="nxt" href="#q1"><label title="Proceed to 1st Question">Back</label></a> |
<a class="nxt" href="#q3"><label title="Proceed to 3rd Question">Next</label></a>
</center>
</div>
<br /><br /><br />
<center><hr width="90%" /></center><br />
<?php } ?>
<br /><br />
<?php
$q = mysql_query("SELECT * FROM histact1 ORDER BY RAND() LIMIT 1");
while ($r1 = mysql_fetch_array($q)){
$id = $r1[0];
$question3 = $r1[1];
$opt1 = $r1[3];
$opt2 = $r1[4];
$opt3 = $r1[5];
?>
<div class="Qset" id="q3"><br /><br />
<label class="items">3rd Question :</label> <br />
<center>
<textarea class="textareaQ" name="q3" readonly><?php echo $question3; ?></textarea>
</center>
<br /><br />
<p class="marA">
<input type="radio" name="rad3" value="<?php echo $opt1; ?>" />
<label class="lbl"><?php echo $opt1 ?></label><br />
<input type="radio" name="rad3" value="<?php echo $opt2; ?>" />
<label class="lbl"><?php echo $opt2 ?></label><br />
<input type="radio" name="rad3" value="<?php echo $opt3; ?>" />
<label class="lbl"><?php echo $opt3 ?></label><br />
</p>
</div>
<div class="lr">
<center>
<br /><br /><br /><br />
<a class="nxt" href="#q2"><label title="Proceed to 2nd Question">Back</label></a> |
<a class="nxt" href="#q4"><label title="Proceed to 4th Question">Next</label></a>
</center>
</div>
<br /><br /><br />
<center><hr width="90%" /></center><br />
<?php } ?>
<br /><br />
<?php
$q = mysql_query("SELECT * FROM histact1 ORDER BY RAND() LIMIT 1");
while ($r1 = mysql_fetch_array($q)){
$id = $r1[0];
$question4 = $r1[1];
$opt1 = $r1[3];
$opt2 = $r1[4];
$opt3 = $r1[5];
?>
<div class="Qset" id="q4"><br /><br />
<label class="items">4th Question :</label> <br />
<center>
<textarea class="textareaQ" name="q4" readonly><?php echo $question4; ?></textarea>
</center>
<br /><br />
<p class="marA">
<input type="radio" name="rad4" value="<?php echo $opt1; ?>" />
<label class="lbl"><?php echo $opt1 ?></label><br />
<input type="radio" name="rad4" value="<?php echo $opt2; ?>" />
<label class="lbl"><?php echo $opt2 ?></label><br />
<input type="radio" name="rad4" value="<?php echo $opt3; ?>" />
<label class="lbl"><?php echo $opt3 ?></label><br />
</p>
</div>
<div class="lr">
<center>
<br /><br /><br /><br />
<a class="nxt" href="#q3"><label title="Proceed to 3rd Question">Back</label></a> |
<a class="nxt" href="#q5"><label title="Proceed to 5th Question">Next</label></a>
</center>
</div>
<br /><br /><br />
<center><hr width="90%" /></center><br />
<?php } ?>
<br /><br />
<?php
$q = mysql_query("SELECT * FROM histact1 WHERE question != '$question1' AND question != '$question2' AND question != '$question3' AND question != '$question4' ORDER BY RAND() LIMIT 1");
while ($r1 = mysql_fetch_array($q)){
$id = $r1[0];
$question5 = $r1[1];
$opt1 = $r1[3];
$opt2 = $r1[4];
$opt3 = $r1[5];
?>
<div class="Qset" id="q5"><br /><br />
<label class="items">5th Question :</label> <br />
<center>
<textarea class="textareaQ" name="q5" readonly><?php echo $question5; ?></textarea>
</center>
<br /><br />
<p class="marA">
<input type="radio" name="rad5" value="<?php echo $opt1; ?>" />
<label class="lbl"><?php echo $opt1 ?></label><br />
<input type="radio" name="rad5" value="<?php echo $opt2; ?>" />
<label class="lbl"><?php echo $opt2 ?></label><br />
<input type="radio" name="rad5" value="<?php echo $opt3; ?>" />
<label class="lbl"><?php echo $opt3 ?></label><br />
</p>
</div>
<div class="lr">
<center>
<br /><br /><br /><br />
<a class="nxt" href="#q4"><label title="Proceed to 4th Question">Back</label></a> |
<input type="submit" title="Submit Answers" name="submit" class="submit" value=" Submit " onclick="return confirm('Are you sure you want to submit your answers?\nYou can review your answer by click the Back link')" />
</center>
</div>
<br /><br /><br />
<center><hr width="90%" /></center><br />
<?php } ?>
</form>
Edited by mac_gyver, 09 October 2014 - 10:51 AM. code in code tags please So I am tryting to create a script to upload a CSV file into a MySql DB. It has like 10K records into SQL
My Code is copy below ...
I get the following errors.
Line 16 is the $handle
line 18 is the While Statement
Error:
Warning: fopen(): Filename cannot be empty in C:\local\htdocs\ADPStorage\DemandCSV.php on line 16 Warning: fopen()expects parameter 1 to be resource, boolean given in C:\local\htdocs\ADPStorage\DemandCSV.php on line 18 I use my script for another table and it worked like a charm. Less data and less colums do. Bad Code: (good Code sample below. this one)
<?php
$today = date("m.d.y.h.m.s");
echo $today;
$BPTD_fy = '2014';
$BPTD_updatedate = $today;
$conn = mysql_connect("Localhost","root","password") or die (mysql_error());
mysql_select_db("ds_storage",$conn);
if(isset($_POST['submit']))
{
$file = $_FILES['file']['tmp_name'];
$handle = fopen($file, "r");
while(($fileop = fgetcsv($handle, 100000, ",")) !==FALSE)
{
$BPTD_fy = $fileop[0];
$BPTD_Status = $fileop[1];
$BPTD_Classification = $fileop[2];
$BPTD_ProcureCat = $fileop[3];
$BPTD_Product = $fileop[4];
$BPTD_Project = $fileop[5];
$BPTD_DSCategory = $fileop[6];
$BPTD_Calculated = $fileop[7];
$BPTD_CapacityType = $fileop[8];
$BPTD_Amount = $fileop[9];
$BPTD_Jul = $fileop[10];
$BPTD_Aug = $fileop[11];
$BPTD_Sep = $fileop[12];
$BPTD_Oct = $fileop[13];
$BPTD_Nov = $fileop[14];
$BPTD_Dec = $fileop[15];
$BPTD_Jan = $fileop[16];
$BPTD_Feb = $fileop[17];
$BPTD_Mar = $fileop[18];
$BPTD_Apr = $fileop[19];
$BPTD_May = $fileop[20];
$BPTD_Jun = $fileop[21];
$BPTD_Location = $fileop[22];
$BPTD_Env = $fileop[23];
$BPTD_Requester = $fileop[24];
$BPTD_ServiceArea = $fileop[25];
$BPTD_ServiceGroup = $fileop[26];
$BPTD_DepHead = $fileop[27];
$BPTD_Recgroup = $fileop[28];
$BPTD_RecOwner = $fileop[29];
$BPTD_Entrydate = $fileop[30];
$BPTD_updatedate = $fileop[31];
$sql = mysql_query("INSERT INTO inv_bpt_demand (Status, Classification, ProcureCat, Product, Project, DSCategory, Calculated, CapacityType, Amount, Jul, Aug, Sep, Oct, Nov, Dec,
Jan, Feb, Mar, Apr, May, Jun, Location, Env, Requester, ServiceArea, ServiceGroup, DepHead, Recgroup, RecOwner, Entrydate, updatedate)
VALUES ('$BPTD_Status', '$BPTD_Classification', '$BPTD_ProcureCat', '$BPTD_Product', '$BPTD_Project', '$BPTD_DSCategory', '$BPTD_Calculated', '$BPTD_CapacityType', '$BPTD_Amount',
'$BPTD_Jul', '$BPTD_Aug', '$BPTD_Sep', '$BPTD_Oct', '$BPTD_Nov', '$BPTD_Dec', '$BPTD_Jan', '$BPTD_Feb', '$BPTD_Mar', '$BPTD_Apr','$BPTD_May', '$BPTD_Jun','$BPTD_Location',
'$BPTD_Env','$BPTD_Requester', '$BPTD_ServiceArea', '$BPTD_ServiceGroup','$BPTD_DepHead', '$BPTD_Recgroup','$BPTD_RecOwner','$BPTD_Entrydate','$BPTD_updatedate')");
if($sql)
{
echo 'Data Uploaded Successfully';
}
}
}
?>
<!DOCTYPE html>
<html lang="en">
<head>
<meta charset="utf-8">
<title>BPT Demand CSV</title>
<link rel="stylesheet" type="text/css" href="file:///C|/local/htdocs/style/style.css" />
<script type="text/javascript" src="//ajax.googleapis.com/ajax/libs/jquery/1.3.2/jquery.min.js"></script>
</head>
<body>
<div id="mainWrapper">
<form method="post" action="https://localhost/Storage/DemandCSV.php" enctype="multipart/form-data">
<input type="file" name="file" />
<br />
<input type="submit" name="submit" value="Submit" />
</form>
</div><!--end mainWrapper-->
</body>
</html>
Similar Working code (good)
<?php
$conn = mysql_connect("Localhost","root","password") or die (mysql_error());
mysql_select_db("ds_storage",$conn);
if(isset($_POST['submit']))
{
$file = $_FILES['file']['tmp_name'];
$handle = fopen($file, "r");
while(($fileop = fgetcsv($handle,1000,",")) !==FALSE)
{
$PC_Num = $fileop[0];
$PC_Name = $fileop[1];
$PC_BPTNUM = $fileop[2];
$PC_busclass = $fileop[3];
$PC_Note = $fileop[4];
$PC_Acro = $fileop[5];
$PC_type = $fileop[6];
///echo $fileop[1];
$sql = mysql_query("INSERT INTO inv_names (PC_Num, PC_Name, PC_BPTNUM, PC_busclass, PC_Note, PC_Acro, PC_type)
VALUES ('$PC_Num', '$PC_Name', '$PC_BPTNUM', '$PC_busclass', '$PC_Note', '$PC_Acro', '$PC_type')");
if($sql)
{
echo 'Data Uploaded Successfully';
}
}
}
?>
<!DOCTYPE html>
<html lang="en">
<head>
<meta charset="utf-8">
<title>Upload CSV</title>
<link rel="stylesheet" type="text/css" href="file:///C|/local/htdocs/style/style.css" />
<script type="text/javascript" src="//ajax.googleapis.com/ajax/libs/jquery/1.3.2/jquery.min.js"></script>
</head>
<body>
<div id="mainWrapper">
<form method="post" action="https://localhost/Storage/Storage_CSV.php" enctype="multipart/form-data">
<input type="file" name="file" />
<br />
<input type="submit" name="submit" value="Submit" />
</form>
</div><!--end mainWrapper-->
</body>
</html>
Please help and thx in advance
~J
Hey everyone, I have created a simple framework script and Im getting this error inserted into my error_log file in the root folder: Quote [31-Oct-2010 13:14:59] PHP Warning: PHP Startup: Unable to load dynamic library '/usr/local/lib/php/extensions/no-debug-non-zts-20060613/' - /usr/local/lib/php/extensions/no-debug-non-zts-20060613/: cannot read file data: Is a directory in Unknown on line 0 Any ideas guys?? I am trying to output only 40 of the latest files uploaded on the database server. But when I am trying to see the files uploaded on the server I am getting this error: Warning: round() expects parameter 2 to be long, string given in C:\wamp\www\mshare\lista.php on line 8 Call Stack The code: Code: [Select] <?php function bytestostring($size, $precision = 0) { $sizes = array('YB', 'ZB', 'EB', 'PB', 'TB', 'GB', 'MB', 'kB', 'B'); $total = count($sizes); while($total-- && $size > 1024) $size /= 1024; return round($size, $precision)." ".$sizes[$total]; } echo '<div class="header">40 last uploaded files:</div>'; $sql = "SELECT * FROM filer order by id desc limit 40"; $q = mysql_query($sql); echo '<table style="width: 100%;">'; while ($r = mysql_fetch_array($q)) { $i++; $id = $r['id']; $filnamn = $r['name']; $filtyp = explode("/", $r['type']); $filtyp = ucwords($filtyp[0]); if($filtyp == "") { $filtyp = "Unkown"; } $filstorlek = bytestostring($r['size'], ""); $a = $i%2; echo'<tr><td class="lista">'; echo ''.$i.'. <td class="lista">'.$filnamn.'<td class="lista">'.$filtyp.' <td class="lista">'.$filstorlek.' <td class="lista"><a href="download.php?id='.$id.'"'.$a.'"><img src="download-icon.jpg" class="imagedow"></a>'; } echo "</table>"; ?> I am new to PHP coding so you guys just know. Quote Warning: mysql_connect() [function.mysql-connect]: Access denied for user 'nyhungry_builder'@'localhost' (using password: YES) in /home3/nyhungry/public_html/musicmakerstore/storescript/connect_to_mysql.php on line 19 could not connect to mysql I am getting this error from the code below how come? Code: [Select] <! <?php // Place db host name. Sometimes "localhost" but // sometimes looks like this: >> ???mysql??.someserver.net $db_host = "localhost"; // Place the username for the MySQL database here $db_username = "nyhungry_builder"; // Place the password for the MySQL database here $db_pass = "blablabla"; // Place the name for the MySQL database here $db_name = "nyhungry_musicbeatmaker"; // Run the actual connection here mysql_connect("$db_host","$db_username","$db_pass") or die ("could not connect to mysql"); mysql_select_db("$db_name") or die ("no database"); ?> I am working on a cpanel kind of host and you know how the databases are setup like blablab_databasename etc.. What is going on here i have check the database name, the table, password and the host thousands of times and nothing.. Help Hi I post this thread under php, because I guess that my coding is wrong. I always get the following message Quote Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /home/content/g/w/o/gwolff2005/html/admin/update.php on line 23 Update data in mysql The code is Code: [Select] <!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"> <?php $host="xxxx"; // Host name $username="xxxx"; // Mysql username $password="xxxxx; // Mysql password $db_name="xxxxx"; // Database name $tbl_name="sp_users"; // Table name // Connect to server and select database. mysql_connect("$host", "$username", "$password")or die("cannot connect"); mysql_select_db("$db_name")or die("cannot select DB"); // get value of id that sent from address bar $id=$_GET['user_id']; // Retrieve data from database $sql="SELECT * FROM '$sp_users' WHERE id='$user_id'"; $result=mysql_query($sql); $result=mysql_query("select * from '$sp_users' WHERE id='$user_id'"); $rows = mysql_fetch_array($result); ?> <table width="400" border="0" cellspacing="1" cellpadding="0"> <tr> <form name="form1" method="post" action="update_ac.php"> <td> <table width="100%" border="0" cellspacing="1" cellpadding="0"> <tr> <td> </td> <td colspan="3"><div align="center" class="style1">Update data in mysql </div></td> </tr> <tr> <td align="center"> </td> <td align="center"> </td> <td align="center"> </td> <td align="center"> </td> </tr> <tr> <td align="center"> </td> <td align="center"><span class="style7">Name</span></td> <td align="center"><span class="style7">Lastname</span></td> <td align="center"><span class="style7">Email</span></td> </tr> <tr> <td> </td> <td align="center"><input name="name" type="text" id="name" value="<? echo $rows['user_first_name']; ?>"></td> <td align="center"><input name="lastname" type="text" id="lastname" value="<? echo $rows['user_surname']; ?>" size="15"></td> <td><input name="email" type="text" id="email" value="<? echo $rows['user_login']; ?>" size="15"></td> </tr> <tr> <td> </td> <td><input name="id" type="hidden" id="id" value="<? echo $rows['user_id']; ?>"></td> <td align="center"><input type="submit" name="Submit" value="Submit"></td> <td> </td> </tr> </table> </td> </form> </tr> </table> <? // close connection mysql_close(); ?> </body> </html>What am I doing wrong. Thanks for your help! Hi, I'm trying to combine and sort two tables so I can display the output as one. And I'm getting the error "PHP Warning: array_multisort() [<a href='function.array-multisort'>function.array-multisort</a>]: Array sizes are inconsistent in ... on line 282". Line 282 is "array_multisort($tmp_name, SORT_ASC, $details);". I'm a self taught beginner coder and I know that my coding is often very clumsy and so that is probably the problem. Any help to solve this error would be greatly appreciated. Cheers $sql = "SELECT * FROM db_user LEFT JOIN db_details ON db_details.details_id = db_user.user_details_id WHERE db_user.user_id = '" . $user_id . "'"; $result = mysql_query($sql); $num = mysql_num_rows($result); if ($num != NULL) { for ($i = 0; $i < $num; $i++) { $user_group_id = mysql_result($result, $i, "db_user.user_group_id"); $details_id = mysql_result($result, $i, "db_details.details_id"); $details_name = mysql_result($result, $i, "db_details.details_name"); $details[] = array($details_id, $details_name, $user_group_id); } } $sql = "SELECT * FROM db_members LEFT JOIN db_details ON db_details.details_id = db_members.members_details_id WHERE db_members.members_user_id = '" . $user_id . "'"; $result = mysql_query($sql); $num = mysql_num_rows($result); if ($num != NULL) { for ($i = 0; $i < $num; $i++) { $members_group_id = mysql_result($result, $i, "db_members.members_group_id"); $details_id = mysql_result($result, $i, "db_details.details_id"); $details_name = mysql_result($result, $i, "db_details.details_name"); $details[] = array($details_id, $details_name, $members_group_id); } } foreach ($details as $key => $val) { $tmp_name[$key] = $val[1]; } array_multisort($tmp_name, SORT_ASC, $details); hello i keep getting the Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /home/cookbook/public_html/forum/index.php on line 26 for my code <?php session_start(); include_once "../scripts/connect_to_mysql.php"; // Connect to the database $sql = mysql_query("SELECT * FROM forum_sections ORDER BY ordered ASC LIMIT 10"); $displayList = ""; // Initialize the display variable here while($row = mysql_fetch_array($sql)){ $sectionID = $row["id"]; $sectionTitle = $row["title"]; $displayList .= '<br /><a href="section.php?id=' . $sectionID . '"><img src="style/sectionPic.jpg" width="61" height="23" alt="Section" /> ' . $sectionTitle . '</a><br /><hr />'; } ?> <!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 http-equiv="Content-Type" content="text/html; charset=utf-8" /> <link href="style/style.css" rel="stylesheet" type="text/css" /> <title>Web Intersect Forum</title> </head> <body> <?php include_once("template_header.php"); ?> <table style="background-color: #F0F0F0; border:#069 1px solid; border-top:none;" width="900" border="0" align="center" cellpadding="12" cellspacing="0"> <tr> <td width="731" valign="top"> <div id="breadcrumbs"><a href="http://www.webintersect.com">Web Intersect Home</a></div> <div id="sectionLinks"><ul><?php echo $displayList; ?></ul></div></td> <td width="189" valign="top"><div style=" width:160px; height:600px; background-color: #999; color: #CCC; padding:12px;"> <br /><br /><br /> <h3>Ad Space or Whatever</h3> </div></td> </tr> </table> <?php include_once("template_footer.php"); ?> </body> </html> can anyone please tell me why i get this? Hi im getting the following error message in my admin area: Code: [Select] Warning: session_start() [function.session-start]: open(/home/users/web/b109/ipg.removalspacecom/cgi-bin/tmp/sess_9b495d20f1a5e1cb9eaed99c1b5dfed6, O_RDWR) failed: No such file or directory (2) in /hermes/bosweb25a/b109/ipg.removalspacecom/admin01.php on line 2 Warning: session_start() [function.session-start]: Cannot send session cookie - headers already sent by (output started at /hermes/bosweb25a/b109/ipg.removalspacecom/admin01.php:2) in /hermes/bosweb25a/b109/ipg.removalspacecom/admin01.php on line 2 Warning: session_start() [function.session-start]: Cannot send session cache limiter - headers already sent (output started at /hermes/bosweb25a/b109/ipg.removalspacecom/admin01.php:2) in /hermes/bosweb25a/b109/ipg.removalspacecom/admin01.php on line 2 There are 1 removalspace users so far. Company Name Contact Name Contact Number Email Address Line 1 Address Line 2 Location Postcode Basic Members Upgraded Users Company Logo Approved none none none andy_b_1502@hotmail.co.uk none none none none Current level = 0 Level 1 - Free Level 2 - Basic Level 3 - Premium Level 0 - Do Not Display Warning: Unknown: open(/home/users/web/b109/ipg.removalspacecom/cgi-bin/tmp/sess_9b495d20f1a5e1cb9eaed99c1b5dfed6, O_RDWR) failed: No such file or directory (2) in Unknown on line 0 Warning: Unknown: Failed to write session data (files). Please verify that the current setting of session.save_path is correct (/home/users/web/b109/ipg.removalspacecom/cgi-bin/tmp) in Unknown on line 0 Admin01.php Code: [Select] <?PHP session_start(); /* really need to use a session variable to insure authorized to be here */ include ('db.php'); /* ======================================== 99% of the time it is better to put your query in a string. It makes debugging much easier ======================================== */ $query = "SELECT * FROM companies"; $result = mysql_query($query ) or die("SELECT Error: ".mysql_error()); $num_rows = mysql_num_rows($result); /* ======================================== I find it easier to locate problems if I indent code properly and drop out of PHP if there are large sections of html ======================================== */ ?> <br><br><br>There are <?PHP echo $num_rows; ?> removalspace users so far.<P> <table width="819" height="114"> <tr> <th>Company Name</th> <th>Contact Name</th> <th>Contact Number</th> <th>Email</th> <th>Address Line 1</th> <th>Address Line 2</th> <th>Location</th> <th>Postcode</th> <th>Basic Members</th> <th>Upgraded Users</th> <th>Company Logo</th> <th>Approved</th> </tr> <tr> <td colspan="6"></td> </tr> <?PHP while ( $row = mysql_fetch_array($result, MYSQL_ASSOC )) { ?> <tr> <td><?PHP echo $row['company_name']; ?></td> <td><?PHP echo $row['contact_name']; ?></td> <td><?PHP echo $row['phone']; ?></td> <td><?PHP echo $row['email']; ?></td> <td><?PHP echo $row['street1']; ?></td> <td><?PHP echo $row['street2']; ?></td> <td><?PHP echo $row['location']; ?></td> <td><?PHP echo $row['postcode']; ?></td> <td><?PHP echo $row['basicpackage_description']; ?></td> <td><?PHP echo $row['premiumuser_description']; ?></td> <?PHP /* ======================================== I presume you want to show the thumb version here ======================================== */ ?> <td><img src="images/thumbs/<?PHP echo $row['upload']; ?>" alt="logo"/></td> </tr> <tr> <td colspan="10"> <table> <tr> <td>Current level = <?PHP echo $row['approved']; ?></td> <td><a href="admin02.php?id=<?PHP echo $row['id']; ?>&level=1">Level 1 - Free</a></td> <td><a href="admin02.php?id=<?PHP echo $row['id']; ?>&level=2">Level 2 - Basic</a></td> <td><a href="admin02.php?id=<?PHP echo $row['id']; ?>&level=3">Level 3 - Premium</a></td> <td><a href="admin02.php?id=<?PHP echo $row['id']; ?>&level=0">Level 0 - Do Not Display</a></td> </tr> </table> </tr> <?PHP } echo "</table>"; ?></table> Then when i click to change something e.g level of user, i get this error message: Code: [Select] Warning: session_start() [function.session-start]: open(/home/users/web/b109/ipg.removalspacecom/cgi-bin/tmp/sess_d986479c3603a52a37390b24a12caf03, O_RDWR) failed: No such file or directory (2) in /hermes/bosweb25a/b109/ipg.removalspacecom/admin02.php on line 2 Warning: session_start() [function.session-start]: Cannot send session cookie - headers already sent by (output started at /hermes/bosweb25a/b109/ipg.removalspacecom/admin02.php:2) in /hermes/bosweb25a/b109/ipg.removalspacecom/admin02.php on line 2 Warning: session_start() [function.session-start]: Cannot send session cache limiter - headers already sent (output started at /hermes/bosweb25a/b109/ipg.removalspacecom/admin02.php:2) in /hermes/bosweb25a/b109/ipg.removalspacecom/admin02.php on line 2 Warning: Cannot modify header information - headers already sent by (output started at /hermes/bosweb25a/b109/ipg.removalspacecom/admin02.php:2) in /hermes/bosweb25a/b109/ipg.removalspacecom/admin02.php on line 9 Warning: Unknown: open(/home/users/web/b109/ipg.removalspacecom/cgi-bin/tmp/sess_d986479c3603a52a37390b24a12caf03, O_RDWR) failed: No such file or directory (2) in Unknown on line 0 Warning: Unknown: Failed to write session data (files). Please verify that the current setting of session.save_path is correct (/home/users/web/b109/ipg.removalspacecom/cgi-bin/tmp) in Unknown on line 0 Admin02.php Code: [Select] <?PHP session_start(); /* really need to use a session variable to insure authorized to be here */ include('db.php'); $id = (int) $_GET['id']; $level = (int) $_GET['level']; $query = "UPDATE companies set approved = '$level' WHERE id = '$id'"; $result = mysql_query($query); header("Location: admin01.php"); ?> Can someone please help with this please? Hi All, I am sorry to bother you but wondered if you might be able to spot my mistake... When I click on this page http://www.freepspwallpaper.co.uk/free-psp-wallpapers/free-babes-psp-wallpapers/ if returns an error as below (look carefully its hidden behind the header color). Im a bit of a newbie and cannot seem to remove it. Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /home/freepspw/public_html/dbconnect.php on line 22 Can anyone help? Peter I have the following code Code: [Select] $hidden_client_id_query = mysql_query("SELECT id from `pdp_client_info` WHERE lead_id='$post_lead_id'"); $hidden_client_id=mysql_fetch_assoc($hidden_client_id_query); $this->view->hidden_client_id=$hidden_client_id['id']; I get the following error for the above code. I wonder where I am wrong. I am getting the $post_lead_id as expected. Warning: mysql_fetch_assoc() expects parameter 1 to be resource, boolean Hello if some one be nice to help me out it be most kind... i got this error "Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in/home/23url/public_html/new.php on line 66" the code is - $getbans =mysql_query("SELECT banned FROM $tab[banned];"); $bans = array(); LINE 66 > while($ban=mysql_fetch_array($getbans)) { array_push($bans, $ban[0]); } many thanks Even though the path is right I am getting a warning: Code: [Select] Warning: include(/php_projects/myproject/controller/registering/register_2.php) [function.include]: failed to open stream: No such file or directory in C:\xampp\htdocs\php_projects\myproject\controller\authentication\login_register.php on line 7 I am trying to include the file register_2.php into login_register.php, and the path is right I double checked it, I am trying to use an absolute path excluding the domain instead of a relative path. This is how I include the login_register.php file: Code: [Select] <?php include ($register_2); ?> And this is the path.php file just to showcase: Code: [Select] // The Login Register Page $register_2 = root . "controller/registering/register_2.php"; $login_2 = root . "controller/authentication/login_2.php"; And the define function: Code: [Select] define('root', '/php_projects/myproject/'); With other paths this method does work, but it does not seem to work with paths which are a bit deeper in the structure. And I am wondering, why? Even using the domain, which means, putting the localhost in front of it does not work. Only a relative path will work. Code: [Select] <?php $liked = ("SELETCT SUM(user_id) as totaluser_id FROM liked WHERE `user_id`='26762'"); $liked_results = mysql_query($liked); $sum_liked = mysql_result($liked, 0); // <--- Error echo $sum_liked; ?> i got this error Warning: mysql_result(): supplied argument is not a valid MySQL result resource in can sombady help? |
|||||||