PHP - MySQL
» JanMolendijkI have this database for my comments
Now i wanna count the comments from citem
Type Collatie Attributen
1 cnumber int(11)
2...Last post » AdminHello,
1. This is the syntax that you can use to sum numeric values from a column into a mysql table:
SELECT SUM(col_name) AS snr FROM table_name...
» JanMolendijkNow i have my next problem & can`t find out what i must do to complete.
I have three mysql tables:
Type Collatie Attributen Leeg...Last post » AdminHello
Try with this code (see the relations with the IDs between tables):
$sql = SELECT A.`user_firstname`, A.`user_lastname`, B.`mem_id`,...
» JanMolendijkI looking for a example how to select data from two data-bases
i have a table group with: group_id, club_id & member_id
i have a table user...Last post » JanMolendijkI tried this morning a view thinks & had result just before your posting
Great support Admin thanks i`m view day`s buissy to find out how tables...
» Ja42laError: Apache shutdown unexpectedly.
8:59:36 AM This may be due to a blocked port, missing dependencies,
8:59:36 AM improper privileges, a crash, or...Last post » AdminHello
Not sure what the problem is, from what the error message says, it is possible that another application runs on the port set for Apache, or...
» Admin- If you want to do multiple COUNT(), in multiple tables, and output them in a single SELECT statement with each COUNT being a column; you can use a...
» melmdoostI have a question. it is my last question.
i use persian name in file name.
when i upload a file (with persian name) and move it to upload folder,...Last post » Admin- Or, in the same approach you can encode /decode the file name with base64:
1. When uploading the file, apply base64_encode() to name (without...
i have a script for upload file. this script has a problem with duplicate names, in upload folder. i want rename file name in upload folder....Last post » AdminThe character : is not allowed in file name; so, you should replace it with - or _ in the string with the time.
$time = date( H-i-s ,...
» JanMolendijkI wanna use this script but make a form field from it were i can add text into the forms INSERT INTO `users`,on:Last post » JanMolendijkThanks for the support i had to look better & found the way
» mluci12I use mysql Inner join with php for a select from two data tables.But the resuts are duplicated because in one table i have more results with that...Last post » AdminThe group_concat() is not for file, it is a mysql function that returns a string with concatenated non-NULL value from a group of rows (separated by...
» mluci12How can i display the selected mysql row into html table cells?Last post » AdminSee the tutorial from:
- Or search on the net for: mysql select in html table .
» AdminThis php script can be used to print a MySQL table data to HTML table.
$conn = new mysqli('localhost', 'root', 'password', 'dbname');...
» mluci12How can i rename file with current date ( month/years/minute/secondes.file_extension ) in the code from:Last post » AdminTry to use the code from this example:
$set_name = date('Y-m-d-H-i-s');
$fname = preg_replace('/(.+?)\.( +)$/i', $set_name...
» JanMolendijkI have this code to update one from your scripts
But if i select the option Other it does not stay in de admin on this same line
I hope you could...Last post » JanMolendijkThank you Admin for the support
» JanMolendijkI wanna use this code but only a single row, do you known how to select it ?
// SELECT sql query
$sql = SELECT `id`, `name`, `pass` FROM `users` ;Last post » JanMolendijkI found the answer i have to do this
// SELECT sql query
$sql = SELECT `user_longbio`, `user_id` FROM `user` WHERE `user_id`='10000' ;
» JanMolendijkI run two different scripts for both i have an log-in system.
But how can i make an register for two data-bases ?Last post » JanMolendijkok thank you for the answer i gonna try some things
» JanMolendijkI hope you could help me out with this problem
$query = mysqli_query( SELECT *...Last post » AdminHello
You have to the object with the mysqli connection:
$query = $conn->query( ... );
$query = mysqli_query( ... , $conn);
» JanMolendijkHow can i give users an php webpage into a map on my server when they register ?Last post » JanMolendijkMy explain is meight bit pity so i try again
I found this script
But now i wanna create an php file on my server
with data when users...
» JanMolendijkI wanna add text into an textarea where i have html code into the title but it does not show the whole html code into the textarea.
Title:...Last post » AdminIn <textarea> you not have to add data in value attribute, but between starting and ending tags.
Try simple like this:
» JanMolendijkI wanna Delete records from a database, but i want to choose what record i delete into an text-area with delete-button
(i where able to find this...Last post » JanMolendijkYou doing Great Work `thanks for the support`
& also thanks to coursesweb.net i have
» JanMolendijkFirst thing it stay`s an great website
i learning alot & i`m thankfully.
I getting this error & ask myself what is wrong
Deprecated:...Last post » AdminHello,
Welcome to this website.
It seems you use an old php script, which uses the mysql_connect() function for working with mysql database.
» JanMolendijkFirst great website i learning alot `thanks for this`
I did not found an example how to add text into the SQLdatabase from a...Last post » JanMolendijkthanks for the quick answer you all do greatest work
i gonna try this code hope i`m able to complete
I am using this script to insert data from a Form into a Database. I am new to PHP and trying to learn. However, after 3 days of banging my head...Last post » AdminA documentation complete about Strings and Quotes in php you can find to this page: PHP Strings (in the php manual from php.net).
- Or, you can find...
Order database results 188 1
» mluci12Hello!i have this page: autobelgia.ro/listings.html and database:
Id | content | type
How can i order database results after select ? First display...Last post » AdminHi,
I don't know.
If there is a php-mysql issue, put the php and mysql code that you use to make and output Selecting data.
» mluci12Please help me! I have this code but don't redirect to submit2.WHY?
require('layout-submit1.php');...Last post » AdminHello,
The code mysql_query($sql, $conn) is incorrect. Maybe the script it uses MySQLi; in this case you should put: $conn->query($sql) .
I have page: autobelgia.ro/submit1.html from to: autobelgia.ro/submit5.html from autobelgia.ro/submit1.html to submit5.html user complete...Last post » AdminHello,