Do plants absorb phosphate from the soil or from water?

It is absorbed from the soil. There are no phosphates in water, though water can help phosphates and other nutrients enter the roots of plants.