PHP - MySQL
-
» JanMolendijk I need your help again i cant find out how to select a specific id to show
i have this address:...
Last post » JanMolendijk After day working i finaly found it out.
i added this code:
$id = (int) $_GET ;
$sql = $conn->query( select * from user where id=$id );
-
» mlucicom i have two php files:
the index.php ---
<?php
$id = 3 ;
if(!empty($_POST )) {
$conn = mysql_connect( localhost , website_rent , password...
Last post » Admin I not know way it not works; maybe data from the resulted sql query is not ok for that mysql table structure.
If there is no message with errors,...
-
» JanMolendijk I have this database for my comments
Now i wanna count the comments from citem
c66u_nucleus_comment
Type Collatie Attributen
1 cnumber int(11)
2...
Last post » Admin Hello,
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...
-
» JanMolendijk Now i have my next problem & can`t find out what i must do to complete.
I have three mysql tables:
user
Type Collatie Attributen Leeg...
Last post » Admin Hello
Try with this code (see the relations with the IDs between tables):
$sql = SELECT A.`user_firstname`, A.`user_lastname`, B.`mem_id`,...
-
» JanMolendijk I 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 » JanMolendijk I 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...
-
» Ja42la Error: 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 » Admin Hello
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...
-
» melmdoost I 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...
-
» melmdoost Hello.
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 » Admin The 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 ,...
-
» JanMolendijk I 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 » JanMolendijk Thanks for the support i had to look better & found the way
-
» mluci12 I 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 » Admin The 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...
-
» mluci12 How can i display the selected mysql row into html table cells?
Last post » Admin See the tutorial from:
- Or search on the net for: mysql select in html table .
-
» Admin This php script can be used to print a MySQL table data to HTML table.
$conn = new mysqli('localhost', 'root', 'password', 'dbname');...
-
» mluci12 How can i rename file with current date ( month/years/minute/secondes.file_extension ) in the code from:
Last post » Admin Try to use the code from this example:
$fname ='file-name.ext';
$set_name = date('Y-m-d-H-i-s');
$fname = preg_replace('/(.+?)\.( +)$/i', $set_name...
-
» JanMolendijk I 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 » JanMolendijk Thank you Admin for the support
-
» JanMolendijk I 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 » JanMolendijk I found the answer i have to do this
// SELECT sql query
$sql = SELECT `user_longbio`, `user_id` FROM `user` WHERE `user_id`='10000' ;
-
» JanMolendijk I 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 » JanMolendijk ok thank you for the answer i gonna try some things
-
» JanMolendijk I hope you could help me out with this problem
<?php
session_start();
include_once 'dbconnect.php';
if(!$mid){
$query = mysqli_query( SELECT *...
Last post » Admin Hello
You have to the object with the mysqli connection:
$query = $conn->query( ... );
//OR:
$query = mysqli_query( ... , $conn);
-
» JanMolendijk How can i give users an php webpage into a map on my server when they register ?
Last post » JanMolendijk My 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...
-
» JanMolendijk I 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 » Admin In <textarea> you not have to add data in value attribute, but between starting and ending tags.
Try simple like this:
Title: <textarea...
-
» JanMolendijk I 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 » JanMolendijk You doing Great Work `thanks for the support`
& also thanks to coursesweb.net i have
this Web-Site:
-
» JanMolendijk First 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 » Admin Hello,
Welcome to this website.
It seems you use an old php script, which uses the mysql_connect() function for working with mysql database.
That...
-
» JanMolendijk First great website i learning alot `thanks for this`
My Question:
I did not found an example how to add text into the SQLdatabase from a...
Last post » JanMolendijk thanks for the quick answer you all do greatest work
i gonna try this code hope i`m able to complete
-
» Waylon Hi:
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 » Admin A 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...
-
» mluci12 Hello!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 » Admin Hi,
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.
Forum permissions
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot post attachments in this forum
I need your help again i cant find out how to select a specific id to show